How to Repeat Excel Header Rows on Every Printed Page

October 31, 2026

Repeat Excel header rows on every printed page so readers can identify columns in a long report. These steps cover desktop Excel for Windows.

Choose the heading rows

Identify the rows that label your data. For example, row 1 might contain column names, while rows 1 and 2 might hold a grouped heading and its labels. Choose only the rows readers need on each page.

Set Print Titles

  1. Open the worksheet and select Page Layout > Print Titles.
  2. On the Sheet tab, locate Rows to repeat at top.
  3. Enter $1:$1 to repeat the first row. Use $1:$2 for the first two rows, or $1:$3 for the first three.
  4. Select OK.

Check the printed layout

Open File > Print and inspect the second and later pages in preview. Confirm the heading rows appear, column widths remain readable and no important content is clipped. If your report fits on one page, test with a longer worksheet before judging whether repetition works.

Print Titles controls printed headings. To keep rows visible while scrolling on screen, use Freeze Panes.

If Print Titles is greyed out

Finish editing the active cell, make sure you are not editing an area chart, and check that Windows has a printer configured.

To remove the repeated headings later, reopen Print Titles, clear Rows to repeat at top, and check preview again.

Sources

Topics:
Read next
November 21, 2026

How to Create and Configure a Shared Mailbox in Microsoft 365

Create a Microsoft 365 shared mailbox, grant the correct Full Access and Send As permissions, understand automapping and licensing, and verify that users can work from Outlook safely.
November 17, 2026

Microsoft 365 Business Basic vs Standard vs Premium vs E3 in Canada (2026): Which Plan Should You Buy?

A practical Canadian comparison of Microsoft 365 Business Basic, Standard, Premium, and E3, including verified November 2026 pricing, feature differences, user limits, hidden costs, and recommendations by business need.