How to Add a Heading to Every Printed Page in Excel

To repeat a heading row on every printed page in Excel for Microsoft 365 on Windows, open the worksheet and choose Page Layout > Print Titles. In the Page Setup dialog, set Rows to repeat at top to the row or rows containing your headings, then check the result in Print Preview. This applies to printouts and PDFs; it does not add a heading to every screen view of the worksheet.

What You’ll Need

An Excel workbook with the worksheet you want to print.
A heading or label row near the top of that worksheet. For a table with column labels in row 1, for example, you can repeat row 1.
Access to desktop Excel for Windows. Excel for the web can print worksheets, but use the desktop app to set or change Print Titles if the setting is unavailable in your browser version.

Step-by-Step

Open the worksheet you plan to print. Click its sheet tab at the bottom of the workbook. Print Titles is a worksheet setting, so make sure you are working on the correct sheet. If several sheet tabs are selected together, click a single tab before continuing; set the print titles separately for each worksheet that needs them.
Check which rows contain the heading. Look at the row numbers along the left edge. If your column names are in the first row, you will repeat row 1. If the report title is in row 1 and the column labels are in row 3, decide whether readers need both; you can repeat rows 1 through 3, including row 2 if it is between them.
Open the Print Titles settings. Select the Page Layout tab on the ribbon, then choose Print Titles in the Page Setup group. Excel opens the Page Setup dialog on its Sheet tab, where you can specify rows or columns to repeat. If Print Titles is unavailable, see Troubleshooting below.
Choose the rows to repeat. Click inside the Rows to repeat at top box. Then click the row number of the first heading row and drag down the row numbers to the last row you want repeated. Excel enters a reference such as $1:$1 for row 1 or $1:$3 for rows 1 to 3. You can also type the reference directly in the box. Use the dollar signs and colon in the reference as shown.
Confirm the setting. Click the small collapse-dialog button at the right of the Rows to repeat at top box if you need to return to the sheet to select the rows; click it again to restore the full dialog. Once the correct reference appears in the box, click OK. The selection does not change how the worksheet looks while you are editing it; it controls how the sheet is divided across printed pages.
Preview the pages before printing. Choose File > Print, or press Ctrl+P on Windows, to open Print Preview. Move through the preview pages and check that the heading appears at the top of each page, not just the first one. Also check that the heading is legible and that the data has not been split in an awkward place.
Adjust the print layout if needed. If the preview has too many pages or columns are cut off, return to the sheet and review its print area, orientation, margins, and scaling. For example, Page Layout > Orientation > Landscape can give a wide report more room. Reopen Page Layout > Print Titles if you need to change the repeated rows, then check Print Preview again.
Print or save a PDF. When the preview looks right, print from File > Print or use the available PDF option in the print dialog. Repeating rows through Print Titles works in the printed output and in a PDF created from the worksheet’s print layout. Keep the workbook so the setting is available the next time you print.

To repeat only the column labels when they are in row 4, enter $4:$4 in Rows to repeat at top. To repeat a report title in row 1 as well as the labels in row 4, those rows are not one continuous range. Excel’s Rows to repeat at top setting takes a contiguous range, so you would need to repeat rows 1 through 4, or rearrange the sheet so the rows you need are together.

Common Mistakes

Using Freeze Panes instead. View > Freeze Panes keeps rows visible while you scroll around the worksheet on screen. It does not make those rows repeat on printed pages. Use Page Layout > Print Titles for printing.
Using a header or footer when you mean worksheet headings. A print header is text or an element placed in the page margin, such as a report name or page number. It does not repeat the worksheet’s column-label row with its cell formatting. Use Print Titles for existing worksheet rows. Use Insert > Header & Footer or the Header/Footer tab in Page Setup when you want separate text in the page margin.
Selecting cells instead of entire rows. In the Rows to repeat at top box, select the row numbers at the left of the sheet. Excel needs a row reference such as $1:$2, not a cell range such as A1:F2.
Repeating too many rows. A long repeated block leaves less vertical room for data on every page and can increase the page count. Include only the report title, column labels, or other context that readers genuinely need repeated.
Expecting the heading to appear while scrolling. Print Titles affects printed pages and print-based PDFs, not the normal worksheet view. To keep headings visible on screen, use Freeze Panes as a separate setting.
Forgetting to preview all pages. A heading may repeat correctly while the body data is split, clipped, or scaled too small. Check more than the first page, especially when the report spans many pages or several columns.

