To keep the top row on every printed page in Excel for Microsoft 365 on Windows, open the worksheet, choose Page Layout > Print Titles, enter $1:$1 in Rows to repeat at top, and select OK. Check the result in Print Preview before printing. This setting repeats the row on paper or in a PDF; it is separate from Freeze Panes, which keeps a row visible only while you work on screen.
What You’ll Need
- An Excel workbook with the worksheet you plan to print.
- A header row at the top of the worksheet. The steps below assume the headings are in row 1; you can choose a different row or a group of rows if needed.
- Excel for Microsoft 365 desktop on Windows to set the print-title option. Excel for the web does not currently provide the setting, so use the desktop app if you are working in a browser.
- Access to Print Preview, which you can use whether you plan to print on paper or save the result as a PDF.
Step-by-Step
- Open the correct worksheet. Select the sheet containing the table you want to print. Print titles are set separately for each worksheet, so repeating row 1 on one sheet will not automatically set it on other sheets in the workbook. If several sheet tabs are selected or grouped, click a single worksheet tab before continuing; Excel may disable the title controls when multiple sheets are selected.
- Confirm which row contains the headings. The standard setup assumes your column labels are in row 1. If the labels are in row 2, for example, you will repeat row 2 instead. If the top of the sheet has a title and a separate column-header row, you may want to repeat both rows so each printed page has the title and labels.
- Open the Print Titles controls. On the ribbon, select Page Layout > Print Titles. Excel opens the Page Setup dialog on its Sheet tab. If the ribbon is narrow, look in the Page Setup group or widen the Excel window to reveal the command. You can also open Page Setup using the small dialog launcher in the Page Setup group, then select the Sheet tab.
- Set the row or rows to repeat. In the Rows to repeat at top box, type
$1:$1to repeat only row 1. Alternatively, click the range-selector button beside the box, select the row number 1 on the worksheet, and press Enter or click the selector button again to return to the dialog. For headings in row 3, use$3:$3. To repeat rows 1 through 3, use$1:$3. The dollar signs are part of the range reference Excel uses in this field. - Check the reference before accepting it. Make sure the reference identifies the intended entire row or consecutive rows, not a single cell such as A1. A row reference such as
$1:$1means repeat the complete first row across the top of each printed page. A range such as$1:$3repeats all three rows, so use it only if all three are useful as a printed heading. - Apply the setting. Select OK in the Page Setup dialog. The setting is now saved for the current worksheet. It does not change the visible worksheet, move data, or insert duplicate rows into the workbook; Excel adds the repeated heading when it lays out the pages for printing.
- Preview the pages. Press Ctrl+P on Windows, or choose File > Print. Use the page navigation controls in the preview to inspect the second page and any later pages. Confirm that the headings appear at the top and that the data beneath them is legible. The first page normally shows the heading in its usual position; the important check is that it also appears on subsequent pages.
- Print or create a PDF only after checking the layout. If the preview looks right, choose the printer and settings you want, then print. To create a PDF, use a PDF printer or the PDF option available in your print workflow. If you change the print area, paper size, scaling, or orientation, preview again because those choices can change the number and boundaries of pages.
On Mac: In Excel for Microsoft 365 for Mac, select the worksheet and use Page Layout > Print Titles, then set Rows to repeat at top in the Page Setup dialog. Menu and dialog placement can vary slightly by release. Use Command+P to preview or open printing. In Excel for the web: open the workbook in the desktop app to set repeating print rows; browser printing or worksheet scaling is not a substitute for this setting.
Common Mistakes
- Using Freeze Panes instead of Print Titles. Freeze Panes keeps a row in view while scrolling around the worksheet. It does not make that row repeat on printed pages. Set Print Titles for the print layout; use Freeze Panes separately if you also want the row to stay visible while editing.
- Choosing the wrong row. If the actual labels are in row 2 but you enter
$1:$1, Excel repeats row 1, which might be blank or contain a report title. Look at the row numbers along the left edge and select the row with the headings you need readers to see. - Repeating too many rows. A tall repeated block takes space away from the data on every page. If you set
$1:$6when only row 1 contains useful labels, each page has less room for records and may produce more pages than necessary. Keep the repeated range to the heading rows readers need. - Expecting the setting to apply to every worksheet. Print Titles is a worksheet-level page setup option. Configure it on each sheet you print, and check each sheet’s preview rather than assuming one change covers the whole workbook.
- Checking only the first page. The first page can look correct even when the repeat setting is missing. Navigate to page 2 in Print Preview; that is where you can confirm the heading is repeating.
- Printing a selected cell range and expecting normal sheet settings. If you choose a special selection-based print option, the output may not follow the layout you expect. For a report using Print Titles, preview the worksheet or its defined print area, and verify the pages shown in the preview before sending the job.
Tips
- Use concise, clear column labels. Repeated headings help readers identify columns, but wrapped or very long labels can use a lot of vertical space. Widen columns, shorten labels where appropriate, or adjust wrapping before printing.
- Repeat a report title only when it helps. If row 1 contains a report name and row 2 contains column labels, enter
$1:$2to repeat both. If the report name is useful only on the first page, repeat just the label row instead. Decide based on what someone needs to understand a page viewed by itself. - Use Print Preview after layout changes. Paper size, portrait or landscape orientation, margins, scaling, and print area all affect page breaks. The repeated row stays at the top, but a narrower page or a fit-to-page setting may shrink the text. Check readability as well as whether the heading appears.
- Keep the print area intentional. If the worksheet contains notes or extra columns, define or review the print area so unrelated material is not included. A print area controls what is printed; Print Titles controls which row headings repeat. They solve different problems and may need to be configured together.
- Remember the first-page difference. The repeated row does not create a new heading in the worksheet data. It is part of the page layout, so the source table remains unchanged and calculations or sorting are not affected.
- Set up separate sheets one at a time. For a workbook with several report tabs, open each tab, set its own repeated row, and check its preview. Different sheets can have different header locations and page layouts, so copying one setup blindly may repeat the wrong rows.
Troubleshooting
The heading does not appear on page 2. Reopen Page Layout > Print Titles on the worksheet and inspect Rows to repeat at top. Confirm that the box contains the intended row reference, such as $1:$1, and select OK. Then open Print Preview again and move to page 2. Make sure you are printing the same worksheet on which you set the option.
The Rows to repeat at top box is unavailable. Check whether multiple worksheet tabs are selected. If they are, select one sheet tab to ungroup them, then reopen Print Titles. Also check that you are using the desktop version of Excel rather than Excel for the web, where you cannot set this option. If the workbook is protected or opened in a restricted mode, try enabling editing or ask the workbook owner for permission to change page setup.
The wrong row repeats. Return to the Sheet tab in Page Setup, clear the existing reference, and select the correct row number or enter its full-row reference. For example, use $2:$2 if the headings are in row 2. Preview more than one page after changing it. If the heading spans multiple rows, use a consecutive range such as $1:$2, not separate, non-adjacent rows.
The repeated heading takes too much space or pushes data to another page. Reduce the number of repeated rows, shorten or reformat the heading, or review the page margins and orientation. You can also adjust scaling, but avoid shrinking the whole worksheet so much that text becomes hard to read. Compare the preview before and after each change to identify what improves the layout.
Print Preview does not match the printed page. Check that the selected printer and paper size in Excel match the paper loaded in the printer. Printer drivers can affect margins and page breaks. If you are saving to PDF, inspect the PDF itself because the PDF workflow may use different paper or scaling settings from a physical printer. Reopen the print dialog and preview again after changing the printer or paper options.
Part of the table is missing. Review Page Layout > Print Area and confirm that the area includes the heading row and all the data you want. Also check whether the print setting is set to print a selection rather than the active worksheet. Clear or redefine the print area if necessary, then return to Print Preview to confirm that both the heading and intended columns are included.
Frequently Asked Questions
Does this repeat the top row on every printed page?
Yes. When the worksheet spans multiple pages, the row specified in Rows to repeat at top is printed at the top of each page. It does not add another copy of the row to the worksheet itself.
Can I repeat a row other than row 1?
Yes. Enter the row reference for the headings you want. For example, use $4:$4 to repeat row 4. You can also repeat consecutive rows, such as $3:$4.
Can I repeat two or more rows?
Yes. Enter a consecutive range in the field. For instance, $1:$2 repeats rows 1 and 2 on every printed page. Keep the range as short as practical so it leaves room for the table on each page.
Will Freeze Panes make the row print on every page?
No. Freeze Panes controls what stays visible while you scroll on screen. Use Page Layout > Print Titles to repeat a row in printouts or PDFs.
Can I set this in Excel for the web?
Excel for the web does not currently let you configure repeating print-title rows. Open the workbook in the Excel desktop app, set the rows there, and then preview or print the worksheet.
Do I need to set the row again for each worksheet?
Yes. Print Titles is set separately for each worksheet. Configure the heading rows on every sheet you plan to print, especially if the sheets use different layouts.
Related
- Highlight in Excel Without a Mouse: Keyboard Steps
- Highlight in Excel Using Ctrl+F: Find and Mark Cells
- How to Highlight in Excel and Keep Gridlines Visible
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Outlook Excel Sheet: Create a Data Entry Form in ExcelYes. In Excel for Microsoft 365 on Windows, prepare a worksheet as a list, add Excel’s built-in Form…
- How to Track Changes in Microsoft Word and Review EditsTo track changes in Microsoft Word, open the document, select Review > Track Changes, then edit as usual.…
- Box Plot in Excel: Example, Steps, and InterpretationIn Excel for Microsoft 365 on Windows, put each group of values in its own column, select the…
- Outlook Signature Card: Create and Add It to EmailTo create a signature card in Outlook, make or update your contact in classic Outlook for Windows, format…
- How to Set an Out of Office Reply in OutlookTo set an out of office reply in Outlook, open Automatic Replies for your email account, write your…
- How to Autofill in Excel From the Cell Directly AboveTo fill cells from the one above in Excel, select the source cell and the cells below it,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.