Guides

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

  1. Select the worksheet you will export. If several sheet tabs are selected, ungroup them first.
  2. Open Page Layout → Print Titles, then the Sheet tab.
  3. In Rows to repeat at top, enter the header-row reference. Use $1:$1 for row 1 or $1:$2 for rows 1 and 2. You can also use the range selector to select those rows.
  4. Confirm the setting and open print preview. Look at a later page, not just page one.
  5. 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 resultRows to repeatWhat to check
Labels on every page$2:$2Page 2 begins with Item, Location and Quantity
Report title and labels on every page$1:$2Both rows appear above later records
Labels plus left-side item identifiers on wide pagesHeader rows plus the appropriate Columns to repeat at left rangeHorizontal 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

ALPHAPDF PRO

Explore paid tools

AlphaPDF Pro: $99/year · $12/month

An account and payment are required for PDF-to-JPG, all other converters and Premium tools. No free Premium jobs.

Compare free and paid access

Plan purchasing is not available here yet. Review supported inputs and limits before choosing a tool.

View pricing

Privacy choices

The device allowance is essential and cannot be disabled without deleting your AlphaPDF data. Optional uses are controlled separately.

Are you sure?