Repeat specific rows or columns on every printed page

If a worksheet spans more than one page, you can print row and column headings or labels (also called print titles) on every page to ensure that the data is properly labeled.

  1. Select the worksheet that you want to print.

  2. On the Page Layout tab, in the Page Setup group, click Print Titles.

    Excel Ribbon Image

    Note: The Print Titles command will appear dimmed if you are in cell editing mode, if a chart is selected on the same worksheet, or if you don’t have a printer installed. For more information about installing a printer, see finding and installing printer drivers for Windows Vista. Please note that Microsoft has discontinued support for Windows XP; check your printer manufacturer's Web site for continued driver support.

  3. On the Sheet tab, under Print titles, do one or both of the following:

    • In the Rows to repeat at top box, type the reference of the rows that contain the column labels.

    • In the Columns to repeat at left box, type the reference of the columns that contain the row labels.

      For example, if you want to print column labels at the top of every printed page, you could type $1:$1 in the Rows to repeat at top box.

      Print titles options highlighted in Page Setup dialog box

      Tip: You can also click the Collapse Dialog button Collapse button again to return to the dialog box.

      Note: If you have more than one worksheet selected, the Rows to repeat at top and Columns to repeat at left boxes are not available in the Page Setup dialog box. To cancel a selection of multiple worksheets, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

Was this information helpful?

How can we improve it?

How can we improve it?

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!