If an Excel worksheet prints on several pages, you can repeat a header row at the top of each printed page. Open the Page Layout tab, click Print Titles, and enter the row in the Rows to repeat at top box. For the first row, use $1:$1.
Repeat the first row on every printed page
- Open the worksheet you want to print.
- Select the Page Layout tab.
- Click Print Titles in the Page Setup group.
- On the Sheet tab, click inside Rows to repeat at top.
- Enter $1:$1, or use the selection button and click row 1 in the worksheet.
- Click OK.
Use File > Print to preview the result before printing. The repeated row is a print setting; it does not insert copies of the row into the worksheet itself.
Repeat more than one row
To repeat the first two rows, enter $1:$2. For the first three rows, use $1:$3. You can also repeat columns on the left side of each printed page by using the Columns to repeat at left field.
The command can be disabled when you are editing a cell, when certain objects such as a chart are selected, when worksheets are grouped, or when Windows does not have a printer configured. Exit cell-editing mode and make sure only one worksheet is selected before trying again.
Although this article was originally written for Excel 2013, the Print Titles feature remains available in current desktop versions of Excel, including Microsoft 365.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.