Excel Table: Print Headers on Every Page

Yes. In Excel for Microsoft 365 on Windows, open Page Layout > Print Titles and set the table’s worksheet row in Rows to repeat at top; for example, enter $1:$1 if the header is in row 1. Excel then prints that row at the top of each page, because an Excel table’s Header Row setting alone does not make its headings repeat on paper.

How Excel table headers work when printing

An Excel table is a structured range with features such as filter buttons, banded rows, and a named table range. Its Header Row option controls how the table appears and behaves in the worksheet. It does not, by itself, tell the printer to repeat those headings after a page break. For that, Excel uses a separate worksheet print setting called print titles.

Print titles repeat chosen worksheet rows at the top of every printed page. The setting applies to the worksheet’s printout, not specifically to the table object. If a table begins in row 4, you can repeat row 4; if the report has a title and column headings in rows 1 through 4, you can repeat all four. Excel repeats complete rows, so the other cells in those rows are repeated too.

This matters when the table continues onto a second or later page. Without print titles, the first page may show the field names but later pages show only data, making a printed list difficult to interpret. Setting print titles keeps the headings visible without inserting duplicate heading rows into the table itself.

Set the table header to repeat on every page

Click a cell on the worksheet containing the table.
Open Page Layout > Print Titles. Excel opens the Page Setup dialog on its Sheet tab.
Click the Rows to repeat at top box. Type the row reference, such as $1:$1 for row 1 or $4:$4 for row 4. You can also use the range selector beside the box and select the worksheet row or rows.
Choose OK, then open File > Print to inspect the preview. Check a later page as well as the first one to confirm the headings repeat.

Use whole-row references with dollar signs, such as $2:$2. If the headings occupy rows 3 and 4, enter $3:$4. The setting accepts a continuous range of rows, not a selection of separate, nonadjacent rows. You can return to Print Titles and change or clear the reference whenever the report layout changes.

Choose the right rows for a multirow heading

Repeat only what a reader needs to understand each page. If row 1 contains a report title and row 2 contains the table’s column names, entering $1:$2 repeats both. That can be helpful when the title identifies the report, but it uses more vertical space on every page. If the column names alone are sufficient, repeat just row 2.

For example, suppose a sales table has its field names in row 5, after four rows of notes and a report title. Use $5:$5 to repeat the field-name row. Do not add a duplicate header inside the table to solve the printing problem: duplicate headings can become data rows and interfere with filtering, sorting, formulas, or table references.

Remember that Excel repeats the selected worksheet rows on every printed page of that sheet, including pages where the table may not be the only content. If the worksheet includes introductory material above the table, review the print preview to make sure repeating the chosen rows throughout the printout is appropriate. Print titles are a sheet-level layout setting rather than a setting attached only to one table.

Repeat columns for wide tables

A table can span pages in two directions. Rows to repeat at top keeps headings visible when a printout continues down the worksheet. If the table is too wide and prints across multiple pages from left to right, use Columns to repeat at left in the same Page Setup dialog to keep identifying columns, such as a customer name or product code, visible on each horizontal page.

For instance, if column A contains an order number and columns B through H contain details that print across several pages, you might set $A:$A as the columns to repeat. That does not replace the heading-row setting; configure both if the printout needs repeated headings and repeated identifying columns. Check the preview because repeating columns and rows reduces the space available for the remaining content.

Check page breaks, scaling, and print preview

Print titles determine what repeats, but they do not decide where Excel places page breaks or how large the table prints. Use File > Print to see the result before printing. The preview helps reveal a heading that is missing, a column pushed onto an extra page, or a table scaled so small that its text is hard to read.

If the table breaks into too many pages, inspect the paper size, orientation, margins, and scaling options in the print settings. Landscape orientation can help with a wide table. Choosing to fit all columns on one page may keep the table’s width together, but it can shrink text considerably; fitting an entire large worksheet onto one page can make the printout unreadable. A sensible result may be one page wide and several pages tall rather than one page in both directions.

