How to Repeat Specific Rows or Columns on Every Printed Page in Excel

00_lead_image_repeated_rows

If your worksheet takes up more than one page when printed, you can print row and column headings (also called print titles) on every page so your data is properly labeled, making it easier to view and follow your printed data.

Open the worksheet you want to print and click the “Page Layout” tab.

01_clicking_page_layout_tab

In the “Page Setup” section, click “Print Titles”.

NOTE: The “Print Titles” button is grayed out if you are currently editing a cell, if you’ve selected a chart on the same worksheet, or if you don’t have a printer installed.

02_clicking_print_titles

On the “Page Setup” dialog box, make sure the “Sheet” tab is active. Enter the range for the rows you want to repeat on every page in the “Rows to repeat at top” edit box. For example, we want the first row of our spreadsheet to repeat on all pages, so we entered “$1:$1”. If you want more than one row to repeat, for example rows 1-3, you would enter “$1:$3”. If you want to have the first column, as an example, repeat on every printed page, enter “$A:$A”.

02a_entering_rows_to_repeat

You can also select the rows you want to repeat using the mouse. To do so, click the “Collapse Dialog” button on the right side of the “Rows to repeat at top” edit box.

03_clicking_rows_to_repeat_at_top_button

The “Page Setup” dialog box shrinks to only show the “Rows to repeat at top” edit box.

04_selecting_row_to_repeat

To select the rows you want to repeat, move the cursor over the row numbers until it turns into a right arrow then either click on the one row you want or click and drag over multiple rows. The row range is inserted into the “Rows to repeat at top” edit box automatically. To expand the “Page Setup” dialog box, click the “Collapse Dialog” button again.

04a_clicking_on_rows_to_repeat

Once you’ve defined the rows and columns you want to repeat, click “OK”.

05_clicking_ok

NOTE: If you have more than one worksheet selected in your workbook, the “Rows to repeat at top” and “Columns to repeat at left” boxes are grayed out and not available in the “Page Setup” dialog box. You must only have one worksheet selected. To unselect multiple worksheets, click on any other worksheet that is not selected. If all worksheets are selected, right-click on any of the selected sheets and select “Ungroup Sheets” on the popup menu.

Lori Kaufman is a writer who likes to write geeky how-to articles to help make people's lives easier through the use of technology. She loves watching and reading mysteries and is an avid Doctor Who fan.