Fix Excel Page Setup Unresponsive When Setting Rows to Repeat
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.

- 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.
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.
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.
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'.
Reopen your Excel workbook, navigate to the Page Layout tab, and click 'Print Titles' to see if the Page Setup dialog is now responsive.
If the problem continues, open the Windows Start menu, type 'Control Panel', and press Enter. Navigate to 'Programs' > 'Programs and Features'.
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.

Use a VBA Macro to Set Rows to Repeat
If the graphical interface remains unresponsive, you can bypass the Page Setup dialog entirely by using a simple VBA script to define your print titles.
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.

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.




