How to repeat the header row on every page of an Excel PDF

Short answer: To repeat the header row on every page of an Excel PDF, go to Page Layout, click Print Titles, and in “Rows to repeat at top” select your header row. Excel then reprints those rows at the top of every page in the export (for example $1:$1 repeats row one). The common mistake is using Freeze Panes, which only holds the header on screen and does nothing for printing or PDF export. Print Titles is the setting that carries into the PDF.

Step by step

1. Open the sheet and go to the Page Layout tab.
2. Click Print Titles (in the Page Setup group).
3. In the Sheet tab, click inside Rows to repeat at top.
4. Click the row number of your header (or drag across several header rows) so the box shows something like $1:$1.
5. Click OK, then export or print. Every page now carries the header.

Why Freeze Panes does not work

Freeze Panes is a viewing aid: it pins rows or columns while you scroll the sheet on screen. It has no effect on pagination, so a frozen header vanishes after page one in the PDF. Print Titles is a separate, print-specific setting, which is why it is the one that survives export.

A couple of things that trip people up

• The Print Titles button is greyed out. That happens when you open the dialog from the Print preview screen. Open it from the Page Layout tab on the normal sheet view instead.
• It is per sheet. Print Titles is set for one worksheet at a time, so repeat it on each sheet that needs a header.
• Wide tables still need a plan for the columns. Repeating the header fixes the vertical problem (headers on page two and beyond). If the table is also too wide for the page, that is a separate issue: either narrow it, print landscape, or use a converter that slices wide tables across pages at a readable size and repeats headers as it goes.

If a wide, multi-page table is a recurring export for you, CrazySmartPDF re-lays-out the sheet and is free to run on your own files.

FAQ

What is the difference between Freeze Panes and Print Titles? Freeze Panes holds rows or columns in place on screen only; Print Titles repeats chosen rows or columns on every printed or exported page. For a PDF, you need Print Titles.

Can I repeat both a header row and a label column? Yes. In the same Print Titles dialog, use “Rows to repeat at top” for the header and “Columns to repeat at left” for a label column.

Why did my repeated header disappear in the PDF? Almost always because Freeze Panes was used instead of Print Titles, or because Print Titles was set on a different sheet. Set “Rows to repeat at top” on the exact sheet you are exporting.