Excel Table Headers on Each Printed Page: How to Repeat Them

To print the same column headings on every page in Excel for Microsoft 365 on Windows, open Page Layout > Print Titles, set Rows to repeat at top to the worksheet row or rows containing the headings, then print or export the sheet. An Excel table’s built-in header row does not, by itself, repeat on every printed page; Print Titles is the setting that does that.

What repeating table headers means

An Excel table has a header row that labels its columns and commonly provides filter buttons. That header is useful while you work in the spreadsheet, but it is not automatically treated as a repeating print heading. If a long table runs across several printed pages vertically, the headings may appear on the first page and be absent from later pages unless you configure print titles.

Print titles are worksheet rows or columns that Excel repeats in the same position on each printed page. For a typical report, you repeat a row containing labels such as Date, Product, and Quantity. Excel repeats the selected worksheet row range; it does not look for a table object and decide which row is its header. This distinction matters when the table begins below a report title or introductory notes.

The setting affects printed output, including a print preview and a PDF created through Excel’s print workflow. It does not add duplicate header rows to the data, alter the table, or change what appears while scrolling through the worksheet.

Set rows to repeat at the top

On Windows desktop Excel, use this sequence:

Open the worksheet you want to print. If the workbook has several sheets, configure each sheet that needs its own repeated headings.
Select Page Layout > Print Titles. Excel opens the Page Setup dialog on its Sheet tab.
Click in the Rows to repeat at top box. Use the small range-selection button at the right of the box if you need to temporarily select rows on the sheet.
Select the row numbers for the desired range. For example, select row 1 if your column headings are in row 1; the box should show $1:$1. Select rows 1 through 3 if those are the rows you want repeated; the range should show $1:$3.
Click the range-selection button again if needed, then choose OK. Open File > Print and check the preview across more than one page.

Print-title rows must form a continuous range beginning at the top of the worksheet. If a table’s header is in row 5, you generally cannot specify only row 5 as a repeating top row. Selecting rows 1 through 5 will repeat all five rows, including any title or blank rows above the table. For a cleaner printout, consider moving the report and table so the headings are near the top, or redesigning the print layout before setting titles.

Choose the right rows for a clean printout

Repeating every row above the table can use valuable page space. Imagine a worksheet with a report title in row 1, a date range in row 2, a blank row 3, and column labels in row 4. Setting rows 1 through 4 as print titles repeats the title, date, blank line, and labels on every page. That can be appropriate for a formal report, but it leaves less room for records on each page.

If only the column labels need to repeat, the most practical layout is usually to place them in row 1, with any optional report title elsewhere or in a header area. Then set row 1 as the print-title row. A worksheet header or footer can hold items such as a report name, date, or page number without requiring additional worksheet rows to repeat. Use Insert > Header & Footer to add those print elements; they are different from table column headings.

For a table that spans many columns and pages horizontally, consider whether the identifying fields should repeat on the left as well. In the same Page Setup dialog, use Columns to repeat at left to repeat a continuous set of worksheet columns on each printed page. For example, repeating a customer-name column can make a wide report easier to interpret when later pages show only amounts or dates. Repeating rows and columns is separate from choosing page orientation or scaling.

Check page breaks and print preview

Before printing, use File > Print to inspect the preview. If the worksheet covers multiple pages, move through the preview pages and confirm that the headings appear on each one. Also check that the repeated rows do not crowd out the data or create an awkward page with only a few records.

When a sheet does not fit the way you expect, inspect its page setup. Under Page Layout, options such as Orientation, Margins, and Size can change where page breaks fall. A landscape page may fit more columns, while narrower margins may create more usable space. The page-break view can help you see how Excel divides the worksheet, but changing a page break does not replace the Print Titles setting.

Be cautious with scaling. In the Page Layout tab, the scale-to-fit controls can shrink a worksheet to fit a chosen number of pages. Fitting a long report to one page wide can help keep related columns together, but forcing many rows onto one page can make the text too small to read. Repeated headings are most useful when the report remains legible at its chosen scale.

