How To Repeat Header Rows On Every Printed Page In Excel (2026)
When a long Excel sheet prints over several pages, only the first page shows your column labels unless you tell Excel to repeat them.
The setting is called Print Titles, and Microsoft’s steps are the same for Excel 2016 through Microsoft 365.
Here is how to repeat a header row, a label column or both, and what to check when the option is greyed out.
Quick answer: repeat the top row
| Step | What to do |
|---|---|
| 1 | Open the worksheet you want to print |
| 2 | Page Layout tab > Page Setup group > Print Titles |
| 3 | On the Sheet tab, click Rows to repeat at top |
| 4 | Type $1:$1 to repeat row 1 |
| 5 | Select OK, then print |
Repeat header rows step by step
- Select the worksheet you want to print.
- Go to the Page Layout tab and select Print Titles in the Page Setup group.
- In the Page Setup dialog, stay on the Sheet tab and find Print titles.
- Next to Rows to repeat at top, enter the reference for the rows with your column labels.
- Select OK, then print the worksheet.
The reference for the first row is $1:$1, as shown in Microsoft’s example.
Repeat two or more header rows
If your labels sit in more than one row, enter a range instead of a single row.
| Rows to repeat | What to type in Rows to repeat at top |
|---|---|
| Row 1 only | $1:$1 |
| Rows 1 and 2 | $1:$2 |
| Rows 1 to 3 | $1:$3 |
Microsoft gives these examples on its page for printing the top row on every page.
Pick the rows with your mouse instead
You do not have to type a reference.
- Select the Collapse Dialog button at the right end of the Rows to repeat at top box.
- Select the title rows on the worksheet.
- Select the Collapse Dialog button again to return to the dialog.
This also works for the Columns to repeat at left box.
Repeat label columns on the left
For a wide sheet that prints across pages sideways, the Columns to repeat at left box does the same job for the columns that hold your row labels.
You can fill in both boxes together, so the labels appear along the top and the left side of every page.
If Print Titles is greyed out
Microsoft lists three reasons the button can be dimmed.
| Reason | What to do |
|---|---|
| You are editing a cell | Press Enter or Esc to leave cell editing mode |
| A chart on the sheet is selected | Click a cell in the worksheet first |
| No printer is installed | Add a printer in Windows, because Microsoft says Print Titles needs one |
If the printer is the problem, our guide to fixing Word or Excel not printing in Windows 11 may help.
If the boxes are not available
When more than one worksheet is selected, the Rows to repeat at top and Columns to repeat at left boxes are not available.
To cancel the selection, select a worksheet tab that is not selected.
If you cannot see one, right-click the tab of a selected sheet and choose Ungroup Sheets.
Other print options on the Sheet tab
While you are in the Page Setup dialog, the Sheet tab holds several other options from Microsoft’s Page Setup page.
| Option | What it does |
|---|---|
| Print area | Sets the range of the worksheet that prints |
| Gridlines | Includes gridlines in the printout, and they are off by default |
| Row and column headings | Prints the row numbers and column letters |
| Black and white | Prints in black and white on a colour printer |
| Draft quality | Prints faster at lower quality on printers that offer a draft mode |
| Page order | Down, then over, or Over, then down |
| Cell errors as | Shows errors as displayed, blank, a double hyphen or #N/A |
Choose the page order
Page order controls how a sheet that is both long and wide is numbered and printed.
Microsoft lists the two choices as Down, then over and Over, then down.
Check that the titles repeat
Select File > Print, or press Ctrl+P, to open the print screen.
Page through the preview from page 1 to the last page and confirm your rows sit at the top of every page.
If they are missing on some pages, go back to Page Setup and check the Print titles entries.
Watch out for a print area
Microsoft says that if a worksheet has a defined print area, Excel prints only that area.
If part of your sheet is missing from the printout, look for a print area on the Sheet tab, or choose the Ignore print area option when you print.
Titles are not the same as headings
| Term | Meaning in Microsoft’s Excel pages |
|---|---|
| Headings | The automatic letters and numbers Excel adds along the top and side of the grid |
| Titles | The text you type to describe your data, such as the labels in row 1 |
Print Titles repeats what you select and does not add anything new, so the labels have to exist on the sheet first.
Which Excel versions this covers
Microsoft’s page for repeating rows and columns applies to the desktop versions listed below.
| Version | Covered |
|---|---|
| Excel for Microsoft 365, 2024, 2021, 2019 and 2016 on Windows | Yes, with the steps above |
| Excel for Microsoft 365 for Mac | Yes, and the labels on the Page Layout tab are similar |
| Excel for the web | Not covered by the main Print Titles page |
Related printing fixes
If a wide sheet spills onto extra pages, see our guide to fitting an Excel sheet on one page.
To keep labels visible on screen while you scroll, use Freeze Panes instead, because Print Titles only affects the printed pages.
Sources
Microsoft Support: Repeat specific rows or columns on every printed page.
Microsoft Support: Print rows with column headers on top of every page.
Microsoft Support: Print the top row on every page.
Microsoft Support: Page Setup.
Microsoft Support: Print a worksheet or workbook.