How to set the table header to be displayed on every page when converting Excel to PDF

Key points of this article

The table header must be specified as the top title row in Excel's page settings. It will be repeated on each page when exporting PDF. Simply bolding or freezing the pane will not work.
When there are multiple rows in the header, all rows from the first row to the last row in the header must be selected, otherwise only one of the rows will be repeated.
When the table is very wide and the columns are divided into multiple pages, you need to set an additional left-end title column. The two settings can be used at the same time.
After setting, be sure to check the print preview page by page. Files with multiple worksheets must be set one by one.

When exporting an Excel table with dozens of rows to PDF, a common problem is that only the first page has a table header, and the data on the following pages do not have column names. Readers have to flip back and forth to the first page for comparison. This is especially evident in tables such as contract lists, performance sheets, and inventory details.

This article talks about a specific thing: making every page of the PDF exported by Excel display a table header. The method is not to copy and paste, nor to adjust the font size, but to use Excel's print title function. After reading, you can determine how to choose and set your header, and check whether there are any missing parts before and after exporting.

How to make every page of Excel to PDF have a header? One sentence conclusion

In Excel's page setup, specify the row where the table header is located as the "top header row", and these rows will be repeated at the top of each page when exporting PDF. The table below can help you determine your situation.

your situation	Recommended practices	reason
Header is on row 1, only one row	Make row 1 the top header row	The setup is simple, only this line is repeated
Lines 1 to 3 are headers or titles	Select rows 1 to 3 and set them together	If only row 3 is set, the first two rows will only appear on the first page.
The header is on line 5, with the title and description	Use row 5 as the header. If you want to keep the title, select rows 1 to 5.	It’s up to you to decide whether the above content should be repeated or not. Both are fine, but it depends on whether the page has enough space.
The table is very wide and the columns are spread across multiple pages	In addition, set the left title column and fix the first column	The top header row only controls rows, not columns.
There are multiple worksheets in one file	Separate settings for each worksheet	Settings for printing titles are saved in respective worksheets

Before you start: Confirm these points first

Seeing the structure of the table clearly before starting can save most of the rework.

How many rows does the header occupy? Some table headers are two rows of merged cells, such as "Name, Age" under "Basic Information". At this time, both lines must be selected, otherwise only one of the lines will appear on the second page, and the reader will still not be able to read the column.
Whether the header is above the table. If there are company names, dates, and report descriptions on it, you need to decide whether these contents should appear on every page. If it appears on every page, it will occupy the layout. If it only appears on the first page, there is no need to set it, but make sure the header follows it immediately.
Whether there are blank rows or hidden rows. Hidden lines are not displayed when printing, but are still calculated by line number when setting the print title. If there are hidden rows in the header area, you may see unexpected blank or missing rows when previewing, and you need to unhide them first and then set them.
Whether the printing area has been set. If the print area has been manually set before, it will limit the export range. The header row you set must fall within the printing area, otherwise it will not appear in the PDF.
The export target is not PDF. If what you ultimately want is a PDF for others to see, you must select the PDF format in the export step after the settings are completed. Do not just save the Excel file as another format.

Steps to set printing titles in Excel

The following steps apply to common desktop versions of Excel. The specific button locations vary slightly depending on the version. Just search by function name.

Open the workbook that needs to be exported and click on the worksheet you want to export. When multiple tables are divided into different worksheets, each worksheet must be done separately.
Find the functional area related to page setup and open the option for setting the print title. It is usually placed together with the page margins and paper orientation.
In the page setup window that opens, find the "Top Title Row" column and click the select button on the right side of the input box.
Drag and select the row where the table header is located in the worksheet, for example, row 1 to row 3. Select the entire row, don't just frame the cells, the system will automatically write them into row number ranges.
After confirmation, return to the page setting window and click OK. At this time, the header row is still in its original position and will not be moved or changed.
Open the print preview, turn to the second page or later, and check whether the header appears repeatedly and is aligned with the data column.
After checking that everything is correct, use "Save As" or "Print" to select PDF format export. Before exporting, make sure that the export range selects the entire worksheet, not the currently selected small area.
Open the generated PDF and read it page by page, focusing on the last page of the table and the middle spread.

Check each item after completion

After getting the PDF, don't send it out directly. Take two minutes to check it according to the form below.

Check items	How to see	What should you do if there's a problem?
Check if the header is present on every page	From the first page to the last page, each page has a column name at the top	If not, go back to page settings and confirm that the line number range in the top title line is correct, then export again
Check whether the number of rows in the table header is complete	Check if all the headers of multiple rows appear, and if only one line remains	Expand the selection area to the last row of the table header, for example, select from row 1 to row 3
Check whether the data is aligned with the header	Flip through a few pages randomly to see if column names correspond one-to-one with the data	Check if merged cells span the header and data area; if necessary, cancel the merge before setting
Have multiple worksheets been processed?	Switch the worksheet preview one by one to view the header of each sheet	Set separate print titles for missed worksheets
Check if the columns in the wide table are complete	Check if the column on the right is not on the page and if the column name is duplicated	Additionally, set a title column on the left to keep key fields on the left side of each page

If you need to compare two PDFs before and after revisions, you can use the PDF comparison feature in the OmniDoc desktop client to check for unexpected changes in layout and text. When encountering scanned PDFs, the text cannot be directly selected; OCR can be performed first before comparison, but OCR results still need manual verification.

📊 Core Comparison

There are three main ways to duplicate the header, each suitable for different scenarios.

Method	Suitable situation	Main advantages	Caution is needed
Set the top header row	The meter header is at the top, and the table is very long vertically	Setting it up once causes duplicates across all pages, with fewer changes and easier future edits	The number of header rows must be selected; otherwise, only part of the table is duplicated
Set the title column on the left	The table is very wide horizontally and divided into multiple pages	Key fields such as names or numbers are kept on the left side of each page for easy alignment when turning pages horizontally	Focusing only on columns without solving the problem of vertical cross-page headers is usually used together with the top-end header row
Manually copy the header to each page	A temporary form with only a few pages	No need to go into page settings, intuitive operation	When pages increase, it tends to be missed, and when data is added or removed, the header tends to become misaligned. Long-term use is not recommended

❓ Frequently Asked Questions (FAQ)

1. I've set a print title, so why does the PDF still only have the header on the first page?

First, check whether the line number is set correctly on the worksheet, then confirm that the row number range falls within the print area. If the previous selected line was blank, the table header will not appear on subsequent pages.

2. The main headline and company name must appear on every page. What should I do?

Select the selection area from the header row all the way to the last row of the table header, for example, row 1 to row 5. Note that this increases the space occupied at the top of each page, reducing the number of usable rows in the table, so you need to judge based on the actual layout.

3. A table only has a few pages. Can I manually copy the header?

Yes, but it's recommended to use printed titles. Manual copying tends to misalign after data changes, but printing the title only needs to be set once, and subsequent line additions and removals remain normal.

4. The table has already been exported as PDF; can I just add the header to the table?

Directly adding headers to PDF is troublesome. The usual approach is to go back to the Excel source file, reset the print title, and export again. PDF editors are mainly suitable for editing paragraph text and page operations, and are not suitable for large-scale table rearrangements.

📝 Summary

Make sure every page converted from Excel to PDF displays the header. The key is to set the header row as the top header row and make sure the selected rows are complete and fall within the print area. After setup, use Print Preview to check page by page; multiple worksheets need to be processed separately. In this way, every page of the exported PDF allows readers to directly understand the meaning of the columns.

Open OmniDoc to convert and organize your documents