Excel guide · 6 min read
Excel print titles not working: how to repeat the header row on every page
Still not working on your sheet? Paste your cells and the formula into Cellwise Fix. The engine shows which cause it is on your data, then you get the fix, checked. Open Cellwise Fix
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D | E | F | G | H | I |
|---|---|---|---|---|---|---|---|---|---|
| 1 | West region order log, Q3 | Header row | 3 | ||||||
| 2 | Exported from the order system on 2 Oct | Rows to repeat | $3:$3 | ||||||
| 3 | Order ID | Date | Customer | Product | Qty | Amount | Orders | 9 | |
| 4 | SO-4101 | Mar 7, 2026 | Harbor Cafe | Espresso beans 1kg | 12 | 286.8 | |||
| 5 | SO-4102 | Mar 7, 2026 | Linden Dental | Paper cups 500 | 4 | 98 | |||
| 6 | SO-4103 | May 7, 2026 | Northgate Gym | Protein bars 24pk | 10 | 359 | |||
| 7 | SO-4104 | Aug 7, 2026 | Harbor Cafe | Oat milk 6pk | 8 | 117.6 | |||
| 8 | SO-4105 | Sep 7, 2026 | Maple Books | Espresso beans 1kg | 3 | 71.7 | |||
| 9 | SO-4106 | Dec 7, 2026 | Quayside Hotel | Tea sampler | 15 | 412.5 | |||
| 10 | SO-4107 | 14/07/2026 | Linden Dental | Paper cups 500 | 6 | 147 | |||
| 11 | SO-4108 | 15/07/2026 | Northgate Gym | Electrolyte mix | 20 | 390 | |||
| 12 | SO-4109 | 19/07/2026 | Quayside Hotel | Oat milk 6pk | 12 | 176.4 |
Download this sheet as an Excel practice file (.xlsx)
Quick checks
Print titles are rows (or columns) that Excel prints at the top (or left) of every page. They're set per sheet, saved with the workbook, and only visible in Print Preview and on paper. The sample is an order log whose real headers are in row 3, under a report title and an export note, which is exactly the layout that trips people up.
- Rows to repeat at top is greyed out? See cause 1.
- Page 2 prints the report title instead of the column headers? You picked the wrong rows (cause 2).
- Titles are set but you can't see them? They never show in Normal view (cause 3).
- Wide report loses the name column on later pages? Use Columns to repeat at left (cause 4).
- Works on one sheet but not the others? Each sheet has its own titles (cause 5).
- Want the A, B, C letters and row numbers on paper? That's a different setting (cause 6).
1. Rows to repeat at top is greyed out
Microsoft lists the reasons the Print Titles command or its boxes are unavailable: you're in cell editing mode (a cursor is blinking in a cell or the formula bar), a chart is selected on the sheet, no printer is installed, or more than one sheet is selected. Grouped sheets are the sneaky one: the title bar shows Group, and anything you type lands on every selected sheet.
Another common trap: opening Page Setup from the link at the bottom of the File > Print screen. If the Print titles boxes are dimmed there, close it and open the dialog from Page Layout > Print Titles instead, with the sheet itself active.
- Press Esc to leave cell editing, then click any normal cell (not a chart).
- If the title bar says Group, right-click a selected sheet tab and choose Ungroup Sheets.
- If there's no printer at all, add one in your computer's printer settings (a PDF printer such as Microsoft Print to PDF counts).
- Go to Page Layout > Print Titles. The Page Setup dialog opens on the Sheet tab with the boxes available.
2. You repeated the wrong rows
The box wants whole rows, written with dollar signs: $1:$1 for row 1, $1:$3 for rows 1 to 3. In the sample the headers are in row 3, so $1:$1 repeats the report title on every page while the column names only appear on page 1. Use $3:$3 to repeat just the headers, or $1:$3 to keep the title block too.
On a long sheet where you're not sure which row holds the headers, find it with MATCH on a header you know.
- Page Layout > Print Titles.
- Click in Rows to repeat at top, then click the row number of the header row on the sheet (Excel writes $3:$3 for you), or type it.
- Click Print Preview in the dialog, or OK and then Ctrl+P, and page forward to page 2.
Result: 3
3: the "Order ID" header is in row 3, so type $3:$3 in Rows to repeat at top.
Can a formula write the reference for me?
Yes, as a helper. Paste its result into the box; the box itself only takes a plain row reference.
Result: $3:$3
$3:$3, the reference to type in Rows to repeat at top.
3. The titles are set but you can't see them
Print titles don't show in Normal view, and they only repeat from page 2 onward (page 1 already has the real header rows). With 9 orders the sample fits on one page, so there's nothing to repeat yet. Check with Ctrl+P and the page arrows under the preview, or View > Page Break Preview to see where page 2 starts. (Back in Normal view, the dotted lines that mark the pages can be hidden: see remove dotted page break lines.)
If you want the headers to stay visible while you scroll on screen, that's Freeze Panes, not print titles. They do different jobs, and most long reports need both: see freeze panes in Excel.
4. Wide reports: repeat columns on the left
When a report is too wide for one page, Excel prints the extra columns on later pages, and those pages have numbers with no names next to them. In the same Sheet tab, type $A:$A in Columns to repeat at left (or $A:$B for an ID and a name). Rows and columns can repeat at the same time.
Often the better fix is fewer pages: in the Print screen choose Fit All Columns on One Page so every row carries its own labels. The full set of scaling options is in print an Excel sheet on one page.
5. Each sheet needs its own print titles
Print titles belong to one sheet. Setting them on the July sheet does nothing for August, and you can't set them while sheets are grouped (that's why the boxes go grey). Set them on one sheet at a time. A copied sheet usually brings its page setup with it, so it's quicker to finish one month and copy it than to fix twelve sheets later.
If the printout also shows the wrong cells, the print area is a separate setting on the same Page Setup tab: see Excel print area not working.
6. Print titles vs printing row and column headings
Some people mean the grey A, B, C letters and 1, 2, 3 row numbers. Those are headings, and Excel doesn't print them by default. Turn them on with Page Layout > Sheet Options > Headings > Print. It's handy when you hand someone a printout and say "look at row 7". Print titles, in contrast, repeat your own header text.
Common mistakes
Typing $1:$1 when the headers are lower down
Repeat the row that holds the column names ($3:$3 here), or the whole title block ($1:$3).
Setting titles with sheets grouped
The boxes are unavailable while sheets are grouped. Right-click a tab > Ungroup Sheets and set each sheet.
Checking in Normal view
Titles only show in Print Preview and on paper, from page 2 on.
Using Freeze Panes and expecting it to print
Freezing is screen-only. Use Print Titles for paper.
FAQ
Why is Rows to repeat at top greyed out in Excel?
You're editing a cell, a chart is selected, no printer is installed, or several sheets are grouped. Press Esc, click a cell, ungroup the sheets, then open Page Layout > Print Titles.
How do I repeat the top row on every printed page?
Page Layout > Print Titles, then type $1:$1 in Rows to repeat at top on the Sheet tab and click OK. Use the row that actually holds your headers.
Why doesn't my header row show on page 2?
Either the wrong rows are set, the titles were set on another sheet, or the data fits on one page. Check in Print Preview and page forward.
Do print titles work in Excel for the web?
Excel for the web has fewer page setup options than the desktop app. If you can't find Print Titles there, open the file in the desktop app, set them, and save; the setting is stored in the workbook.
Functions used
Related guides
- How to add a header in Excel
- How to print gridlines in Excel
- Excel print area not working: why it prints the wrong cells and how to fix it
- How to print an Excel sheet on one page
- How to freeze panes in Excel
- #REF! error in Excel
Updated