Office Settings & Configuration

Fix Greyed-Out Rows to Repeat at Top in Excel 2019

Elise WilliamsElise Williams Nov 18, 2026 869 views

Question details

Find out why Rows to Repeat at Top is unavailable in Excel 2019 and how to enable it.

Fix Greyed-Out Rows to Repeat at Top in Excel 2019
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.
Before you start

Open the worksheet you want to print and identify the header rows to repeat. Check that a printer is available in File > Print.

Solution 1Recommended

Open Print Titles from the worksheet

Use this method to check the entry point and worksheet state before setting repeating rows.

1
Return to the worksheet

If you are in File > Print or Print Preview, return to the worksheet, then press Esc to exit any active cell edit.

2
Select one sheet

Click the tab of the worksheet you want to print. If sheets are grouped, right-click a sheet tab and select Ungroup Sheets.

3
Open Print Titles

On the Page Layout tab, select Print Titles to open the Sheet tab of Page Setup.

4
Set the repeating rows

Click Rows to repeat at top, enter a range such as $1:$1, and select OK. Check the result in File > Print.

Open Print Titles from the worksheet
Still unavailable?: If the sheet is already unprotected, ungrouped, and not being edited, check the printer setup and reopen Print Titles.
Free Microsoft Office alternative

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.

Prepare spreadsheet header rows for repeated printingOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar ribbon-style interfaceWork with a free, lightweight Office alternative
microsoft office alternative - wps office

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.