Cellwise Start free

Excel guide · 6 min read

Excel print titles not working: how to repeat the header row on every page

Quick answerGo to Page Layout > Print Titles, and on the Sheet tab type the header rows in Rows to repeat at top (for example $1:$1, or $3:$3 if your headers sit in row 3), then check the result in Print Preview. If the box is greyed out, you're editing a cell, a chart is selected, no printer is installed, or several sheets are grouped: press Esc, click a cell, or right-click a tab > Ungroup Sheets.

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.

RowABCDEFGHI
1West region order log, Q3Header row3
2Exported from the order system on 2 OctRows to repeat$3:$3
3Order IDDateCustomerProductQtyAmountOrders9
4SO-4101Mar 7, 2026Harbor CafeEspresso beans 1kg12286.8
5SO-4102Mar 7, 2026Linden DentalPaper cups 500498
6SO-4103May 7, 2026Northgate GymProtein bars 24pk10359
7SO-4104Aug 7, 2026Harbor CafeOat milk 6pk8117.6
8SO-4105Sep 7, 2026Maple BooksEspresso beans 1kg371.7
9SO-4106Dec 7, 2026Quayside HotelTea sampler15412.5
10SO-410714/07/2026Linden DentalPaper cups 5006147
11SO-410815/07/2026Northgate GymElectrolyte mix20390
12SO-410919/07/2026Quayside HotelOat milk 6pk12176.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.

  1. Press Esc to leave cell editing, then click any normal cell (not a chart).
  2. If the title bar says Group, right-click a selected sheet tab and choose Ungroup Sheets.
  3. 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).
  4. 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.

  1. Page Layout > Print Titles.
  2. 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.
  3. Click Print Preview in the dialog, or OK and then Ctrl+P, and page forward to page 2.
=MATCH("Order ID",A1:A20,0)

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.

="$"&MATCH("Order ID",A1:A20,0)&":$"&MATCH("Order ID",A1:A20,0)

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

Updated