To repeat rows or columns on every printed page in Excel for Microsoft 365 on Windows, open Page Layout > Print Titles, then enter the row range in Rows to repeat at top or the column range in Columns to repeat at left. This repeats headings in the printout; it is separate from setting a print area, which determines which cells Excel prints.
What Excel Means by Print Titles
Excel calls the rows or columns repeated across printed pages “print titles.” They are useful when a worksheet is wider or taller than one printed page. For example, a sales report might have field names in row 1 and hundreds of records below. If the records continue onto page 2, repeating row 1 lets readers identify each column without returning to the first page.
Print titles affect the printed or exported page layout, not the worksheet itself. They do not copy data, insert rows, or freeze headings while you scroll on screen. For on-screen scrolling, use View > Freeze Panes; that is a different feature with a different purpose.
You can repeat one or more complete rows at the top and one or more complete columns at the left. For instance, a report with a title in row 1 and column labels in row 2 could repeat both rows, while a wide table with identifiers in columns A and B could repeat both columns. The repeated areas stay visible on each applicable printed page as Excel divides the sheet across pages.
How to Repeat Rows on Every Printed Page
Set the print titles on the worksheet you want to print. In Excel for Microsoft 365 on Windows:
- Select the worksheet tab. If the workbook has several sheets, check that you are configuring the intended sheet.
- Choose Page Layout > Print Titles. Excel opens the Page Setup dialog on its Sheet tab.
- Click in Rows to repeat at top, then select the row or rows on the worksheet. You can also type a reference such as
$1:$2to repeat rows 1 and 2. - Choose OK to save the setting.
- Open print preview with Ctrl+P and move through the preview pages to confirm the headings repeat.
To select rows from the dialog, click the small range-selection button beside the field if it is shown, select the row headers on the sheet, and return to the dialog. The reference should identify complete rows, such as $3:$3 for row 3 or $1:$3 for rows 1 through 3. A range such as $1:$2 is contiguous; Excel does not use separate, nonadjacent rows as one repeat-title range.
Choose only the rows readers need to interpret the data. If you repeat a large block of rows, it takes up more space on every printed page and leaves less room for new records. A title row, column headings, and perhaps a short note may be useful; repeating several rows of introductory text usually is not.
Repeat Columns at the Left
For a wide worksheet, use the neighboring Columns to repeat at left field in the same Page Setup dialog. Select the columns to repeat or enter a reference such as $A:$B to repeat columns A and B. This is helpful when the first columns contain names, dates, or account IDs that identify the values extending across later pages.
You can set both repeating rows and repeating columns. For example, a cross-tab report might repeat row 1, which contains month names, and column A, which contains product names. On printed pages that continue downward or to the right, Excel repeats the corresponding headings. Use print preview to check that those labels remain legible and do not crowd out the report’s main values.
Repeated columns are particularly useful with landscape pages or large tables that span several pages horizontally. They are not a way to force a narrow worksheet onto one page; they only repeat the selected label columns where the sheet’s printed layout has additional pages.
Print Area Versus Print Titles
A print area tells Excel which cells to include in the printout. Print titles tell Excel which row or column labels to repeat on additional pages. These settings can be used together, but neither substitutes for the other. Setting a print area does not automatically make its first row repeat, and choosing repeat rows does not limit the printout to a particular block of cells.
To define the print area, select the cells you want included, then choose Page Layout > Print Area > Set Print Area. For example, if a worksheet has notes in columns G and H but the report is only in A1:F80, selecting A1:F80 before setting the area keeps those notes out of the printout. If the report spans multiple pages, print titles can still repeat its headings within that selected area.
To clear the current print area, choose Page Layout > Print Area > Clear Print Area. A worksheet can have more than one print area, but separate areas print as separate sections rather than being joined into one continuous table. If you select multiple areas, check the resulting pages carefully. For a simple multipage table, one continuous print area is usually easier to manage.
It is common to call the whole task “repeating the print area,” but repeating an entire selection is not the usual Excel control. If the practical goal is to show the same column labels on each page, set print titles. If the goal is to include only certain cells, set the print area. If both are needed, configure both settings.
Check Page Breaks and Print Preview
After setting titles, preview the actual output rather than relying only on the worksheet view. Press Ctrl+P on Windows to open the print screen, check the page count, and move among pages. The preview shows whether the intended headings repeat and whether the data breaks across pages sensibly. On a Mac, use Command+P to open the print dialog; ribbon labels and dialog presentation can differ slightly by Excel version.
Page breaks depend on the paper size, orientation, margins, scaling, and printer settings. If the table spills onto many pages horizontally, switching to landscape orientation or adjusting margins may help. On the Page Layout tab, Excel’s Scale to Fit controls can also reduce the width to one page. Be cautious with scaling: forcing a large table onto a single page can make text too small to read, even if the headings are configured correctly.
For more control over where a page ends, use View > Page Break Preview. This view displays page boundaries and allows manual page breaks to be adjusted. Page breaks control how content is divided; they do not set or remove print titles. Review the preview again after changing them, since moving a break can change which records appear together on a page.
Common Problems and Fixes
- The headings show only on page 1: Reopen Page Layout > Print Titles and confirm the correct range is in the repeating-row or repeating-column field. Then inspect a later page in print preview.
- The field is unavailable or the setting will not apply: Confirm that you are using the desktop Excel app and that the correct worksheet is active. Excel for the web does not provide the desktop Print Titles setup; open the workbook in the desktop app to configure it.
- Repeated headings use too much room: Reduce the repeated range to the essential labels. Rows repeated at the top and columns repeated at the left consume printable space on pages where they recur.
- The heading appears cut off or too small: Check row height, column width, margins, orientation, and scaling. A narrow page or aggressive scaling can make headings difficult to read even when the repeat range is correct.
- Extra cells appear in the printout: Check whether the print area includes them. Use Page Layout > Print Area > Clear Print Area to return to printing the worksheet’s used content, or set a new print area around the intended report.
Another frequent source of confusion is using Freeze Panes and expecting the frozen headings to print on every page. Freeze Panes changes the on-screen scrolling view only. To repeat headings on paper or in a print-to-PDF output, configure Print Titles separately.
Excel for Mac and Excel for the Web
In current Excel for Mac desktop versions, look for Page Layout > Print Titles and set the repeating rows or columns in the Page Setup controls. The precise appearance of the dialog can vary by release, but the setting is a page-layout option. Use Command+P for the Mac print dialog; the Windows shortcut is Ctrl+P.
Excel for the web has fewer page setup controls and does not offer the desktop Print Titles setup described above. If the workbook needs new or changed repeating headings, choose the option to open it in the desktop Excel app, configure the titles there, and save the workbook. The web version may still be useful for viewing or printing a workbook, but do not assume it can create this setting.
Print titles are worksheet-specific, so setting them on one sheet does not automatically configure every other sheet in the workbook. If several worksheets need the same printed headings, review each one’s page setup and preview. This also helps catch differences in page orientation or print area between reports.
Frequently Asked Questions
How do I repeat the top row on every page in Excel?
Choose Page Layout > Print Titles, enter or select row 1 in Rows to repeat at top, and click OK. In print preview, move to a later page to confirm row 1 appears there.
Can I repeat more than one row?
Yes. Select a contiguous range of rows, such as rows 1 through 3, in Rows to repeat at top. Keep the range as short as possible so it does not take too much space from the printed data.
Can I repeat both rows and columns?
Yes. Set a row range in Rows to repeat at top and a column range in Columns to repeat at left in the Page Setup dialog. Check pages that continue both downward and across to make sure the labels are useful.
Does repeating a row also freeze it on screen?
No. Print Titles affect printed pages, while View > Freeze Panes keeps rows or columns visible as you scroll on screen. Set both if you need both behaviors.
Why can’t I find Print Titles in Excel for the web?
The web app does not provide the desktop Print Titles setup. Open the workbook in Excel for Microsoft 365 on Windows or a supported desktop version, configure the setting from Page Layout > Print Titles, and save the workbook.
Related
- Excel Not Responding: Causes, Fixes, and What to Try
- Marked Scatter Plot in Excel: Create and Format One
- Matrices in Excel Solver: When It Helps and When It Doesn’t
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add a Watermark in Word Online (and What Works)Word for the web can display a watermark that is already in a document, but it generally cannot…
- Where Is the Subscript Button in Excel? Find It FastIn Excel for Microsoft 365 on Windows, there is no dedicated Subscript button on the ribbon. Select the…
- Power Query Overflow Errors: Causes and FixesPower Query overflow errors occur when a value or calculation cannot fit the numeric or date type being…
- How to Find Duplicates in Excel Quickly and AccuratelyTo find duplicate values in Excel, select the cells you want to check, then choose Home > Conditional…
- Excel: How to Consolidate Columns Into One ColumnTo stack values from several Excel columns into one vertical list, use =TOCOL(A2:C100,1,TRUE) in Microsoft 365 or Excel…
- Unmerge Cells in Excel on iPad: Step-by-StepTo unmerge cells in Excel on an iPad, tap the merged cell, open the Home tab, tap Merge…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.