Printing Problems

Fix Excel Page Setup Unresponsive When Setting Rows to Repeat

Jason MillerJason Miller Oct 21, 2026 869 views

Question details

The user is unable to specify rows to repeat at the top of printed pages because the Excel Page Setup dialog becomes unresponsive.

How to Fix Excel Page Setup When Rows to Repeat Cannot Be Entered
Product
Microsoft Excel
Device & OS
not provided
Scenario
Attempting to set print titles (rows to repeat at the top) for printing or exporting a worksheet.
Observed behavior
The Page Setup dialog freezes or becomes unresponsive, preventing the user from entering the desired rows to repeat.
Before you start

Ensure you save any unsaved work in other open applications, as restarting Excel via Task Manager will close all active workbooks without prompting you to save.

Solution 1Recommended

Restart Excel and Run Office Online Repair

If the Page Setup dialog is frozen, force-closing Excel and running the built-in Microsoft Office repair tool can fix corrupted application files causing the unresponsiveness.

Unresponsive dialog boxes in Excel are frequently caused by corrupted temporary files, conflicting background processes, or damaged Microsoft Office installation files. Using the built-in Online Repair tool replaces missing or corrupted components without deleting your personal files.

1
Force close Excel via Task Manager

Press Ctrl + Shift + Esc on your keyboard to open the Task Manager. Locate 'Microsoft Excel' in the processes list, right-click it, and select 'End task'.

2
Test Page Setup again

Reopen your Excel workbook, navigate to the Page Layout tab, and click 'Print Titles' to see if the Page Setup dialog is now responsive.

3
Access Programs and Features

If the problem continues, open the Windows Start menu, type 'Control Panel', and press Enter. Navigate to 'Programs' > 'Programs and Features'.

4
Run Online Repair

Find 'Microsoft Office' in the list of installed programs. Right-click it, select 'Change', choose 'Online Repair', and click 'Repair'. Follow the on-screen prompts to complete the repair process.

Restart Excel and Run Office Online Repair
Online Repair Requires Internet: The Online Repair option requires an active internet connection as it downloads fresh installation files from Microsoft servers. This process may take several minutes depending on your connection speed.
Free Microsoft Office alternative

Experience Crash-Free Printing and Page Setup with WPS Office

If Microsoft Excel continues to freeze or crash during basic page setup tasks, consider switching to WPS Office. It provides a highly stable, lightweight environment for all your spreadsheet needs, allowing you to easily set rows to repeat on printed pages without dealing with unresponsive dialog boxes.

Fully compatible with Microsoft Excel (.xlsx, .xls) files and VBA macros.Lightweight architecture ensures fast performance without freezing during page setup.Built-in, seamless PDF export feature directly accessible from the print menu.Familiar user interface means zero learning curve for existing Excel users.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel freeze only when I open the Page Setup dialog?

This specific freezing issue is typically related to printer spooler conflicts, outdated printer drivers, or corrupted Microsoft Office installation files. Excel attempts to query your default printer when opening Page Setup, which can cause a freeze if the printer communication fails.

Can I set columns to repeat instead of rows?

Yes. In a functioning Page Setup dialog, you can use the 'Columns to repeat at left' field under the Sheet tab. If using VBA, the equivalent property to modify is ActiveSheet.PageSetup.PrintTitleColumns = "$A:$A".

How do I export my sheet to PDF with the repeated rows using VBA?

You can use the ExportAsFixedFormat method. Add the line 'ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\YourPath\MyFile.pdf"' right after setting the PrintTitleRows property in your macro.

Will running an Online Repair delete my Excel files?

No, running an Online Repair from the Windows Control Panel only reinstalls and fixes the Microsoft Office application files. All your personal workbooks, documents, and data will remain safe and unaffected.