Excel Page Break Header: Repeat Headings on Every Page

To repeat column headings on every printed page in Excel, go to Page Layout > Print Titles, select the Sheet tab, and enter the heading row in Rows to repeat at top—for example, $1:$1 for row 1. If by “page break header” you mean text in the margin above each printed page, use Insert > Header & Footer instead: these are two different Excel features.

Two meanings of “page break header”

Excel uses page breaks to divide a worksheet into pages for printing. The word “header,” however, can refer to either a table’s column-label row or the page header area in the top margin. Knowing which one you mean makes it much easier to choose the right setting.

A repeated heading row might contain labels such as Date, Customer, and Total. Repeating it keeps those labels visible at the top of each printed page, even when the table continues onto another page. It does not add a margin header or change the worksheet itself.

A page header is separate text or content in the printable margin. It can identify a report, show a date, or display page numbers. It does not repeat the table’s column labels unless you add those labels as header content yourself. For a long list or report, you may use both features: repeat the table headings and add a report name in the page header.

Repeat a heading row on printed pages

In Excel for Microsoft 365 on Windows, set repeating headings in the desktop app with these steps:

Open the worksheet you want to print and choose Page Layout > Print Titles.
In the Page Setup dialog, open the Sheet tab.
Click the Rows to repeat at top box, then select the heading row or rows on the worksheet. You can also type a reference such as $1:$1 for row 1 or $1:$2 for rows 1 and 2.
Select OK, then check the result using File > Print.

You can also repeat columns at the left of printed pages. In the same Sheet tab, enter a reference in Columns to repeat at left. For example, $A:$A repeats column A, while $A:$B repeats columns A and B. This is useful when a wide worksheet spans several pages across and each page needs an identifying name or ID.

The setting applies to printing and print preview, not to scrolling through the worksheet. If you want headings to remain visible while you scroll on screen, use View > Freeze Panes; that is a different feature and does not make headings repeat on paper.

How page breaks and print titles work together

Excel creates automatic page breaks based on the printable page size, margins, scaling, and the worksheet’s contents. You can also insert manual breaks to choose where a new printed page starts. Print titles and breaks serve different jobs: a break determines where the page starts, while a print title determines which heading rows or columns are repeated on the pages.

For example, imagine a sales report with headings in row 1 and records in rows 2 through 85. If the printed report takes three pages vertically, setting row 1 as a print title repeats the column names at the top of all three pages. Moving a page break can change which records land on each page, but it does not remove the repeated heading.

In Page Break Preview, Excel shows page boundaries. Solid lines usually indicate manual breaks, while dotted lines indicate automatic breaks. The exact appearance can depend on the view and workbook state. A manual break is not a header, and inserting one does not automatically repeat the first row. Set both options when both are needed.

Insert, move, and remove page breaks

To add a manual break in Excel for Microsoft 365 on Windows, select a cell where the new page should begin and choose Page Layout > Breaks > Insert Page Break. Excel inserts a horizontal break above the selected row and a vertical break to the left of the selected column. Selecting a cell inside the worksheet can therefore create both a horizontal and a vertical break. To make only a horizontal break, select the row below the intended boundary; for only a vertical break, select the column to the right.

To inspect or adjust breaks, choose View > Page Break Preview. You can drag a break boundary to change the page division. Use care when moving one: a small change can push a column or several records onto an extra printed page. To remove a particular break, select the cell just below or to the right of it, then choose Page Layout > Breaks > Remove Page Break. To clear manual breaks from the sheet, choose Page Layout > Breaks > Reset All Page Breaks.

Resetting breaks restores Excel’s automatic page divisions; it does not erase the worksheet or its print-title settings. If a break command is unavailable, check that you are working in a worksheet rather than a chart sheet, and try switching to Normal view or Page Break Preview. Excel for Mac has comparable page setup and break controls, although their placement or labels can differ slightly by release.

Add text or page numbers in a page header

To put content in the top margin, select Insert > Header & Footer. Excel switches to Page Layout view, where you can click the left, center, or right header area and type text. The contextual Header & Footer tab provides elements such as page number, number of pages, current date, current time, file name, and sheet name. You can insert one of these elements at the cursor rather than typing a value that will become outdated.

