How to repeat Excel column headers on every PDF page
Set Excel print titles before exporting, distinguish cell labels from worksheet headings, and check every continuation page in the saved PDF.
To repeat Excel column headers on every PDF page, set Print Titles in the desktop workbook before creating the PDF. Choose the rows containing your labels, check the print preview, then inspect the saved PDF. Freezing the top row for scrolling does not replace this print setting.
Set repeating rows in Excel for Windows
- Select the worksheet you will export. If several sheet tabs are selected, ungroup them first.
- Open Page Layout → Print Titles, then the Sheet tab.
- In Rows to repeat at top, enter the header-row reference. Use
$1:$1for row 1 or$1:$2for rows 1 and 2. You can also use the range selector to select those rows. - Confirm the setting and open print preview. Look at a later page, not just page one.
- Create the PDF using your usual Excel PDF output path, then reopen that file to check the result.
Microsoft documents these controls in its guide to repeating rows and columns. If Print Titles is unavailable, leave cell-editing mode and deselect any chart. Microsoft also identifies a missing printer as a possible cause. Repeating-row fields are unavailable when multiple worksheets are selected.
Mac and browser differences
On Excel for Mac, select the sheet and open Page Layout → Page Setup → Sheets. Under Print Titles, select the rows to repeat, confirm, and check the preview. See Microsoft’s Mac instructions.
Excel for the web currently cannot repeat column headers when printing, according to Microsoft’s desktop and web comparison. Open the workbook in desktop Excel to apply this workflow. Menu labels can vary by version.
Example: a three-page equipment list
Suppose a worksheet has a report title in row 1 and the labels Item, Location and Quantity in row 2. Its records span three PDF pages. This is a hypothetical example, not a product screenshot.
| Desired result | Rows to repeat | What to check |
|---|---|---|
| Labels on every page | $2:$2 | Page 2 begins with Item, Location and Quantity |
| Report title and labels on every page | $1:$2 | Both rows appear above later records |
| Labels plus left-side item identifiers on wide pages | Header rows plus the appropriate Columns to repeat at left range | Horizontal continuation pages remain understandable |
Keep the repeated range small: repeating a large introductory block takes space away from records on each page. Confirm that no data row is unintentionally included in it.
Labels are different from A, B, C headings
Excel’s row and column headings are the numbered and lettered worksheet edges. They are different from labels you type into cells. Turning on printing for those headings does not repeat your Item or Quantity labels. Microsoft explains this distinction in its row and column headings guide.
Check the exported PDF before assembling a packet
- Inspect every continuation page for the correct labels and readable text.
- Compare the last record before each page break with the first record after it. A repeated header should not conceal a missing record.
- If the text is too small, use the Excel PDF scaling checklist. If extra pages appear, check print ranges and blank-page causes.
Correct missing headers in the workbook and export again. Merging existing PDF pages does not apply Excel print titles. Once the export is correct, open AlphaPDF’s merge tool to combine it with a cover or other PDF documents, following the PDF assembly guide. Reopen the combined download and check the page transitions again.
Comments
Comments are reviewed before appearing here. Your email is never displayed.
No approved comments yet.
Join the conversation