Yes. In desktop Excel, use Page Layout > Print Titles, then set Rows to repeat at top to the row or rows containing your labels. For the first row, enter $1:$1; for the first two rows, enter $1:$2. Check Print Preview before printing.
Repeat rows on every printed page in Excel for Windows
- Select the worksheet you want to print.
- Open Page Layout > Print Titles.
- On the Sheet tab in Page Setup, enter the row range in Rows to repeat at top. Use
$1:$1for row 1 or$1:$2for rows 1 and 2. Alternatively, use the range selector to select the rows on the sheet. - Select OK, then open print preview and check that the repeated rows and page breaks look right.
These are the desktop Excel steps described by Microsoft’s instructions for repeating rows or columns. Interface details may vary by Excel version.
As an Amazon Associate I earn from qualifying purchases.
Use the Mac-specific Page Setup path
In Excel for Mac, go to Page Layout > Page Setup > Sheets, choose the rows to repeat, and confirm. Then use File > Print to preview the pages. See Microsoft’s Excel for Mac instructions.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchPC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Keep row labels visible on wide printouts
If a worksheet spans multiple printed pages horizontally, use Columns to repeat at left in the same Page Setup area to repeat the relevant label columns on each page. This is separate from repeating rows at the top; use whichever direction matches how the printed pages divide. Microsoft documents both options in its repeat-rows-and-columns guidance.
#1 Best Overall
Excel for the web: use desktop Excel to repeat headers
Microsoft says Excel for the web cannot currently repeat column headers when printing. For that operation, open the workbook in the desktop app. This limitation concerns repeating column headers; it does not establish that every printing feature is unavailable in the web version. See Microsoft’s platform and printing guidance.
Print titles are not row numbers or column letters
Print titles are your worksheet’s own data rows or columns—such as a table’s labels—that you want repeated on each printed page. The row numbers and column letters around the sheet are built-in row and column headings; they have a separate print setting and are not printed by default. Turning on those headings will not repeat your table’s labels. Microsoft explains the distinction in its Page Setup documentation and heading-printing instructions.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.If Print Titles is dimmed or the repeat fields are unavailable
- You are editing a cell: finish or cancel the edit, then try again.
- A chart is selected: select a worksheet cell rather than the chart.
- No printer is installed: Microsoft lists this as another reason the command may be dimmed.
- Several worksheets are selected: ungroup the sheets and select a single worksheet; the repeat-row and repeat-column fields are unavailable while multiple sheets are selected.
These troubleshooting causes are listed in Microsoft’s print-titles guidance and its printing help.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Quick Recap
Best Value
Rank #3
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
