Excel Freeze Panes: Repeat Rows on Every Printed Page

No: Excel’s Freeze Panes setting keeps rows or columns visible while you scroll, but it does not make them appear on printed pages. To repeat headings on every printed page, use Page Layout > Print Titles and set the rows to repeat at the top.

Freeze Panes and Print Titles Do Different Jobs

Freeze Panes is a worksheet-view feature. It keeps selected rows or columns in place on screen as you move through a long sheet. For example, freezing row 1 can keep column names visible while you scroll down through hundreds of records. It does not change the worksheet’s print layout, page breaks, or the content Excel sends to a printer or PDF.

Print Titles is a page-setup feature. It tells Excel to repeat specified worksheet rows at the top of each printed page, or specified columns at the left of each page. The repeated cells are part of the printed worksheet, so they can show the same column headings beside different groups of records on successive pages.

The names are easy to confuse because both features can keep labels in view. A useful distinction is: Freeze Panes is for scrolling; Print Titles is for printing. You can use both in the same workbook, but setting one does not automatically set the other.

Why Repeat Headings on Paper?

A printed table often spans more than one page. Without repeated headings, page 2 might begin with values but no explanation of what each column represents. A reader then has to turn back to page 1 to interpret the data. Repeating the heading row makes each page easier to read on its own.

For instance, imagine a sales worksheet with columns for Date, Region, Product, Units, and Revenue. If the records fill four pages vertically, repeating the row with those labels places the same headings above the records on all four pages. If the sheet is also wide enough to print across multiple pages, you can repeat identifying columns such as Date and Region at the left of each printed page.

This is especially helpful for reports that will be distributed, reviewed away from a computer, or saved as a PDF. It does not duplicate the actual data rows or change the worksheet values; it only repeats the designated labels in the printout.

How to Repeat Rows on Every Printed Page

In Excel for Microsoft 365 on Windows, set the repeating rows in the worksheet’s Page Setup options:

Open the worksheet you plan to print. Print Titles are set for a particular worksheet, so select the correct sheet tab first.
Choose Page Layout > Print Titles. Excel opens the Page Setup dialog box on its Sheet tab.
Click the Rows to repeat at top field. Select the row or rows in the worksheet, or type a row reference such as $1:$1 to repeat the first row.
If needed, set Columns to repeat at left as well. For example, enter $A:$B to repeat the first two columns.
Select OK, then use File > Print to inspect the preview before printing or saving a PDF.

You can repeat more than one row. If your headings occupy rows 1 and 2, use $1:$2 in Rows to repeat at top. Excel repeats those rows together on each page. The references use dollar signs, as Excel’s Page Setup dialog displays absolute row or column references.

To choose rows with the dialog’s range-selection button, click the button beside the field, select the row numbers on the sheet, and then return to the dialog. Make sure the selection is a continuous range of complete rows. Print Titles is designed for rows at the top and columns at the left, not for repeating an arbitrary block in the middle of the page.

Repeat Columns on Pages Printed Side by Side

Rows to repeat at top is useful when a worksheet spans multiple pages vertically. Columns to repeat at left addresses a different layout problem: a wide worksheet may be divided into pages that print side by side. Repeating key columns helps readers identify which records they are looking at on each page.

For example, if columns A and B contain an employee name and department, while columns C through K contain monthly figures, set Columns to repeat at left to $A:$B. When the worksheet prints across several pages, those identifying columns can appear at the left edge of each page. The setting does not force the worksheet to print across multiple pages; page orientation, paper size, margins, scaling, and the amount of data determine the layout.

Repeating both rows and columns can be useful for a large cross-tabulation. Check the print preview carefully, though: repeated headings and identifying columns take up space on every page. If the content becomes too cramped, consider landscape orientation, a larger paper size, narrower margins, or a more compact report layout.

Check the Result in Print Preview

After setting Print Titles, open File > Print and review every page in the preview. Confirm that the labels appear on later pages, not just the first one, and check that the repeated area contains the rows or columns you intended. Preview is also a quick way to see whether a heading wraps, a column is cut off, or the repeated material leaves too little room for data.

Page breaks matter. Excel divides a worksheet into printed pages according to its dimensions and print settings. A sheet may fit vertically on one page but span several pages horizontally, or the reverse. In that case, top rows repeat on pages created by vertical breaks, while left columns repeat on pages created by horizontal breaks. Adjust orientation or scaling if the resulting pages are difficult to read.

