Excel Table Repeat Header Row: What You Can Do

How-to basics · Updated November 18, 2026

Excel tables do not have a setting that repeats their header row on every printed page. To print the same worksheet row at the top of each page, use Page Layout > Print Titles and set that row in Rows to repeat at top; this works for a table header as well as any other worksheet row.

What “repeat header row” can mean

The phrase can refer to two different things: keeping column names visible while you work in a worksheet, or printing those names again when a long sheet spans multiple pages. An Excel table helps with the first situation, but it does not automatically solve the second.

A table has one header row containing its column names, such as Date, Customer, and Amount. When you scroll through a table in desktop Excel, its column names can appear in the worksheet’s column headings in place of labels such as A, B, and C while you are working in the table. That is an on-screen convenience. It does not add a header row to each printed page.

For paper or a PDF, Excel uses a separate worksheet setting called print titles. It tells Excel which worksheet rows or columns to repeat on pages. You can use it even if your data is not formatted as a table.

Repeat a table header on printed pages

In Excel for Microsoft 365 on Windows, set the table’s header row as a print title:

  1. Make sure the worksheet has a header row with the labels you want readers to see. Note its worksheet row number; a table header could be on row 1, row 4, or another row.
  2. Select the Page Layout tab, then choose Print Titles. Excel opens the Page Setup dialog box.
  3. On the Sheet tab, click the Rows to repeat at top field.
  4. Select the row number at the left edge of the worksheet for the header row. Excel enters a reference such as $4:$4 if the header is on row 4.
  5. Click OK, then use File > Print to inspect the preview. Check a later page as well as the first one.

You can type the row reference directly into the field if selecting it is inconvenient. Use a full-row reference, such as $4:$4, rather than a range of table cells. The setting repeats worksheet rows, not just the cells within a table. If your headings occupy two rows, select both, producing a reference such as $4:$5.

On Excel for Mac, the equivalent setting is also available through Page Layout > Print Titles; use the Rows to repeat at top field in the page setup dialog. The dialog’s appearance can vary by Excel release. Excel for the web does not provide the same desktop print-title setup, so open the workbook in the desktop app to configure it. Afterward, check the print preview before printing or saving to PDF.

Choose the right rows to repeat

Print titles are worksheet-level settings, so choose rows that make sense as a repeated heading. If the table starts on row 4 and its field names are on that row, repeating only row 4 keeps the printed pages compact. If rows 1 through 3 contain a report title and date that readers also need on every page, you can repeat all four rows instead. Remember that every selected row will recur at the top of the later pages.

For example, suppose a sales table has headers in row 6 and hundreds of records below. Setting $6:$6 repeats the sales headings, but it does not repeat a report title in row 1. Setting $1:$6 repeats the report title, blank spacer rows, and headers. The second choice may be useful for a formal report, but it takes up more page space and leaves less room for records on each page.

The same dialog has a Columns to repeat at left field. That is useful for a wide worksheet that prints across multiple pages horizontally. For example, repeat a salesperson or product-name column so each horizontal page can be read without guessing which values belong to each row. Repeated rows and repeated columns are independent settings.

Keep headings visible while scrolling

If you mean that you want to see headings as you move down the worksheet, first consider using an Excel table. Select a cell in the data and choose Insert > Table, or press Ctrl+T on Windows. Confirm that My table has headers is selected if the first row contains field names. On Mac, the shortcut equivalent is Control+T in many Excel configurations; the Insert tab’s Table command is an alternative if the shortcut differs on your keyboard.

When you work within a table, Excel can display its field names in the worksheet’s column heading area as you scroll down, rather than leaving you to remember what each column contains. This display depends on being within the table and is not a separate header row added to the data. It is also unrelated to printing.

For a worksheet range that is not a table, or when you want the actual top rows to stay on screen, use View > Freeze Panes. Select the cell below the rows and to the right of the columns you want to keep visible, then choose Freeze Panes. To keep just the top worksheet row visible, choose View > Freeze Panes > Freeze Top Row. Freeze Panes affects scrolling on screen; it does not repeat anything in printouts. You can use it alongside Print Titles because the two settings serve different purposes.

