Excel Print Header on Each Page: Repeat Rows in Print

How-to basics · Updated November 19, 2026

To print a worksheet’s column headings on every page in Excel for Microsoft 365 on Windows, go to Page Layout > Print Titles, click the Rows to repeat at top box, select the heading row or rows, and click OK. If by “header” you mean text such as a report name or page number in the page margin, add that separately with Insert > Header & Footer.

Two different meanings of a print header

Excel uses two related but distinct features that people often call a print header. Print titles repeat worksheet cells, usually the row containing column labels, at the top of every printed page. For example, a sales table might have headings for Date, Region, and Revenue in row 1. Setting row 1 as a print title makes those labels appear again when the table continues on page 2 and later pages.

A page header is text or a field placed in the top margin of a printed page. It can show a report title, company name, date, or page number, but it is not made from the worksheet’s cells. Page headers and footers are useful for identifying a document; repeating rows are useful for making a multi-page table readable. You can use both features in the same worksheet.

Neither feature changes the data or the way it appears in the normal worksheet grid. They affect the printed output and print preview, including a PDF created through Excel’s print workflow.

Repeat column headings on every printed page

In Excel for Microsoft 365 on Windows, set the repeating rows for the worksheet you want to print:

  1. Click a cell in the worksheet. If you are editing a cell, press Enter or Esc first.
  2. Open the Page Layout tab and select Print Titles in the Page Setup group.
  3. In the Page Setup dialog box, click the Rows to repeat at top field.
  4. Select the row or rows in the worksheet. For a heading in row 1, the field should show $1:$1. For two heading rows, it should show $1:$2.
  5. Click OK, then use File > Print to check the pages in preview.

You can also type the row reference directly into the field. To select rows with the mouse, click the small range-selector button at the right of the field if the dialog obscures the worksheet, select the row numbers, and use the button again to return to the dialog. The reference must identify whole rows, not just a few cells within the heading.

To repeat labels in the left margin on pages that extend across multiple printed columns, use the Columns to repeat at left field in the same dialog. For example, selecting column A makes its labels reappear on each page printed to the right. Excel can repeat both rows and columns.

Choose the rows that should repeat

Usually, repeat only the row or rows containing meaningful column labels. A title row above the table may be worth repeating too if readers need it to identify the report. In that case, include the title and label rows together, such as rows 1 through 3. Avoid repeating large blocks of notes or blank rows: they consume printable space on every page and leave less room for the table.

For a table with a heading row in row 4, do not assume Excel will infer that row automatically. Set the range to $4:$4. If the labels occupy rows 4 and 5, set $4:$5. The selected rows are printed at the top of each page in addition to their appearance in the worksheet; they are not moved, copied into the data, or repeated as new worksheet rows.

Check that the repeated range contains the labels readers need to interpret the columns. A page may start partway through the data, so a label such as “Amount” without a nearby indication of currency or period may still be ambiguous. If the worksheet has grouped headings across several rows, repeating all the relevant heading rows can preserve the relationship between a group label and its subheadings.

Add a page header or footer

To put a report name or other margin content on each page, choose Insert > Header & Footer. Excel switches to Page Layout view, where you can click the header area at the top of the page or the footer area at the bottom. Each has left, center, and right sections. Type ordinary text into a section, or use the contextual Header & Footer tab to insert fields such as the page number, number of pages, current date, or workbook name.

For instance, a centered report name in the header and a page number in the footer can identify a printout even when pages are separated. Excel’s field buttons insert information that can update when the workbook is printed; they are different from typing a fixed number into a cell. To choose a built-in header or footer layout, open the Page Setup dialog and use its Header/Footer tab.

Headers and footers are generally applied to the printed pages of the selected worksheet and do not appear as normal cell content. They may be positioned close to the paper edge, so check the preview and adjust margins if content is clipped. A header/footer also does not cause column labels in the sheet to repeat; configure print titles separately when the table spans pages.

Check page layout before printing

After setting print titles, inspect the result with File > Print. The preview lets you move between pages and confirm that the repeated labels appear where expected. You can also switch to View > Page Break Preview to see how Excel divides the worksheet into pages. Return to Normal view when you are done.