Print Titles is separate from the print area. If only part of the worksheet is set to print, Excel repeats the configured titles within the pages produced for that printable area. To change the area, use Page Layout > Print Area > Set Print Area. Setting or clearing a print area does not itself turn repeated headings on or off.

Common Problems and Fixes

The heading appears only on the first page: Check that you used Page Layout > Print Titles rather than View > Freeze Panes. Then confirm the correct rows are listed in Rows to repeat at top.
The wrong worksheet prints the headings: Print Titles is configured sheet by sheet. Select the worksheet that is actually being printed and set its rows or columns in Page Setup.
The preview shows just one page: There may be no additional page on which to repeat the titles. Check the print range, page orientation, scaling, and page breaks to see whether the worksheet is actually spanning multiple pages.
There is not enough room for data: Repeating several tall rows or wide columns consumes space on every page. Reduce the repeated range to the essential labels, or change the page layout so the data has more room.
A heading is cut off or hard to read: Adjust column width, row height, text wrapping, margins, or paper orientation in the worksheet and page setup. A setting that looks fine on screen may not fit the selected paper size.

If the Print Titles fields are unavailable, make sure you are working in a worksheet rather than a chart sheet, and exit cell-editing mode before opening Page Setup. If you still cannot configure the feature in your version of Excel, open the workbook in the desktop app and set the print options there.

Freeze Panes, Headers, and Other Alternatives

Use View > Freeze Panes when the goal is to keep labels visible while navigating the worksheet. To freeze the first row, choose View > Freeze Panes > Freeze Top Row. To freeze both rows and columns, select the cell below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. These options affect the on-screen view, not printed pages.

Headers and footers are another print feature, but they are not the same as Print Titles. Use a header or footer for items such as a report name, date, page number, or other page-level text. They can appear on printed pages without repeating actual worksheet cells. Use Print Titles when readers need the table’s real column labels or identifying data repeated.

If a table is only slightly too large for one page, changing page orientation or scaling may be enough. In Page Layout, options such as Orientation and Scale to Fit can help organize the printout. Scaling an entire worksheet to fit one page can make text too small, however. For a multipage report, repeating headings is often more readable than shrinking every row and column until the whole sheet fits on one page.

Excel for Mac and Excel for the Web

In desktop Excel for Mac, use the worksheet’s Page Layout > Print Titles command to set repeating rows or columns; the dialog lets you specify the same top rows and left columns. The exact ribbon presentation can vary with the window size, but the setting is in the worksheet’s page setup, not in Freeze Panes.

Excel for the web has fewer print-setup controls than the desktop application. If you need to create or change Print Titles and cannot find the setting in the browser, open the workbook in the desktop Excel app, configure the worksheet there, and then review the print output. In all versions, check the print preview rather than assuming that frozen on-screen rows will repeat on paper.

Frequently Asked Questions

Do Excel Freeze Panes print on every page?
No. Freeze Panes keeps rows or columns visible while scrolling in the worksheet. Set Page Layout > Print Titles to repeat worksheet rows or columns in a printout.

How do I print the top row on every page in Excel?
Choose Page Layout > Print Titles, set Rows to repeat at top to $1:$1, select OK, and check File > Print. Use a range such as $1:$2 if the headings occupy two rows.

Can I repeat both rows and columns when printing?
Yes. In Page Setup, set Rows to repeat at top and Columns to repeat at left. For example, use $1:$2 for the first two rows and $A:$B for the first two columns, then confirm the layout in preview.

Will Print Titles change what I see when I scroll?
No. Print Titles controls printed pages. To keep a heading visible while scrolling, use Freeze Panes from the View tab. You can configure both features independently.

Do repeated headings appear in a PDF?
Yes, when you create the PDF from Excel’s print output with Print Titles configured, the repeated rows or columns are included on the applicable pages. Review the print preview first to verify the PDF layout.

Which Setting Should You Choose?

Choose the setting according to where you need the labels. For a long worksheet you are navigating on screen, use Freeze Panes. For a report that will be printed or exported to PDF across multiple pages, use Print Titles. For page numbers or a report name, use a header or footer. These features solve related but distinct problems, and choosing the right one avoids a common surprise: frozen headings that disappear from the printout after page 1.

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.