Excel Print Top Row on Every Page

How-to basics · Updated November 19, 2026

To print the top row on every page in Excel for Microsoft 365 on Windows, go to Page Layout > Print Titles. On the Sheet tab, set Rows to repeat at top to $1:$1, select OK, and check the result in Print Preview. Excel will repeat row 1 at the top of each printed page for that worksheet.

What Print Titles Does

Print Titles tells Excel to include specified worksheet rows or columns again when a large sheet is divided across multiple printed pages. It is designed for labels that need to stay visible, such as column headings for a long sales list. For example, a table with Date, Customer, Region, and Amount in row 1 can span several pages vertically while those headings appear on each page.

The setting affects the printed layout, not the cells themselves. It does not insert duplicate rows into the worksheet, change the data, or make the header repeat while you scroll onscreen. It also applies to the worksheet’s printout rather than automatically applying to every sheet in the workbook. If several sheets need repeating headings, set up each worksheet separately.

Print Titles is different from Freeze Panes. Freeze Panes keeps rows or columns visible as you move around the worksheet window; it does not, by itself, make them print on every page. Conversely, setting Print Titles does not keep the row fixed while you scroll. A worksheet can use both features, but each has its own purpose.

Set the Top Row to Repeat in Excel for Windows

  1. Open the worksheet you intend to print and confirm that its headings are in the top row. If the headings occupy more than one row, see the section below on repeating several rows.
  2. Select Page Layout > Print Titles on the ribbon. This opens the Page Setup dialog with the Sheet tab available.
  3. Click the Rows to repeat at top box. Enter $1:$1, or click the small range-selection button at the right of the box and select row 1 using its row number at the left of the worksheet.
  4. Press Enter if you selected the row on the sheet, then choose OK. The dollar signs and colons identify the full first row as the repeating range.
  5. Choose File > Print or press Ctrl+P to inspect the pages. Use the page navigation controls in the preview to check more than the first page.

If the data starts in row 2 because row 1 contains a report title, do not assume that the column labels are in the row Excel should repeat. Set the range to the actual heading row or rows. For example, if the field names are in row 3, use $3:$3. Rows above that heading will not repeat unless they are included in the selected range.

Repeat More Than One Heading Row

When a worksheet has a title row followed by column labels, repeat both if readers need both on every page. If the report title is in row 1 and the field headings are in row 2, set Rows to repeat at top to $1:$2. Excel repeats the two-row block together, in the same order, on each printed page. You can also select the row numbers for rows 1 and 2 while the range-selection control is active.

The repeating rows must be a continuous range at the top of the worksheet. Excel does not let you specify row 1 and row 3 while skipping row 2 as a single Print Titles range. If the headings you want are separated by an unwanted row, consider rearranging the report layout or deciding whether that intervening row should be part of the repeated block. Repeating extra blank or explanatory rows uses page space and can reduce how much data fits on each page.

To change the range, reopen Page Layout > Print Titles, replace the entry, and select OK. To remove it, clear the Rows to repeat at top box and confirm. Avoid typing a range that refers to another worksheet; print-title ranges are specified on the sheet being configured.

Check the Printed Pages and Page Layout

Print Preview is the practical way to confirm the setting. In File > Print, look at page 1 and then advance to page 2 or another later page. The headings should appear at the top of each page, above that page’s portion of the data. Check the last page too: a short final page can make a layout problem less obvious when you inspect only the first page.

For a clearer view of how the worksheet is divided, choose View > Page Break Preview. This view shows page boundaries and can help explain why a particular column or block of rows lands on a separate page. Return to Normal view when you are finished. Page breaks and Print Titles solve different problems: page breaks control where content splits, while Print Titles repeats the selected labels around those splits.

Look at the scaling options in the print settings if the pages are crowded. Fitting all columns on one page can prevent a wide table from breaking into several page-width sections, but it may shrink the text substantially. Fitting the entire sheet on one page can make a long report difficult to read. A more readable choice is often to fit the sheet to one page wide while allowing it to use multiple pages tall, then check the preview and adjust orientation, margins, or column widths as needed.

