Fix Excel Print Titles Grayed Out After an Office Upgrade
Question details
The user needs to restore Excel's Print Titles option after an Office upgrade so selected rows or columns repeat on every printed page.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Setting repeated row or column headings for a multipage worksheet after upgrading Office.
- Observed behavior
- The Print Titles command is grayed out and cannot be selected.
Open a worksheet, press Enter or Esc to exit cell-editing mode, and select only one worksheet tab rather than grouped sheets or a chart sheet. Access Print Titles from Page Layout rather than the Print Preview screen; the Safe Mode and repair instructions below apply to Windows.
Check Print Titles access and update Microsoft Office
Use this first to rule out worksheet-state restrictions and install available fixes for the upgraded Office installation.
Select a single worksheet tab, then choose Page Layout > Print Titles. If worksheet tabs are grouped, right-click a selected tab and choose Ungroup Sheets before trying again.
Go to File > Account > Update Options > Update Now. Allow available updates to finish, then close and reopen Excel. If Update Options is unavailable, ask your administrator how updates are managed.
Return to Page Layout > Print Titles. On the Sheet tab, select Rows to repeat at top or Columns to repeat at left, choose the required rows or columns, and click OK. Open File > Print and check multiple pages in the preview.
Test Excel in Safe Mode and isolate conflicting add-ins
Use this when Print Titles remains disabled after basic checks and Office updates. Safe Mode helps identify whether an add-in or startup customization is involved.
Run an Online Repair for Microsoft Office
Use this when the command remains disabled after updates and Safe Mode testing, especially if the issue affects multiple workbooks.
Print Excel Worksheets with Repeating Headings in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel files. Open your workbook in WPS Spreadsheet and use its print-title settings to repeat headings without repairing Microsoft Office. Familiar controls and format compatibility make migration straightforward, but check print preview before printing.
Frequently Asked Questions
Why are the Print Titles fields disabled in Print Preview?
Excel may disable the repeating-row and repeating-column fields when Page Setup is opened from Print Preview. Return to the worksheet, select Page Layout > Print Titles, and configure them on the Sheet tab.
Can I set Print Titles for several selected worksheets at once?
The Print Titles settings can be unavailable when worksheets are grouped. Right-click a selected worksheet tab, choose Ungroup Sheets, and configure Page Layout > Print Titles separately for each worksheet.
What does it mean if Print Titles works in Excel Safe Mode?
It suggests that an add-in or startup customization may be interfering. Restart Excel normally, open File > Options > Add-ins, and disable add-ins for testing. Re-enable them individually to identify the cause.
How do I repeat the first row on every printed page?
In Excel, choose Page Layout > Print Titles. On the Sheet tab, enter $1:$1 in Rows to repeat at top, click OK, and use File > Print to verify the heading appears on subsequent pages.
Will WPS Office repair Excel's disabled Print Titles command?
No. WPS Office is an alternative application, not a repair tool for Microsoft Office. You can open the workbook in WPS Spreadsheet and use Page Layout > Print Titles to set repeating headings, then check the printed layout in preview.
