Can I Repeat Rows in Excel When I Print? (Yes, Here’s How)

Yes. To repeat rows at the top of every printed page in Excel, go to Page Layout > Print Titles, click in the Rows to repeat at top box, and enter the row, such as $1:$1 for row 1. Click OK, and that row prints at the top of each page.

These steps apply to Excel for Microsoft 365 and Excel 2016 through 2024 on Windows and Mac, as in Microsoft’s Repeat specific rows or columns on every printed page article. Excel for the web has its own section below.

Use the Desktop Excel App

  • Use the desktop Excel app. The Print Titles button lives on the Page Layout tab in Excel for Windows and Mac.
  • Know which rows hold your labels. Most sheets have one header row, such as row 1 with column names like Date, Item and Amount. Some have a title row plus a header row, so you would repeat rows 1 and 2.
  • Click a single cell on the sheet first. If you are typing in a cell or have a chart selected, Print Titles is grayed out.
  • Make sure a printer is installed, even a PDF printer such as Microsoft Print to PDF. Microsoft lists a missing printer as one reason the button is dimmed.

How to Repeat Rows on Every Printed Page in Excel

  1. Open the workbook and click the tab of the worksheet you want to print.
  2. Click the Page Layout tab on the ribbon.
  3. In the Page Setup group, click Print Titles. The Page Setup window opens on its Sheet tab.
  4. Under Print titles, click in the Rows to repeat at top box.
  5. Type the rows you want, such as $1:$1 for row 1 or $1:$2 for rows 1 and 2.
Excel Page Setup Sheet tab with $1:$1 in the Rows to repeat at top box
Type the rows to repeat, such as $1:$1, in Rows to repeat at top.
  1. Click OK. The window closes, and nothing changes on screen in Normal view.

The rows you entered now print at the top of every page. If a short table prints in the top-left corner, you can center the worksheet on the printed page. To make that header row stand out on paper, add a thick bottom border in Excel under it. Borders and fill colors on the title row print on every page along with the text.

Steps to repeat rows on every printed page in Excel: Page Layout, Print Titles, Rows to repeat at top
Illustration: how to repeat rows when printing in Excel.

What to Type in the Boxes

The dollar signs tell Excel to use whole rows or columns. You can type the reference with or without them, and Excel adds the dollar signs when you pick rows with the mouse.

To repeat Box Type
Row 1 Rows to repeat at top $1:$1
Rows 1 through 3 Rows to repeat at top $1:$3
Rows 4 and 5 (header lower on the sheet) Rows to repeat at top $4:$5
Column A Columns to repeat at left $A:$A
Columns A and B Columns to repeat at left $A:$B

The rows must sit next to each other. You can’t repeat row 1 and row 5 without the rows between them. The header rows also don’t have to start at row 1, which helps when your sheet has a logo or report title above the column labels.

How to Pick the Rows With Your Mouse

If you’d rather not type the reference, click the Collapse Dialog button at the right end of the Rows to repeat at top box. The window shrinks to a single box. Click a row number on the left edge of the sheet, or drag down across several row numbers. Click Collapse Dialog again to bring back the full window. Excel fills in the reference, such as $1:$2, and you click OK.

How to Repeat Columns on Every Page

Wide sheets that print across several pages can lose their row labels instead. Use the Columns to repeat at left box in the same Page Setup window. Enter the columns that hold your row labels, such as $A:$A for a column of names or product codes. You can fill in both boxes to repeat rows and columns together, which keeps a large table readable on every page.

If labels you type in those rows or columns, such as 1-2 or 3/4, keep turning into dates, see why Excel keeps changing numbers to dates.

Excel Print Titles options: rows to repeat at top, columns to repeat at left, and fixes
Illustration: Print Titles options in Excel.

How to Check That It Worked

  1. Press Ctrl+P on Windows or Command+P on a Mac. You can also click File > Print. For a company name or page number at the bottom of each page, you can add one footer to all sheets in Excel through Page Setup.
  2. Use the page arrows under the preview to move to page 2 and later pages.
  3. Look for your header row at the top of each page.
Excel print preview of page 2 showing the repeated header row at the top
Page 2 of the preview shows the header row again at the top.

If the wrong row repeats, reopen Print Titles and fix the reference. To see where Excel splits the pages before you print, go to View > Page Break Preview. Dashed lines are automatic page breaks, and solid lines are breaks you added. To start a new page at a specific row, select the row below the break, then click Page Layout > Breaks > Insert Page Break, as described in Insert, move, or delete page breaks. Repeated headers matter most on long printouts, and the article on printing a large Excel spreadsheet covers the scaling and page break settings that go with them.

If the sheet only needs a few more columns to fit, you can also fit the spreadsheet on one page and skip print titles.

Why Is Print Titles Grayed Out?

The Print Titles button looks dimmed for one of three reasons:

  • You are still editing a cell. Press Enter or Esc first.
  • A chart is selected on the sheet. Click a cell instead.
  • No printer is installed on your computer.

If Excel can’t find your printer, follow the setup and troubleshooting steps for printing on Windows 11.

If the button works but the Rows to repeat at top and Columns to repeat at left boxes aren’t available, more than one worksheet is selected. The title bar may show “Group” next to the file name. Click any unselected sheet tab, or right-click a selected tab and choose Ungroup Sheets.

Can Excel Repeat Rows at the Bottom of Each Page?

No. Print titles only offer Rows to repeat at top and Columns to repeat at left. If you want the same text at the bottom of every page, such as a company name or “Page 1 of 3”, use a footer. Go to Insert > Header & Footer, scroll to the footer area, click the left, center, or right box, and type your text. Microsoft covers the options in Headers and footers in a worksheet. A footer holds typed text and items such as page numbers, not a row of cells from the sheet.

What About Excel for the Web?

Use the desktop app. Repeating column headers when printing isn’t currently possible in Excel for the web. In Excel for the web, choose Editing > Open in Desktop App, then follow the steps above. Print titles you set in the desktop app are saved with the workbook.

Print Titles vs. Row and Column Headings

Print titles repeat your own label rows, like a row of month names. Row and column headings are the numbers and letters along the edge of the sheet. Excel doesn’t print those by default. To print them, go to Page Layout and, under Headings in the Sheet Options group, check Print. Microsoft covers this in Print row and column headings. For the cell lines, use the separate setting to print gridlines in Excel.

Print titles only affect printed pages and PDFs. To keep a header row visible while you scroll on screen, use freeze panes in Excel instead.

To stop people from changing a sheet you share or print, lock the cells in Excel.

Print Titles Questions

Do print titles apply to every sheet in the workbook?

No. Print titles are set per worksheet. Select one sheet at a time and set them for each sheet you print, since the boxes aren’t available while several sheets are grouped.

How do I stop repeating a row?

Go back to Page Layout > Print Titles, delete the reference in the Rows to repeat at top box, and click OK.

Will the repeated row show up when I save as a PDF?

Yes. Print titles apply to anything Excel sends to a printer, including a PDF printer and File > Save As with PDF chosen as the file type. Check the print preview first.

Does Excel remember print titles after I close the file?

Yes. The setting is saved with the workbook, so the same rows repeat the next time you open and print it.

Can I repeat a header row from an Excel table?

Yes. Enter the worksheet row that holds the table’s header, such as $3:$3. Print titles use worksheet row numbers, not the table’s own rows.

More Excel Printing Guides