Fix Greyed-Out Rows to Repeat at Top in Excel 2019
Question details
Find out why Rows to Repeat at Top is unavailable in Excel 2019 and how to enable it.

- Product
- Microsoft Excel 2019
- Device & OS
- not provided
- Scenario
- The user wants to repeat worksheet header rows at the top of each printed page.
- Observed behavior
- The Rows to Repeat at Top option is greyed out even though the worksheet is not protected, grouped, or being edited.
Open the worksheet you want to print and identify the header rows to repeat. Check that a printer is available in File > Print.
Open Print Titles from the worksheet
Use this method to check the entry point and worksheet state before setting repeating rows.
If you are in File > Print or Print Preview, return to the worksheet, then press Esc to exit any active cell edit.
Click the tab of the worksheet you want to print. If sheets are grouped, right-click a sheet tab and select Ungroup Sheets.
On the Page Layout tab, select Print Titles to open the Sheet tab of Page Setup.
Click Rows to repeat at top, enter a range such as $1:$1, and select OK. Check the result in File > Print.

Check the printer setup
Try this if Print Titles remains unavailable after you return to the worksheet.
Set up repeating print headers in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for working on spreadsheets and preparing them for print. Its Excel format compatibility makes it easier to move existing files to WPS, although it does not fix Excel's settings.

Frequently Asked Questions
Where do I find Rows to Repeat at Top in Excel 2019?
Select the worksheet, then go to Page Layout > Print Titles. The Rows to repeat at top field is on the Sheet tab of Page Setup.
Why is the option unavailable in Print Preview?
Some page setup controls are unavailable when opened from Print Preview. Return to the worksheet and open Page Layout > Print Titles instead.
How do I repeat more than one header row?
In Page Layout > Print Titles, enter a range such as $1:$2 in Rows to repeat at top, then select OK.
Can a missing printer affect Print Titles?
Printer availability or a missing driver can affect page setup options. Check File > Print for a selected printer, then add a printer or install its driver if needed.




