Enable Rows and Columns to Repeat in Excel Page Setup
Question details
The user needs to enable Excel's Print Titles fields to repeat selected rows and columns on printed pages.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants header rows or columns to appear on every printed page of a worksheet.
- Observed behavior
- The Rows to repeat at top or Columns to repeat at left fields are disabled in Page Setup.
Open the worksheet you want to print and identify the header rows or columns to repeat. Make sure a printer is installed and available on your device.
Select one worksheet and exit cell-edit mode
Use this method when the Print Titles fields are disabled because worksheets are grouped or a cell is being edited.
Press Enter to finish editing the active cell, or press Esc to cancel the edit.
If multiple sheet tabs are selected, right-click a selected sheet tab and choose Ungroup Sheets. Then select the worksheet you want to print.
On the worksheet, select Page Layout > Print Titles to open the Sheet tab in Page Setup.
In Rows to repeat at top, enter a reference such as $1:$1. In Columns to repeat at left, enter a reference such as $A:$A. Set either or both fields, then click OK.
Go to File > Print and use the preview to check that the selected rows or columns repeat on the pages.

Check the installed and default printer
Use this method if Print Titles remains disabled after you select a single worksheet and exit cell-edit mode.
Manage Printed Spreadsheet Headers in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Excel format compatibility. Open existing spreadsheets in WPS Spreadsheet for an easy transition, while using Excel's own settings to fix disabled Print Titles in Excel.

Frequently Asked Questions
Why are Rows to repeat at top and Columns to repeat at left grayed out?
Excel may be in cell-edit mode, multiple worksheets may be grouped, or a printer may not be available. Press Enter or Esc, ungroup the sheets, and check your printer settings before reopening Page Layout > Print Titles.
How do I repeat the first row on every printed page?
Select the worksheet, go to Page Layout > Print Titles, and enter $1:$1 in Rows to repeat at top. Click OK and check File > Print.
How do I repeat the first column on printed pages?
Go to Page Layout > Print Titles and enter $A:$A in Columns to repeat at left. Click OK, then check the pages in File > Print.
Where can I check whether Excel has a printer selected?
Open File > Print and check the printer selection. If none is available, add a printer in your device's printer settings and set it as the default, then reopen Excel.