For example, a report title in the center header and a page number in the right header can help identify pages that are printed or separated from the workbook. Excel uses header codes for dynamic elements, so the page number updates for each printed page. You can also open the Page Setup dialog and use its Header/Footer tab to choose a built-in header or footer format.

Headers and footers are designed for printed pages; they may not be visible in Normal view. If you need a line of text inside the worksheet grid, place it in a cell instead. Also note that a header’s position is controlled by page setup and margins, not by a row break in the worksheet.

Check print layout before printing

Always inspect the output in File > Print before sending a multi-page sheet to a printer or saving it as a PDF. Preview can reveal whether the repeated heading is present, whether the page breaks divide records sensibly, and whether a margin header is clipped or too close to the page edge.

If the report does not fit as expected, check these settings:

Orientation: Portrait is taller; Landscape provides more width for columns.
Paper size and margins: These affect where automatic breaks fall and how much room remains for the worksheet.
Scaling: Fit-to-page settings can shrink content or change how it is divided. For a large table, fitting all columns to one page wide may be more readable than shrinking the entire worksheet to one page.
Print area: A previously defined print area can exclude rows or columns you expected to print. Review it under Page Layout > Print Area.
Hidden rows or columns: Hidden data will not normally appear in the printout, so confirm that needed labels and records are visible.

For a long report, avoid choosing a scale so small that readers cannot read the text. It is often better to let the report span more pages and repeat its headings than to force every row onto one sheet of paper.

Common problems and their fixes

The heading appears only on the first page. Check that you set Rows to repeat at top in the Sheet tab of Page Setup, rather than simply selecting the row before printing. Selecting a row does not make it repeat.

The heading is repeated on screen but not in print. Freeze Panes keeps rows visible while scrolling; it is not a print setting. Set Print Titles separately and confirm the result in print preview.

The repeated row reference is unavailable or cannot be edited. Excel may restrict Print Titles when multiple worksheets are grouped. Check whether more than one sheet tab is selected; if so, ungroup the sheets and set the print titles on the intended worksheet. Also make sure the workbook is open in desktop Excel, where the full page setup controls are available.

The report starts new pages in unexpected places. Review manual breaks in Page Break Preview, then consider paper size, orientation, margins, scaling, and column widths. A break that was sensible before changing the page setup may no longer be useful afterward.

The page header is missing in Normal view. That is expected: page headers are print-layout elements, not worksheet cells. Switch to Page Layout view or inspect File > Print to see how they will appear on the page.

Excel desktop, Mac, and web differences

The steps above are written for Excel for Microsoft 365 on Windows. Excel for Mac also supports print titles, page breaks, and headers and footers in the desktop app, but ribbon arrangement and dialog details can vary with the version. Look for Page Layout and the Page Setup controls, or use the app’s command search if the button is not where expected.

Excel for the web has more limited page setup controls than the desktop application. If you need to define or change repeating title rows or columns, open the workbook in desktop Excel and set them there. The web app can be useful for viewing and basic printing, but do not assume every desktop print-layout option is available in the browser. After setting up the sheet on desktop, verify the final print output in the app and workflow you will use.

Frequently Asked Questions

How do I repeat the top row on every printed page in Excel?
Choose Page Layout > Print Titles, open the Sheet tab, and set Rows to repeat at top to $1:$1. Check File > Print to confirm the row appears on each page.

Does inserting a page break repeat the header row?
No. A page break controls where a new page begins. To repeat column headings, set the row separately in Print Titles. You can use manual breaks and repeating titles together.

What is the difference between a print title and a page header?
A print title repeats worksheet rows or columns, such as table labels. A page header places text or dynamic items in the top margin. They are configured separately and can both appear on the same printed page.

Can I repeat two heading rows instead of one?
Yes. In Rows to repeat at top, enter or select both rows, such as $1:$2. The chosen rows print at the top of each page, so keep them concise enough to leave room for the data.

Why can’t I see the header while editing the worksheet?
Page headers are not cell contents and may not appear in Normal view. Use Page Layout view or print preview to inspect them. If you mean column headings, set Print Titles and examine the printed-page preview.

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.