When the Worksheet Prints Across Multiple Pages

A worksheet can span pages vertically, horizontally, or both. Repeating row 1 puts that row at the top of each printed page, including pages created because the worksheet is too wide. If a table is printed across multiple pages from left to right, repeated top headings can therefore appear on each page in that horizontal sequence as well as on pages lower down.

However, repeating the top row does not repeat the first column. If each page needs a row label such as an employee name or product, use the Columns to repeat at left box in the same Sheet tab. For example, to repeat column A, enter $A:$A. This can be useful for wide schedules, but repeating too many columns can leave very little room for the remaining content on paper.

Consider the printed page size before adding repeat ranges. A tall multirow heading takes space away from the data on every page, and a repeated column reduces the printable width available for other columns. If a table becomes hard to read, try landscape orientation, a larger paper size where appropriate, or a more compact layout before shrinking all content to fit.

Common Problems and How to Fix Them

  • The row appears only on the first page. Check that the range is set under Rows to repeat at top, not merely that Freeze Panes is enabled. Reopen Print Titles and verify the range.
  • The wrong row repeats. Confirm where the actual column labels are. If they are in row 2, set $2:$2; if rows 1 and 2 both need to appear, set $1:$2.
  • The row does not appear in the preview. Make sure you are previewing the worksheet where you configured the setting and that the printout contains more than one page. Also check whether you are printing a different sheet or workbook.
  • There is no second page to check. The current print layout may fit the whole worksheet on one page. Review scaling and page breaks, but do not force extra pages just to see the repeat; the setting matters when the printout actually has multiple pages.
  • The headings repeat, but the table is still hard to read. Repeating labels cannot correct tiny scaling, clipped columns, or unsuitable page breaks. Review orientation, margins, column widths, and the fit-to-page settings in Print Preview.
  • The Print Titles control is unavailable or the range cannot be changed. Check whether you are in Excel for the web, editing a cell, or working with grouped worksheets. Open the file in the desktop app to configure print titles, exit cell editing, and, if multiple sheet tabs are selected as a group, select a single worksheet before changing its page setup.

Excel for Mac and Excel for the Web

In Excel for Mac, the desktop workflow is also through the Page Layout tab and Print Titles; use the Sheet tab in the Page Setup dialog to enter the repeating rows. Ribbon placement and dialog appearance can differ slightly by release, but the setting is the same. On a Mac, use Command+P to open printing rather than the Windows Ctrl+P shortcut.

Excel for the web can print worksheets, but if you need to create or change the repeating-row setting, open the workbook in the desktop version of Excel and use Print Titles there. This distinction matters if you are following a Windows desktop tutorial in a browser: the browser interface may not offer the same page-setup controls. Once configured in desktop Excel, review the final print preview in the environment you will use to print.

Frequently Asked Questions

Can I print the top two rows on every page in Excel?
Yes. Open Page Layout > Print Titles and set Rows to repeat at top to $1:$2. That repeats both rows as a block on each printed page.

Does Freeze Panes make the top row print on every page?
No. Freeze Panes affects the worksheet view while scrolling. Use Print Titles to repeat a row in printed pages; you may enable both if you want the heading visible onscreen and on paper.

Can I repeat a row other than row 1?
Yes. Enter the row that contains the heading, such as $3:$3 for row 3. To repeat a continuous block such as rows 2 through 4, enter $2:$4.

Can I repeat the top row and the first column?
Yes. In the Sheet tab of Page Setup, set Rows to repeat at top and Columns to repeat at left. For row 1 and column A, the ranges are $1:$1 and $A:$A.

Why does Excel repeat the row in preview but not in my exported or printed pages?
Check the selected printer or PDF output and inspect all pages in its preview. Make sure the correct worksheet and page setup are being used, then print or export from the workbook after confirming the setting. If the worksheet is being handled by a browser or another program, open it in desktop Excel to verify the print-title configuration.

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.