Skip to content
AnIntent

How to Repeat Header Rows on Every Printed Page in Excel

Set Print Titles in Excel so your header row prints at the top of every page, and fix the button when it's greyed out.

AnIntent Editorial · · 4 min read

white printing paper with numbers
Photo by Mika Baumeister on Unsplash
In this article
  1. Set a header row to print on every page
  2. Repeat a label column on every page
  3. Fix a greyed-out Print Titles button
  4. Fix missing Rows to repeat at top boxes
  5. Print Titles is not Freeze Panes or row and column headings
Share this article

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

  1. Open the worksheet you want to print.
  2. Go to the Page Layout tab. In the Page Setup group, click Print Titles.
  3. The Page Setup dialog opens on the Sheet tab. Under Print titles, click in Rows to repeat at top.
  4. Type the reference of the row that holds your column labels. If your headings are in row 1, type:
$1:$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.

  1. Go to Page Layout > Page Setup > Print Titles.
  2. On the Sheet tab, click in Columns to repeat at left.
  3. Enter the reference of the columns that contain your row labels. You can also use the collapse button and select them on the sheet.
  4. 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.

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.

Common questions

Why is Print Titles greyed out in Excel?

Microsoft lists three causes: you're in cell-editing mode, a chart is selected on the same worksheet, or no printer is installed.

Why can't I use Rows to repeat at top?

The box is unavailable when more than one sheet is selected. Click an unselected sheet tab, or right-click a selected tab and choose Ungroup Sheets.

What do I type to repeat the first row?

Type $1:$1 in the Rows to repeat at top box on the Sheet tab of the Page Setup dialog.

Can I repeat columns as well as rows?

Yes. Fill in Columns to repeat at left with the columns that hold your row labels. You can use it together with Rows to repeat at top.

Which Excel versions support Print Titles?

Microsoft's page lists Excel for Microsoft 365, Excel 2024, 2021, 2019 and 2016.

Hands typing on a laptop displaying a data spreadsheet
How-to

How to Use LET in Excel to Stop Repeating the Same Calculation

Use Excel's LET function to name a value or calculation once, reuse it inside a formula, and have Excel calculate it only one time.

· 4 min

More in Cloud & Productivity Software