Page breaks can also affect how the data is divided, but they do not replace print titles. You can adjust page breaks when a row should stay with related data, then use Print Titles separately to repeat the headings. After changing either setting, inspect more than the first preview page: the key test is whether later pages show the repeated row and whether the content remains legible.

Common problems and their fixes

The heading appears only on page 1: Check that you entered the row under Rows to repeat at top, not merely enabled the table’s Header Row option. Reopen Page Layout > Print Titles and verify the reference.
The wrong row repeats: Confirm the worksheet row number containing the actual headings. A header in row 5 needs $5:$5, even if it is the first row of the table.
The table heading is hidden in the worksheet: Make sure the table still has a header row. On the ribbon’s Table Design tab, the Header Row option controls the table heading display; print titles cannot repeat a row that is not present as intended.
The repeated area takes up too much room: Reduce the repeated range to the essential heading row or rows. Each extra repeated row leaves less page space for data.
The printout is too small: Review scaling and page orientation instead of adding more repeated rows. Repeating headings does not require shrinking the whole worksheet to a single page.
The command is unavailable or does not behave as expected: Make sure you are working in the desktop Excel app and are not editing a cell. Check the print preview after changing the setting, and confirm you are adjusting the intended worksheet.

Excel for Mac and Excel for the web

In Excel for Mac, use the worksheet’s Page Layout tab and its Print Titles command to set repeating rows or columns, then check the print preview. The dialog and ribbon appearance can differ slightly from Windows, but the key setting is still the row reference under Rows to repeat at top.

Excel for the web has fewer page-layout controls than the desktop application, and it does not provide the same full workflow for setting print titles. If you need to configure or change repeating rows, open the workbook in the Excel desktop app, set the print titles there, and review the printed layout. If another person will print the workbook, confirm the result in the desktop version they plan to use.

Frequently Asked Questions

Does an Excel table automatically repeat its header when printed?
No. The table’s Header Row feature and worksheet print titles are different settings. Set the header’s worksheet row under Page Layout > Print Titles > Rows to repeat at top to have it appear on subsequent printed pages.

Can I repeat a table header that is not in row 1?
Yes. Enter the actual worksheet row reference. For example, if the table headings are in row 6, enter $6:$6. The row does not have to be the first row of the worksheet or the first row of the table.

Can I repeat more than one heading row?
Yes. Enter a continuous range such as $1:$3 to repeat rows 1 through 3 at the top of each page. Keep the range as short as possible so it does not consume excessive space on the printout.

Can I repeat headings on pages that continue across columns?
Yes. Use Rows to repeat at top for the heading rows and Columns to repeat at left for identifying columns. These are separate settings in Page Setup, and both can be used when a worksheet prints across and down multiple pages.

Will repeating print titles change the table or its data?
No. Print titles change the worksheet’s printed layout; they do not add rows to the table, alter values, or change sorting and filtering. The repeated rows appear in the printout, not as duplicated records in the worksheet.

Why do the headings still not appear in my print preview?
Verify the row reference and confirm it points to the worksheet row containing the headings. Then check the preview for a later page, since page 1 already contains the original heading row. If the setting is missing in the web app, use desktop Excel to configure the print titles.

When to use another approach

Print Titles is the right choice for a normal worksheet printout when the headings should repeat on each page. If you need a highly designed report with different titles, footnotes, or layouts for different sections, a separate report sheet or a document layout may offer more control. For routine table printing, however, repeating the worksheet’s heading row is usually simpler and safer than copying the headings into the data.

Before printing a large workbook, check the print preview for each relevant worksheet. Print-title settings belong to individual sheets, so setting them on one tab does not automatically configure every other tab. Confirm the repeated row, the page count, and the readability of the printed data; then save the workbook if you want to preserve the page setup for later use.

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.