Table headers and print titles are different settings

The Header Row option on the Table Design tab controls whether the Excel table has its own header row. It supports table features such as named columns in formulas, filter controls, and table formatting. It does not tell the printer to repeat that row. Likewise, turning on Print Titles does not convert a normal cell range into a table or add filter buttons.

This distinction matters when troubleshooting. If the column labels disappear from a printed second page, changing the table style or switching on the table’s Header Row option is unlikely to fix it. Set Rows to repeat at top in Page Setup. If labels are missing from the worksheet itself, check that the table has a header row or freeze the relevant worksheet rows instead.

Check page layout before printing

Repeating a row does not control where Excel places page breaks, how large the table prints, or which cells are included. Review those choices separately so the repeated headings remain useful:

  • Open File > Print and inspect multiple pages in the preview. A correct setting should show the chosen heading row above the records on each applicable page.
  • Use Page Layout > Print Area > Set Print Area if you need to limit the output to a specific section. The print area determines what is printed; print titles determine what repeats.
  • Check orientation, margins, and scaling on the Page Layout tab. Fitting a very wide sheet to one page can make text too small to read, even when the headings repeat correctly.
  • Look at page breaks if a row is split awkwardly or too few records fit beneath the repeated heading. Adjusting print scaling or the layout may help, but do not assume that repeating the row will repair every pagination problem.

Print titles apply to the worksheet you configure, not automatically to every sheet in the workbook. If the same report spans several worksheets, inspect and set up each sheet as needed. A change to the table’s data or style does not necessarily mean you need to redo the print-title setting, but always review the resulting preview after changing the layout.

Common problems and practical fixes

If Print Titles is unavailable or you cannot edit its fields, first exit cell-editing mode by pressing Enter or Esc, then open the command again. Also check whether the worksheet is protected or whether the workbook is in a state that prevents page setup changes. In a shared or restricted workbook, you may need permission to make the change.

If the wrong row repeats, return to Page Layout > Print Titles and inspect the exact row reference. A frequent mistake is choosing the first worksheet row because it looks like a heading, even though the table’s actual field names are lower down. Another is selecting several rows unintentionally, which repeats blank space or report notes along with the labels.

If the header appears on page one but not later pages, do not rely on the preview’s first page alone. Reopen the Print Titles dialog and confirm that the reference is in Rows to repeat at top, not merely in the print area or a manually selected print range. Then inspect a subsequent page in File > Print. If Excel shows only one page, temporarily change the scaling or print area enough to create a second page while checking the setup.

If a wide table prints across multiple pages, row headings can repeat vertically while key identifying columns repeat horizontally. Set Rows to repeat at top and Columns to repeat at left separately, and check a page that is both beyond the first vertical page and beyond the first horizontal page. That helps confirm the settings work in the direction you need.

Frequently Asked Questions

Can an Excel table repeat its header row on every printed page automatically?
No. A table’s header-row setting does not control printed pages. Set the worksheet’s header row as a print title through Page Layout > Print Titles > Rows to repeat at top.

How do I repeat a header row that is not at the top of the worksheet?
Use the row number where the header actually appears. For a header in row 7, enter or select $7:$7 in Rows to repeat at top. You do not have to repeat rows 1 through 7 unless you also want those earlier rows printed on every page.

Does Freeze Panes make a header print on every page?
No. Freeze Panes keeps rows or columns visible while you scroll in the worksheet. Print Titles controls repeated rows or columns on printed pages. Set both if you need both behaviors.

Can I repeat more than one header row?
Yes. Select the full rows you want repeated, such as rows 5 and 6, and Excel will repeat both. This can suit a report with a title line followed by column labels, but it uses more vertical space on each page.

Can Excel for the web set repeating print headers?
Use desktop Excel to set worksheet print titles. If you are working in a browser, open the workbook in the desktop app, configure the rows there, and then review the print output.

Will the repeated header row also appear in a PDF?
Yes, when you create the PDF from the worksheet’s print output after setting print titles. Check File > Print first so you can verify the repeated heading and page breaks before saving or exporting.

Related

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.