Repeat Excel header rows on every printed page so readers can identify columns in a long report. These steps cover desktop Excel for Windows.
Choose the heading rows
Identify the rows that label your data. For example, row 1 might contain column names, while rows 1 and 2 might hold a grouped heading and its labels. Choose only the rows readers need on each page.
Set Print Titles
- Open the worksheet and select Page Layout > Print Titles.
- On the Sheet tab, locate Rows to repeat at top.
- Enter $1:$1 to repeat the first row. Use $1:$2 for the first two rows, or $1:$3 for the first three.
- Select OK.
Check the printed layout
Open File > Print and inspect the second and later pages in preview. Confirm the heading rows appear, column widths remain readable and no important content is clipped. If your report fits on one page, test with a longer worksheet before judging whether repetition works.
Print Titles controls printed headings. To keep rows visible while scrolling on screen, use Freeze Panes.
If Print Titles is greyed out
Finish editing the active cell, make sure you are not editing an area chart, and check that Windows has a printer configured.
To remove the repeated headings later, reopen Print Titles, clear Rows to repeat at top, and check preview again.