Pagination depends on more than the repeating-row setting. Paper size, orientation, margins, scaling, print area, and manual page breaks all affect where the data is divided. A wide sheet may print across several pages horizontally, while a long sheet may continue down many pages. If the printout is too wide, changing orientation or choosing a suitable scaling option may help; be cautious about shrinking a large worksheet to fit on one page, since small text can become difficult to read.

Repeating heading rows uses some of the printable height on each page. If a worksheet has many heading rows, or the header margin is unusually large, fewer data rows may fit on each page. That is normal: Excel reserves room for the repeated content rather than covering the data with it.

Common problems and how to fix them

  • The headings appear only on the first page. Check the Rows to repeat at top field in Page Layout > Print Titles. Formatting the row in bold, freezing it on screen, or typing a header into a cell does not set print titles.
  • The Print Titles command is unavailable. Make sure you are working in a worksheet rather than a chart sheet and are not actively editing a cell. If several sheets are selected as a group, select one worksheet to configure it individually. Excel for the web has fewer page-setup controls; if the setting cannot be changed there, open the workbook in the desktop Excel app.
  • The wrong row repeats. Reopen Print Titles and inspect the reference. A heading on row 4 needs a reference such as $4:$4, not $1:$1. Use the range selector to choose the row rather than guessing its number.
  • The repeated labels do not show in the worksheet grid. That is expected. Print titles are visible in print preview and printed pages, not as extra rows while scrolling through the worksheet in Normal view.
  • Some columns are printed on separate pages without their identifying labels. Set Columns to repeat at left for the identifying column or columns. This is especially useful for wide reports, but it will not help if the printout is scaled so narrowly that the text is unreadable.
  • There is too little room for the data on each page. Reduce unnecessary repeated rows, review margins and header height, or adjust page orientation and scaling. Then review every page in preview so the result remains legible.

Freezing panes is a frequent source of confusion. View > Freeze Panes keeps rows or columns visible while you scroll on screen; it does not tell Excel to print those rows on every page. Likewise, setting a print area determines which cells are included in the printout, not which headings repeat. These settings can be useful together, but they solve different problems.

Excel for Mac and Excel for the web

In Excel for Mac, the same basic distinction applies: use the Page Layout print-title controls to repeat worksheet rows or columns, and use the header/footer controls for margin text. Ribbon placement and dialog details can vary slightly by release, so look for Print Titles on the Page Layout tab. Mac keyboard shortcuts are not needed for these steps; using the ribbon avoids relying on shortcuts that differ between Windows and Mac.

Excel for the web can open and print workbooks, but it does not provide every desktop page-setup control in the same way. If you need to create or change a repeating-title range and cannot find the setting in the browser, choose the option to open the workbook in the desktop app, set the print titles there, and save the workbook. When printing from a browser, inspect the available print preview because browser and printer settings can affect the final page layout.

Frequently Asked Questions

How do I print the top row on every page in Excel?
Go to Page Layout > Print Titles, click Rows to repeat at top, select row 1, and click OK. In the dialog, the range appears as $1:$1. Check File > Print to verify the result.

Can I repeat more than one heading row?
Yes. Select all consecutive rows that should appear at the top of each page. For example, if rows 1 and 2 contain a report title and column labels, use $1:$2. Repeating extra rows reduces the space available for data on every page.

Can I repeat the first column on every printed page?
Yes. In the Print Titles dialog, use Columns to repeat at left and select the relevant column or columns. This is helpful when a wide worksheet prints across multiple pages and each page needs row labels to make sense.

Why does Freeze Top Row not repeat the heading when I print?
Freeze Top Row controls what stays visible while you scroll through the worksheet; it is not a print setting. Use Page Layout > Print Titles to set Rows to repeat at top.

Can I have both repeated rows and a page number?
Yes. Set the repeated rows in Print Titles, then add a page number through Insert > Header & Footer or the Header/Footer tab in Page Setup. The repeated row prints as worksheet content, while the page number is a header or footer field.

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.