Excel Row at Top of Each Page: Repeat Header Rows in Print

To print the same row at the top of every page in Excel, go to Page Layout > Print Titles, open the Sheet tab, and set Rows to repeat at top to the row or rows you want, such as $1:$1. Select OK, then check Print Preview; the setting affects printed pages and PDFs, not the worksheet view.

What repeating a row on each page does

A spreadsheet may show its column headings only once, above the first set of records. When a long table spans several printed pages, later pages can then contain numbers or names without any indication of what each column means. Excel’s print titles feature solves this by printing specified worksheet rows again at the top of each page.

For example, imagine a sales list with headings in row 1 and hundreds of transactions below. If the first printed page contains rows 1 through 45 and the next page starts with row 46, repeating row 1 makes the headings appear above row 46 as well. The data itself is not copied or moved: Excel repeats the selected row in the printout.

The feature is useful for a long worksheet printed across multiple pages vertically. It also works when a worksheet spans multiple pages horizontally, although repeating a row is still the relevant choice for column labels. For a wide report where identifying labels are in the first column, Excel also offers a separate option to repeat columns at the left of each page.

Set up repeating rows in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, configure print titles from the Page Layout ribbon. The example below repeats the first row; change the range if your headings use more rows.

Open the worksheet you intend to print. Print-title settings apply to a worksheet, so confirm that the correct sheet is active.
Select Page Layout > Print Titles. Excel opens the Page Setup dialog.
On the Sheet tab, find Rows to repeat at top.
Click in the box and enter $1:$1 to repeat row 1. To repeat rows 1 through 3, enter $1:$3.
Select OK, then open File > Print to inspect the pages before printing or saving a PDF.

You can also use the range-selection button beside the field, select the row numbers on the worksheet, and then return to the dialog. Excel fills in the row reference. If the dialog is collapsed while you select, click its button again to expand it. The dollar signs are normal absolute-reference notation in a range; they do not change the worksheet data.

Choose the right rows to repeat

Choose rows that provide context for the records on every printed page. For a straightforward list, that is usually the one row containing field names, such as Date, Customer, Region, and Amount. If the report has a title and a two-row header, repeat all three rows so the title and both header levels stay together.

Print titles are specified as a continuous row range. For instance, $1:$3 repeats the first three worksheet rows. This can be helpful when the first row is a report name, the second is a subtitle or date, and the third contains the actual column headings. It also means that selecting several separated rows is not the way to create a print-title range. If the useful labels are separated by blank or unrelated rows, consider rearranging the worksheet or using a cleaner report sheet.

Keep the repeated area concise. Reprinting several tall rows reduces the space available for new records on each page and can make a report harder to scan. If the chosen rows are taller than expected because of wrapped text or oversized formatting, adjust their height or simplify the headings, then preview again. The goal is enough context to identify the data, without allowing the repeated heading block to dominate the page.

How Excel applies print titles

Excel calculates page breaks using the print area, paper size, margins, orientation, scaling, and the worksheet’s row and column dimensions. Print titles are added to the output at the top of each applicable page. They do not change the order of rows, insert extra worksheet records, or alter cell values. A repeated heading may therefore be visible on a page even though the corresponding worksheet row is not part of that page’s new sequence of records.

The setting belongs to the worksheet rather than to an individual print job. If you print that sheet again, the title rows remain configured until you change them. A workbook can have different print-title settings on different sheets, so setting row 1 for one tab does not automatically configure every other tab. Review each sheet that will be printed, especially in a workbook with separate monthly or departmental reports.

The chosen rows are repeated on pages generated from that worksheet. A print area can limit which cells are included in the output, but it is a different setting: it determines the area to print, while print titles determine which rows or columns are repeated as labels. A print area is not required just to repeat a heading row.

Preview and adjust page layout

Use File > Print to review the print preview before sending a report to a printer. Move through the preview pages and verify that the repeated row is present on later pages, that its text is readable, and that the data columns still fit. For a PDF, use the same preview and print workflow, then choose an available PDF destination or the option to save as PDF.

