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

StepWhat to do
1Open the worksheet you want to print
2Page Layout tab > Page Setup group > Print Titles
3On the Sheet tab, click Rows to repeat at top
4Type $1:$1 to repeat row 1
5Select OK, then print

Repeat header rows step by step

  1. Select the worksheet you want to print.
  2. Go to the Page Layout tab and select Print Titles in the Page Setup group.
  3. In the Page Setup dialog, stay on the Sheet tab and find Print titles.
  4. Next to Rows to repeat at top, enter the reference for the rows with your column labels.
  5. 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 repeatWhat 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.

  1. Select the Collapse Dialog button at the right end of the Rows to repeat at top box.
  2. Select the title rows on the worksheet.
  3. 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.

ReasonWhat to do
You are editing a cellPress Enter or Esc to leave cell editing mode
A chart on the sheet is selectedClick a cell in the worksheet first
No printer is installedAdd 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.

OptionWhat it does
Print areaSets the range of the worksheet that prints
GridlinesIncludes gridlines in the printout, and they are off by default
Row and column headingsPrints the row numbers and column letters
Black and whitePrints in black and white on a colour printer
Draft qualityPrints faster at lower quality on printers that offer a draft mode
Page orderDown, then over, or Over, then down
Cell errors asShows 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.

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

TermMeaning in Microsoft’s Excel pages
HeadingsThe automatic letters and numbers Excel adds along the top and side of the grid
TitlesThe 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.

VersionCovered
Excel for Microsoft 365, 2024, 2021, 2019 and 2016 on WindowsYes, with the steps above
Excel for Microsoft 365 for MacYes, and the labels on the Page Layout tab are similar
Excel for the webNot covered by the main Print Titles page

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.

Leave a Reply

Your email address will not be published. Required fields are marked *