Common problems and practical fixes

The headings show only on page one: Check that you used Page Layout > Print Titles, not just the table’s header-row option. Return to the Sheet tab in Page Setup and verify the row range.
The wrong rows repeat: Look at the range in Rows to repeat at top. A selection made by clicking a cell may not represent the intended whole-row range, so select the row numbers and confirm the displayed reference.
The title and blank space repeat too: The range starts at row 1, so all rows from the top through the selected final row repeat. Move the table headings closer to the top or decide whether the title belongs in a print header instead.
The repeated row is cut off or too tall: Adjust row height, wrapping, or the print scale and recheck the preview. A long heading that wraps can consume a substantial part of every page.
A PDF does not show the headings: Check the workbook’s print preview before creating the PDF, and confirm that the correct sheet is being printed. Exporting or printing a different sheet will not use the settings configured on another sheet.
The option is unavailable or cannot be changed: Verify that you are working in the desktop Excel application and that the worksheet is not protected in a way that prevents page setup changes. Some print-layout controls are limited in Excel for the web.

Also check whether the print area excludes part of the table. A print area determines which cells are included, while print titles determine which rows or columns repeat. They solve different problems. Review Page Layout > Print Area if columns or records are missing from the preview.

Excel for Mac and Excel for the web

In Excel for Mac, the feature is also called Print Titles, though the location and appearance of Page Setup controls can vary slightly between releases. Look for Page Layout > Print Titles, then set the repeated rows in the Page Setup dialog and inspect the print preview. The Windows menu path and screenshots may not match the Mac interface exactly.

Excel for the web has more limited page-setup controls than desktop Excel. If you cannot find a way to define rows to repeat, open the workbook in the desktop app, configure Print Titles there, and check the result in its print preview. This is also a sensible approach when the workbook needs carefully managed page breaks, margins, or a print area.

Remember that print settings belong to a worksheet. A workbook with separate report tabs may need the repeated-row range set independently on each tab. Do not assume that setting the titles on one sheet automatically applies them to every sheet in the workbook.

Print titles compared with other header options

Several Excel features sound similar but serve different purposes:

Table headers label the columns of an Excel table and support table features such as filtering. They are part of the worksheet data structure.
Print titles repeat selected worksheet rows or columns on printed pages. Use them for column headings that should remain visible on each page.
Freeze Panes keeps rows or columns visible while you scroll on screen. It does not make those rows repeat in printed output.
Headers and footers add print-only information such as a report title, date, or page number. They do not reproduce a table’s column labels.

For instance, freezing the top row is helpful when reviewing a long list on screen, but it is not a substitute for Print Titles. You may use both features: freeze the headings for navigation, then set the same row as a print title for paper or PDF pages.

Frequently Asked Questions

Do Excel table headers automatically repeat on every printed page?
No. A table’s header row does not automatically repeat across printed pages. Set the worksheet’s repeating rows through Page Layout > Print Titles.

Can I repeat only a header row that is in row 5?
Not as a standalone top print-title range in the usual worksheet layout. Print-title rows start at row 1, so selecting through row 5 repeats rows 1 to 5. Move the headings nearer the top if repeating the preceding rows is undesirable.

Does Freeze Panes make the headings print on every page?
No. Freeze Panes affects what stays visible while you scroll in the worksheet. Print Titles controls repeated rows and columns in print output.

Will the repeated headings appear in a PDF?
They should appear when the PDF is produced from the worksheet’s print output with Print Titles configured. Check the print preview first to verify the pages, sheet, and print area.

Can I repeat a column as well as the header row?
Yes. In the Page Setup dialog, set Columns to repeat at left as well as Rows to repeat at top. Check the preview to ensure the added repeated area does not make the remaining content too narrow.

Why can I not set Print Titles in Excel for the web?
The web app has fewer page-setup options than desktop Excel, and the control may not be available in your current interface. Open the workbook in desktop Excel to set and verify the repeated rows.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.