How to print repeated rows on top in excel

To print repeated rows on top in Excel, use the Print Titles feature that repeats selected header rows on every printed page for clear reference during multi-page printing.

How to set repeated rows on top in Excel

To set repeated rows on top in Excel, follow these steps:

1. Go to the Page Layout tab.

2. Select Print Titles in the Page Setup group.

3. Locate the Page Setup dialog box that appears.

4. Find the Sheet tab inside the dialog box.

5. Click inside the Rows to repeat at top field.

6. Select the row(s) you want to repeat by clicking the row headers on the sheet.

7. Confirm the selection in the field (for example, $1:$1 for the first row).

8. Select OK to apply the settings.

9. Use File > Print to preview the result before printing.

Differences Between Windows and Mac

Windows:
The Print Titles command appears directly in the Page Layout tab. The Page Setup dialog box opens immediately after selecting Print Titles.

Mac:
The Page Setup dialog box appears inside the Layout section of the Print window. The Rows to repeat at top field is found within the Sheet tab of that dialog box. The steps remain identical after opening the dialog box.

Important Notes for Consistency

• Excel prints repeated rows on every page when multi-page printing occurs.

• The feature supports any number of header rows.

• The feature works for both portrait and landscape page setups.

• The feature remains active until removed from the Page Setup dialog.

• The feature improves readability and maintains consistent reference across printed pages.