If a long Excel sheet prints with headings only on page 1, you can fix it with Print Titles. This setting repeats your header row, label columns, or both on every printed page. This guide covers Excel for Windows only. It gives the steps, plus the fixes for when the button is greyed out or the boxes are missing.
Microsoft calls these repeated labels "print titles." It lists Excel for Microsoft 365, Excel 2024, 2021, 2019 and 2016 as supported.
Set a header row to print on every page
- Open the worksheet you want to print.
- Go to the Page Layout tab. In the Page Setup group, click Print Titles.
- The Page Setup dialog opens on the Sheet tab. Under Print titles, click in Rows to repeat at top.
- Type the reference of the row that holds your column labels. If your headings are in row 1, type:
$1:$1
- Click OK, then print or check the print preview.
That $1:$1 example comes directly from Microsoft's print titles instructions.
Select the rows with the mouse instead of typing
You don't have to type the reference yourself. Each box has a small button at its right end. Microsoft's pages call it Collapse Popup Window or Collapse Dialog. Click it, select the title rows on the sheet, then click the button again to return to the dialog. Excel fills in the reference for you, according to Microsoft.
Repeat a label column on every page
Wide sheets that print across several pages have the opposite problem: the row labels in the first column only appear on the first page across. The fix is in the same dialog.
- Go to Page Layout > Page Setup > Print Titles.
- On the Sheet tab, click in Columns to repeat at left.
- Enter the reference of the columns that contain your row labels. You can also use the collapse button and select them on the sheet.
- Click OK.
You can fill in both boxes at once. Then every page gets the header row along the top and the label columns down the left, as Microsoft's page describes.
Fix a greyed-out Print Titles button
If Print Titles is dimmed on the Page Layout tab, Microsoft's support page gives three causes:
- You're editing a cell. If the cursor is blinking inside a cell or the formula bar, press Enter or Esc to leave editing mode.
- A chart is selected on the sheet. Click any ordinary cell so the chart is no longer selected.
- No printer is installed. Excel needs a printer set up in Windows before Print Titles becomes available. Microsoft's page links to a separate Windows article on fixing printer problems.
Fix missing "Rows to repeat at top" boxes
Sometimes the dialog opens, but Rows to repeat at top and Columns to repeat at left are unavailable. This usually means more than one sheet is selected. Grouped sheets show their tab names highlighted together, and Excel turns off the print titles boxes in Page Setup while sheets are grouped. Microsoft confirms this restriction.
To ungroup the sheets:
- Click any worksheet tab that isn't selected.
- If every visible tab is selected, right-click one of the selected tabs and choose Ungroup Sheets.
Then go back to Page Layout > Print Titles. The boxes should now be available.
Print Titles is not Freeze Panes or row and column headings
Three Excel features sound alike, and people often reach for the wrong one:
- Print Titles controls which of your rows and columns repeat on printed pages. Use it when you need headers on paper.
- Freeze Panes is a different command. If you froze your top row and expected it to print on each page, set Print Titles as well.
- Print row and column headings is a separate option. Microsoft covers it on its own page, which is linked from the print titles article. It is not the setting that repeats your own header row.
If you're preparing the sheet for other people to fill in before printing, you may also want to lock only some cells so the header row can't be changed by accident.