How to repeat rows at the top of page using the print option

Have you ever printed a multi-page excel spreadsheet only to realize that  the row headings only appear on the first page?   Well, by using the rows to repeat at top print option you are able to repeat the row headings on every page.  Follow the steps below on how that can be done.

Applies To: Excel 2003, 2007 and 2010

1. Determine which row to be repeated

2. From the Page Layout tab, in the Page Setup group, select Print Titles

3. Select the Collapse Dialogue button in the Rows to Repeat at Top

4. Select the desired row

5.  Press Enter

6.  Select OK

If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email enablement@alchemex.com and yours could be the next Tip of the Week.

Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations

Further Reading:

1. Highlighting rows in which data appears using the conditional formatting formula function
2. Using the transpose option, you can return a horizontal range of cells as a vertical range, or vice versa.
3. Filtering on Rows and Columns in a PivotTable
4. LARGE Function
5. REPT Function