Printing Problems

Enable Rows and Columns to Repeat in Excel Page Setup

Camila MilosovichCamila Milosovich Nov 18, 2026 869 views

Question details

The user needs to enable Excel's Print Titles fields to repeat selected rows and columns on printed pages.

Enable Rows and Columns to Repeat in Excel Page Setup
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.
Before you start

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.

Solution 1Recommended

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.

1
Finish editing the cell

Press Enter to finish editing the active cell, or press Esc to cancel the edit.

2
Ungroup worksheets

If multiple sheet tabs are selected, right-click a selected sheet tab and choose Ungroup Sheets. Then select the worksheet you want to print.

3
Open Print Titles

On the worksheet, select Page Layout > Print Titles to open the Sheet tab in Page Setup.

4
Set repeating headers

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.

5
Check the printed pages

Go to File > Print and use the preview to check that the selected rows or columns repeat on the pages.

Select one worksheet and exit cell-edit mode
Free Microsoft Office alternative

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.

Work with spreadsheet headers and print settings in WPS Spreadsheet.Open and edit Microsoft Excel XLS and XLSX files.Use a familiar interface to transition from Microsoft Office.Get a free, lightweight office suite for everyday documents.
microsoft office alternative - wps office

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.