Print Titles

Microsoft Excel 2010

The Print Titles features allows you to select specific rows to repeat at the top of each page when you print your worksheet.

  1. Display the Page Layout ribbon and click on the Print titles button (within the Page Setup area of the ribbon). The following window appears:
  2. To repeat rows on each page, click in the Rows to repeat at top field then select the row(s) on your worksheet that you would like to repeat.
  3. To repeat columns on each page, click in the Columns to repeat at left field then select the column(s) on your worksheet that you would like to repeat.
  4. Choose OK to finish.

Additional References