Print Freeze Panes in Excel: Repeat Rows on Every Page

To print frozen rows or columns on every page in Excel, use Page Layout > Print Titles and set the rows or columns to repeat. Freeze Panes keeps headings visible while you scroll on screen; it does not control printed pages, so Print Titles is the setting you need.

Why Freeze Panes Does Not Repeat in Print

Freeze Panes and Print Titles solve related but different problems. Freeze Panes locks selected rows or columns in the worksheet window so you can keep labels in view while moving through a large sheet. The setting affects how the sheet appears on screen, not how Excel divides it into paper pages.

For example, imagine a sales table with field names in row 1 and hundreds of records below. Freezing the top row lets you see labels such as Date, Region, and Revenue as you scroll down. When you print the sheet, however, Excel may split those records over several pages. Without a print-title setting, the field names might appear only on the first page.

Print Titles tells Excel to place chosen heading rows at the top of each printed page, or chosen left-hand columns at the left of each page. The feature is useful for reports, inventories, schedules, and any worksheet where readers need to identify the meaning of values on later pages. You can keep Freeze Panes enabled for on-screen work and configure Print Titles separately for printing.

Set Rows to Repeat at the Top of Each Page

In Excel for Microsoft 365 on Windows, configure the setting on the worksheet you plan to print. The repeated rows should normally be a heading row or a small group of heading rows at the top of the table.

Click the worksheet tab whose pages need repeated headings. If the workbook has several sheets, set the print titles for each sheet that needs them.
Open Page Layout > Print Titles. Excel opens the Page Setup dialog box on its Sheet tab.
Click the Rows to repeat at top box. You can type a row reference, such as $1:$1 for row 1 or $1:$2 for rows 1 and 2.
Alternatively, use the range-selector button beside the box, select the row numbers on the worksheet, and confirm the selection in the dialog.
Choose OK, then open File > Print to inspect the preview before printing.

The dollar signs are normal in the reference Excel creates; they identify the selected worksheet rows. If your headings occupy rows 3 and 4, for instance, the repeat reference can be $3:$4. Select the full rows containing the headings, not merely the cells with text, so the labels repeat in alignment with the table.

Repeat Columns on the Left

Print Titles can repeat columns as well as rows. This helps when a wide worksheet spans multiple pages from left to right and each printed page needs a row identifier, such as a product name, employee, or account number.

Return to Page Layout > Print Titles, then enter the desired columns in Columns to repeat at left. For example, $A:$A repeats column A, while $A:$B repeats columns A and B. You can select the column letters directly with the range-selector control. You may set both repeated rows and repeated columns in the same Page Setup dialog.

Choose only the identifying columns readers genuinely need. Repeating too many columns can leave little room for the rest of a wide table on each sheet of paper, especially in portrait orientation. If the preview becomes cramped, consider repeating just the key identifier and changing the page orientation or scaling rather than printing an unreadably small table.

Check the Print Preview and Page Breaks

After setting Print Titles, use File > Print to review the pages. The preview is the quickest way to confirm that a heading appears on each page and that the repeat range is the one you intended. Use the page-navigation controls in the preview to inspect later pages, not just page 1.

Check that the repeated headings do not cover data, that the table is not unexpectedly split, and that the printed text remains large enough to read. Excel may distribute a sheet across pages vertically, horizontally, or both, depending on the content, paper size, orientation, margins, and scaling settings. Repeated rows appear at the top of each relevant printed page; repeated columns appear at the left when the sheet spans pages across its width.

If the printed page count is surprising, review the page breaks as well as the title settings. On the ribbon, View > Page Break Preview shows how the worksheet is divided into pages. You can inspect the breaks there and return to Normal view when finished. A repeat-heading setting does not force a particular break location; it only repeats the selected rows or columns where Excel creates pages.

Choose Print Titles Alongside Other Page Settings

Print Titles works best when the print layout is planned as a whole. A heading that repeats correctly can still be difficult to use if the table is cut off, scaled too small, or printed with unnecessary blank columns. Before committing to paper, check these related settings:

Orientation: Use landscape for a table with many columns, or portrait for a narrow list. Find this under Page Layout > Orientation.
Paper size: Confirm the selected size under Page Layout > Size matches the paper loaded in the printer.
Margins: Adjust Page Layout > Margins if the table needs more printable space or a little more room around the edges.
Print area: If Excel includes unrelated cells, select the desired range and choose Page Layout > Print Area > Set Print Area. The print area and Print Titles are separate settings.
Scaling: In File > Print, review the scaling options. Fitting all columns on one page wide can help with a wide table, but fitting an entire long worksheet onto one page may make the text too small.

For a report that is three pages tall and two pages wide, repeated rows can appear on each vertical page, while repeated columns help identify the data on the second page across. Preview both page directions. If you need the content to remain legible, it is often better to allow more pages than to shrink a large worksheet dramatically.

Common Problems and How to Fix Them

The headings appear only on the first page. Check that you used Print Titles rather than relying on Freeze Panes. Then reopen the Print Titles dialog and confirm the row reference is present. Also make sure you are printing the worksheet for which you set the option.

The wrong rows repeat. A reference such as $1:$2 repeats rows 1 and 2, not rows 2 and 3. Look at the row numbers beside the worksheet and verify the reference in the Page Setup dialog. Clear the box and select the intended rows again if necessary.

Print Titles is unavailable or cannot be changed. Excel may be in cell-edit mode, or multiple worksheet tabs may be grouped. Press Enter or Esc to finish editing, and check whether several sheet tabs are selected. If they are grouped, right-click a selected tab and choose Ungroup Sheets, then set the title range on the individual sheet.

The repeated heading is clipped or takes too much space. A tall heading row reduces the room available for records on each printed page. Adjust row height, wrapping, margins, or orientation, and inspect the preview again. If scaling is set to fit an overly large range, try a less restrictive option to preserve readable type.

The printout includes blank pages. Extra formatting or stray content far from the table can expand Excel’s print range. Set a print area around the data, check Page Break Preview, and clear unwanted content or formatting outside the intended report if appropriate. Print Titles do not remove extra pages; they only repeat the specified labels.

Excel for Mac and Excel for the Web

In Excel for Mac, the feature is also called Print Titles. The ribbon layout can differ slightly by release, but look on the Page Layout tab for Print Titles, then use the Page Setup controls for rows to repeat at the top or columns to repeat at the left. Use Command+P to open printing on Mac; on Windows, the shortcut is Ctrl+P. The menu path for setting the repeat ranges is the important part, not the keyboard shortcut.

Excel for the web can display and print worksheets, but its available page setup controls are not identical to the desktop app, and Print Titles may not be available for editing there. If you cannot find the repeat-row or repeat-column controls in the browser, open the workbook in the Excel desktop app, set Print Titles, save the workbook, and then print. The saved print setup belongs to the worksheet, so it can be used when the workbook is opened in a supported desktop version.

Frequently Asked Questions

Can I print Freeze Panes in Excel?
Not as a separate frozen-pane effect. Freeze Panes affects the on-screen view. To repeat headings on printed pages, set the relevant rows or columns through Page Layout > Print Titles.

How do I make the top row print on every page?
Choose Page Layout > Print Titles, enter $1:$1 in Rows to repeat at top, and click OK. Check later pages in File > Print to confirm the row repeats.

Can I repeat more than one heading row?
Yes. Select or enter a contiguous range, such as $1:$3, to repeat rows 1 through 3. Excel repeats the whole selected row range at the top of each printed page.

Can I repeat a column on every printed page?
Yes. In the same Print Titles dialog, enter a column range in Columns to repeat at left. For example, $A:$A repeats column A on pages created across the worksheet width.

Does Freeze Panes change the printed page breaks?
No. Freeze Panes controls which rows or columns stay visible while you scroll. Page breaks are governed by the print layout and can be reviewed under View > Page Break Preview.

Why can I see repeated headings in preview but not in the worksheet?
Print Titles is a print-layout instruction, not a change to the worksheet data. The repeated headings are visible in the print preview or on paper; they do not create duplicate rows in the sheet itself.

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.