The Print Titles features allows you to select specific rows to repeat at the
top of each page when you print your worksheet.
- Display the Page Layout ribbon and click
on the Print titles button (within the Page Setup area of the ribbon).
The following window appears:
- 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 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
- Choose OK to finish.