To keep a heading row on every printed page in Excel for Microsoft 365 on Windows, select the worksheet, go to Page Layout > Print Titles, and enter the row in Rows to repeat at top—for example, $1:$1 for row 1. Choose OK, then check File > Print to confirm that the heading repeats in the preview.
What Print Titles do
When a worksheet spans several printed pages, Excel normally prints each row and column only where it falls in the grid. That can leave later pages with data but no labels to explain what each column means. Print Titles marks selected rows or columns to be printed again on every page of that worksheet. It does not copy or move cells, change the data, or add rows to the workbook.
The feature is particularly useful for long lists, schedules, inventory sheets, and reports. If a table has headings such as Item, Date, and Quantity in row 1, repeating that row makes the columns understandable on page 2 and beyond. You can also repeat identifying columns at the left when a wide sheet prints across multiple pages.
Print Titles applies to printed output, including a worksheet printed to paper or saved as a PDF through Excel’s print workflow. It does not make headings stay visible while you scroll on screen; that is what Freeze Panes is for.
Set a row to repeat at the top
- Open the worksheet you want to print. If the workbook has several sheets, configure each one that needs its own repeated headings.
- Go to Page Layout > Print Titles. Excel opens the Page Setup dialog on its Sheet tab.
- Click the Rows to repeat at top box. Select the heading row or rows in the worksheet, or type a row reference such as
$1:$1. - Click OK, then open File > Print and inspect the preview pages.
For headings in rows 1 through 3, use $1:$3. This is useful when a report has a title in row 1, a subtitle or date in row 2, and column labels in row 3. Excel repeats all three rows at the top of each printed page. The setting refers to whole worksheet rows, not a selection of individual cells.
Choose which rows and columns to repeat
Use the top-row setting when readers need column labels on every page. Use Columns to repeat at left when the worksheet is wide enough to print on multiple pages from left to right. For example, a report that spans several pages horizontally might repeat its employee-name column, so the values on each printed section remain associated with a person.
You can set both options on the Sheet tab of Page Setup. A worksheet can therefore repeat one or more heading rows at the top and one or more identifying columns at the left. To repeat columns A and B, enter $A:$B in the columns box. To repeat rows 1 and 2 as well, enter $1:$2 in the rows box.
Keep repeated areas concise. Every repeated row takes up space at the top of each page, and every repeated column reduces the room available for other columns on a page. If you repeat a large block, Excel may fit fewer data rows or columns on each sheet of paper, increasing the page count. The best choice is usually the smallest set of labels that makes each page readable.
Check page breaks and print preview
After setting Print Titles, use File > Print to review the actual page layout. The preview lets you check whether the labels appear on each page, whether the right data falls beneath them, and whether a long title row is taking too much space. Use the page navigation controls in the preview to inspect later pages, not just the first one.
Print titles work alongside page breaks. A manual page break determines where Excel starts a new printed page; the repeated heading is then printed on that page too. If a heading seems to appear in the middle of a page or the data breaks in an awkward place, review the page breaks and the print scaling rather than assuming the repeat setting failed.
For a closer look at page divisions, choose View > Page Break Preview. You can adjust page breaks there, but changing a break does not replace setting Print Titles. When a report must fit a particular number of pages, inspect the preview again after changing breaks or layout settings because those changes can alter where the pages divide.
Fit the repeated headings into the page layout
Repeating headings does not guarantee that the worksheet will fit neatly on paper. Page orientation, paper size, margins, column widths, and scaling all affect the result. For a broad report, Page Layout > Orientation > Landscape may provide more horizontal room. To use a different paper size or adjust margins, use the options on the Page Layout tab and verify the result in print preview.
Scaling can make a wide sheet fit, but shrinking an entire worksheet to one page may make both the data and repeated headings too small to read. Consider fitting the sheet to one page wide while allowing it to use multiple pages tall, or adjust column widths and margins first. Excel’s scaling controls are available in the Page Layout tab’s Scale to Fit group; the exact choices shown can depend on the workbook and window size.
Repeated headings consume printable space on every page. If a row is unusually tall because it contains wrapped text, Excel repeats that height too. Shortening the heading, reducing unnecessary blank rows, or adjusting column widths can improve the layout. Do not judge readability only from the on-screen worksheet: paper size and scaling can make printed text look substantially different.
Print Titles versus headers, Freeze Panes, and table headings
Excel uses several similar terms for different features. Print Titles repeats worksheet rows or columns in the printed grid. A page header, added through page-layout header settings, is separate text or content at the top of printed pages, such as a report name, date, or page number. A header does not automatically repeat the cells containing your column labels.
Freeze Panes keeps rows or columns visible while you scroll around the worksheet. It affects the on-screen view, not the printed pages. Conversely, setting Print Titles does not keep a row fixed while you scroll. A workbook can use both features for different purposes.
Excel tables have their own column headers in the worksheet, but turning a range into a table does not by itself mean that those headers will repeat on every printed page. If you need table labels on paper, set the appropriate row in Print Titles and verify the output. This distinction is a common source of confusion: headings that stay visible on screen, or appear as table labels, are not necessarily configured as print titles.
Common problems and how to fix them
- The heading appears only on the first page: Reopen Page Layout > Print Titles and check that the row is entered under Rows to repeat at top. Confirm the later page in print preview.
- The Print Titles command is unavailable: Make sure Excel is not in cell-editing mode; press Enter or Esc to finish editing, then try again. If you are using Excel for the web, open the workbook in the desktop application to set this page setup option.
- The wrong row repeats: Check the row numbers in the reference. A range such as
$1:$3repeats the first three rows, including any title or blank rows in that range. - The data is too small or there are too many pages: Review scaling, orientation, margins, and the number of rows or columns selected to repeat. Repeated areas take up printable space on every page.
- Only part of the heading seems visible: Inspect the row height, wrapped text, column widths, and print preview. A row can repeat correctly but still be clipped or hard to read because of its size or the page layout.
If you are changing several print settings, adjust one at a time and revisit the preview. That makes it easier to identify whether a problem comes from the repeated range, a page break, or scaling. Also check that you are previewing the intended worksheet and print range; a print area can exclude cells that you expected to see.
Excel for Mac and Excel for the web
In the desktop version of Excel for Mac, use the Page Layout tab and its Print Titles command to set repeating rows or columns, then inspect the print preview. Ribbon arrangements can differ slightly from Windows, but the setting is still part of worksheet page setup. If you cannot find it, check that you are using the desktop app rather than the browser version.
Excel for the web has different page-layout capabilities, and its interface may not offer the desktop Print Titles controls. For a workbook that needs repeated heading rows or columns, choose the option to open or edit it in the Excel desktop app, configure Print Titles there, and print or save the PDF from the desktop app. A PDF made from the browser should not be assumed to include repeated titles unless the preview confirms it.
Frequently Asked Questions
How do I repeat the first row on every page in Excel?
Go to Page Layout > Print Titles, enter $1:$1 in Rows to repeat at top, and choose OK. Check a later page in File > Print to confirm the row repeats.
Can I repeat more than one heading row?
Yes. Select or enter a contiguous range of whole rows, such as $1:$3. Excel repeats all rows in that range at the top of each printed page.
Can I repeat a column on every printed page?
Yes. In the same Page Setup dialog, enter the column or contiguous column range in Columns to repeat at left. For example, $A:$A repeats column A.
Why does my Excel header not repeat when I print?
A page header and a worksheet heading row are different features. To repeat cells containing labels such as Date or Amount, configure Rows to repeat at top in Print Titles. Page headers are for separate page-level content.
Does Freeze Panes make a heading print on every page?
No. Freeze Panes only keeps rows or columns visible while scrolling on screen. Use Print Titles for repeated content in printed pages or a PDF.
A practical setup for a multi-page report
Suppose a sales worksheet has a report title in row 1, a date range in row 2, column labels in row 3, and hundreds of records below. If readers need only the column labels on each page, set row 3 as the print title. If the report’s title and date are also important on every page, repeat rows 1 through 3. Then preview several pages and decide whether the repeated block leaves enough room for the records.
For a wide version of the same report, you might also repeat the salesperson column at the left so names remain visible on pages containing later measures. Review whether that extra column makes the remaining data too narrow. These choices depend on what readers need to identify each value, not simply on which rows happen to be at the top of the sheet. Once the preview is clear and legible, print the worksheet or save it as a PDF for sharing.
Related
- Excel Number Format for Negative Numbers in Parentheses
- Excel Number Format for Lakhs With Commas
- Excel Number Format for Millions With One Decimal Place
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Keyboard Shortcut to Remove Decimal PlacesIn Excel for Microsoft 365 on Windows, select the cells and press Alt+H, 9 to show one fewer…
- Outlook Share Calendar Permissions: A Practical GuideOutlook calendar permissions control what another person can see or do in your calendar: depending on the access…
- How to Get the Search Bar Back in Excel: Quick FixesTo restore the main Search box in Excel for Microsoft 365 on Windows, open File > Options >…
- Removing Duplicates in Google Sheets: A Practical GuideTo remove duplicate rows in Google Sheets, select your table, choose Data > Data cleanup > Remove duplicates,…
- Excel Keyboard Shortcuts: How to Work Without a MouseYes. In Excel for Microsoft 365 on Windows, you can navigate worksheets, select cells, enter and format data,…
- Google Sheets Formulas vs Excel: Key DifferencesGoogle Sheets and Excel use many of the same formula conventions, so everyday calculations such as sums, averages,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.