Tips

Keep the rows you want repeated together at the top of the worksheet. If a title and column labels are separated by blank rows or notes, Excel may have to repeat those intervening rows too. A compact title row followed by the column labels is easier to manage and usually preserves more room for data on each page.

Use clear labels that make sense without relying on color alone. Printed pages may be grayscale, and readers may see a page on its own after it has been separated from the rest of the report. If the heading includes a date, department, or units that explain the values, consider whether that context should also repeat.

For a wide sheet, you can repeat columns at the left as well as rows at the top. In the Page Setup dialog’s Sheet tab, use Columns to repeat at left and select the columns containing identifiers, such as names or product codes. This can help readers match values across pages printed side by side. Check the preview carefully because repeating columns reduces the space available for other columns.

Print Titles is independent of the print area. The print area determines which cells Excel prints; repeated rows tell Excel which row labels to show at the top of each page in that output. If you set a print area that excludes the heading rows, do not assume those excluded cells will be added as ordinary data. Verify the result in Print Preview and adjust the print area or layout as necessary.

On Mac, the interface can differ slightly by Excel release. Look for Print Titles on the Page Layout tab; in some versions, Page Setup is also available through File > Page Setup. The same goal is to set the repeating rows in the worksheet’s page setup, then inspect the print preview. On Excel for the web, open the workbook in desktop Excel if you cannot find the repeating-rows control.

Troubleshooting

The heading appears only on the first page. Reopen Page Layout > Print Titles and check that Rows to repeat at top contains the intended row reference. Make sure you set the option on the worksheet you are printing, then preview the later pages again.
The Print Titles command is dimmed or unavailable. Press Enter or Esc to finish editing a cell, and check that you are on a worksheet rather than a chart sheet. If worksheets are grouped, select just the sheet you want to configure. If you are using Excel for the web, open the workbook in desktop Excel and try again.
The repeated heading is cut off or too small. Check the row height, font size, page orientation, margins, and scaling. In Page Layout, review the Scale to Fit options; forcing a large worksheet onto one page can make text hard to read. Use Print Preview to compare a more readable scale with the resulting page count.
The wrong rows repeat. Return to the Rows to repeat at top box and replace the reference with the correct row range. For rows 2 and 3 together, for example, use $2:$3. Do not include a column letter in this box.
The PDF does not match the preview. Create the PDF from Excel’s print workflow rather than taking a screenshot or exporting only selected cells. Confirm that the correct worksheet and page range are selected, and inspect the resulting PDF before sharing it.
The labels repeat but the report title does not. The title may sit outside the repeated row range. Expand the range to include the title and every row between it and the labels, or move the title and labels into adjacent rows at the top of the sheet.

Frequently Asked Questions

Can I repeat more than one heading row?

Yes. Select a continuous block of rows in Rows to repeat at top. For example, to repeat rows 1 through 3, set the reference to $1:$3. Excel cannot use that setting to repeat separated rows while leaving the rows between them out.

Can I repeat a heading on every page of just one worksheet?

Yes. Print Titles is set for each worksheet. Select the sheet you want, set its repeated rows, and preview it. Other sheets in the workbook keep their own print settings and need to be configured separately if required.

Does this add a heading to each page when I save as PDF?

Yes, when you create the PDF from the worksheet’s print layout. The repeated rows appear on the PDF pages in the same way they appear in Print Preview. Check the PDF before sending it, especially if you use a custom print area or page scaling.

What is the difference between Print Titles and a print header?

Print Titles repeats actual worksheet rows, including their cell contents and formatting. A print header is separate content in the top page margin, often used for a report name, date, or page number. Choose the feature that matches what you want readers to see.

Can I repeat a heading column on every printed page too?

Yes. In the same Page Setup dialog, set Columns to repeat at left and select the column or columns to keep visible on each page. This is useful when a report spreads across multiple pages horizontally.

Why does the heading not stay visible when I scroll?

Print Titles controls printed pages, not the on-screen worksheet. To keep a row visible while scrolling, select the row below the heading and use View > Freeze Panes > Freeze Panes. The two settings can be used independently.

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.