You export a 20-page Excel spreadsheet to PDF. Page 1 looks perfect. The header row with the column labels, Date, Description, Amount, Category, appears at the top. You scroll to page 2, and the header row is gone. Page 2 shows rows of numbers with no indication of what each column represents. The reader has to flip back to page 1 to remember which column is which, then flip forward again. For a 20-page financial report, this back-and-forth makes the PDF nearly unusable.
Repeating header rows on every page of an Excel to PDF export is a setting called Print Titles. It tells Excel to print specific rows at the top of every page, and optionally specific columns at the left of every page. The setting takes 30 seconds to configure and transforms the PDF from a confusing pile of numbers into a readable report.
Setting Print Titles for Repeating Header Rows
In Excel, go to the Page Layout tab on the ribbon. Click Print Titles. The Page Setup dialog opens with the Sheet tab selected. The first option is "Rows to repeat at top." Click the collapse button at the right end of the field, then select the row or rows you want to repeat. For a single header row, click the row number 1. Excel inserts $1:$1 in the field, meaning row 1 will print at the top of every page. For multiple header rows, select all of them. Click OK.
The "Columns to repeat at left" field works the same way for column labels on the left side of wide spreadsheets. If the first column contains row labels that describe what each row represents, set that column to repeat at the left. On every page, the reader sees both the column headers at the top and the row labels at the left, giving them context for every cell. This is particularly useful for spreadsheets with many columns where the row labels in column A would otherwise appear only on the first printed page.
Verifying Print Titles Before Exporting to PDF
After setting Print Titles, verify the result before exporting. Go to File, Print to open the Print Preview. Scroll through the pages using the page navigation at the bottom. Confirm that the header row appears at the top of every page. Check that the column labels are correctly aligned with the data columns. Excel automatically adjusts the Print Titles rows to match the column widths on each page, so alignment issues are rare, but they can occur if the spreadsheet uses merged cells in the header row.
Merged cells in header rows cause the most common Print Titles failure. If the header row contains merged cells that span multiple columns, and the page breaks split those columns unevenly, the repeated header may show only part of the merged text. The fix is to unmerge the cells and center the header text across the selection using the Center Across Selection alignment option instead of Merge and Center. Center Across Selection looks identical but does not create the structural complications that merged cells introduce.
Adjusting Page Breaks for Clean Pagination
Print Titles ensure the header repeats on every page, but they do not control where the page breaks fall. A page might end with a row that is partially cut off, or a section heading might appear as the last row on a page with its content starting on the next page. Excel's automatic page breaks are based on the paper size and margins, not on the logical structure of the data.
Go to View, Page Break Preview. Excel displays the spreadsheet with page break lines and page number watermarks. Drag the dashed blue page break lines to adjust where pages break. Move a page break up a few rows to keep a section heading with its first data row. Move a page break down to avoid splitting a row across two pages. The manual adjustments take a few minutes and produce a PDF where every page break falls at a logical position. Combined with Print Titles, this produces a professional PDF Printing result where every page is self-contained and readable.
Handling Spreadsheets With Multiple Tables or Sections
Some spreadsheets contain multiple independent tables stacked vertically on the same worksheet, each with its own header row. Print Titles can only repeat one set of rows, which works for the first table but breaks for subsequent tables because the repeated header does not match their columns.
The solution is to split the worksheet into separate sheets, one per table, or to use the Set Print Area feature to export each table as a separate PDF. Select the range containing the first table and its header. Set the print area. Export to PDF. Repeat for each subsequent table. The output is multiple PDFs, each with the correct header. If a single combined PDF is required, merge the individual PDFs after export. WukongPDF's merge tool combines the separate table PDFs into one document. Each section retains its correct header because each was exported with its own Print Titles configuration.
Saving the Print Titles Setting for Future Exports
Print Titles are saved with the Excel file. Once you configure them, every PDF export from that file includes the repeating headers. This is a set-once benefit. If you use a template spreadsheet for recurring reports, configure Print Titles in the template. Every report generated from that template inherits the setting. The PDF Export from a well-configured Excel template produces consistently professional output with no per-export configuration required. The 30 seconds spent setting Print Titles in the template saves hours of confused reader questions over the lifetime of the reports generated from it.
A common oversight with repeating header rows: if the spreadsheet has a title row above the column headers, such as "Monthly Sales Report - June 2026" in a merged cell spanning the full width, that title row should NOT be included in the Print Titles range. Only the column label row should repeat. Repeating the title on every page clutters the output and wastes space. Set the Print Titles range to include only the column header row, typically row 2 if row 1 is the title. The title appears once at the top of the first page. The column labels appear at the top of every page. This separation of title and headers produces cleaner output.
For spreadsheets that will be viewed primarily on screen rather than printed, consider whether repeating headers are necessary at all. A PDF opened on a laptop screen shows one page at a time, and the reader can scroll back to check column labels quickly. A PDF printed on paper and read across a desk benefits enormously from repeating headers because flipping pages back and forth is cumbersome. Match the Print Titles decision to how the document will actually be consumed. WukongPDF's Excel-to-PDF conversion lets you toggle Print Titles on or off per export, so you can generate a screen-optimized version without repeating headers and a print-optimized version with them.