If a large heading block leaves too little room for records, try a landscape orientation, narrower margins, or a smaller print scale. These choices affect the overall page layout, so check that the resulting text remains legible. For a wide worksheet, landscape orientation may bring more columns onto a page, while scaling to fit can shrink the entire report. Previewing matters because a setting that helps one dimension can make another harder to read.

Page breaks can also affect how the data is divided. In Excel, the View > Page Break Preview view shows page boundaries, which can help explain why a particular record starts on a new page. Adjusting a page break changes where content is split; it does not replace the print-title setting. Check both when a report’s page divisions and repeated labels need attention.

Common problems and fixes

The heading appears only on the first page. Confirm that you set Rows to repeat at top in Page Setup, rather than simply selecting the row or making it bold. Check the setting on the sheet you are printing.
The wrong row repeats. Reopen Page Layout > Print Titles and inspect the range on the Sheet tab. Use a full-row reference such as $1:$1 or $1:$3, as appropriate.
The row does not appear in the normal worksheet view. That is expected. Print titles are for page output; they do not freeze or pin a row while you scroll.
The repeated headings take up too much room. Reduce the number or height of the repeated rows, and look for wrapped text or excessive spacing. Then inspect the preview to make sure the headings remain understandable.
The setting seems unavailable in Excel for the web. Configure print titles in the desktop Excel application. Excel for the web does not provide the same Print Titles setup dialog as desktop Excel.
A different sheet prints without the headings. Set and verify print titles on that sheet too. Each worksheet can have its own page setup.

Another common source of confusion is the difference between a page break and a repeated title. A page break decides where one page ends and the next begins. Repeating rows tells Excel what labels to place at the top of those pages. A page break alone will not make the headings repeat.

Print titles versus Freeze Panes

Freeze Panes and Print Titles both help keep headings available, but they solve different problems. Freeze Panes keeps selected rows or columns visible in the on-screen worksheet while you scroll. It is useful when reviewing a large table on a monitor, but it does not make those rows print at the top of every page.

Print Titles controls printed output, including a print-to-PDF job. It does not keep rows visible as you move down the worksheet. If you want labels to remain visible both while working and in printed reports, use both features: configure Freeze Panes for the worksheet view and configure Print Titles separately for page output.

For example, freeze the top row when you need to inspect records far down a list, then set row 1 as the print title when you produce a multi-page report. Neither setting changes or duplicates the source records. They simply improve navigation or make the printed pages easier to interpret.

Excel for Mac and Excel for the web

In current desktop versions of Excel for Mac, use the Page Layout tab and the Print Titles command to open the page setup controls. The dialog and ribbon arrangement can look slightly different from Windows, but the relevant setting is still the field for rows to repeat at the top. Enter or select the row range, then check the print preview.

Excel for the web is more limited for this particular task. If you need to establish or change print-title rows, open the workbook in the desktop app and configure the setting there. A workbook that already has print settings may still be opened or printed through web workflows, but use desktop Excel when you need the full Print Titles setup control. If the workbook is shared, save the changes so the configured print layout is available to other users with access.

Frequently Asked Questions

Can I repeat two or more rows at the top of every page?

Yes. In Page Layout > Print Titles, set Rows to repeat at top to a continuous range such as $1:$3. Excel repeats all three rows on each printed page generated from that worksheet.

Can I repeat a row other than row 1?

Print titles are intended for rows at the top of the worksheet. If your useful heading begins lower down, consider including the preceding top rows in the repeated range or moving the heading structure to the top of a report sheet. Preview the result to confirm the printed pages are clear.

Will the repeated row appear in a PDF?

Yes. When you create a PDF from Excel’s print output, the configured print titles are included on the applicable pages, just as they are in a paper printout. Check File > Print first to confirm the layout.

Does Freeze Panes make a row print on every page?

No. Freeze Panes affects the worksheet while you scroll; it does not control printed pages. Use Page Layout > Print Titles and set Rows to repeat at top for repeating print headings.

Do I need to set this separately for every worksheet?

Yes, check each worksheet you plan to print. Print-title settings are maintained per sheet, so setting a repeating row on one tab does not necessarily set it on the others.

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.