How to Restore Missing Frozen Panes in a New Excel Window
Question details
The user needs to restore frozen panes that disappear when opening an existing workbook in a new window.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening a single workbook in a new window to view multiple sheets or sections simultaneously.
- Observed behavior
- The frozen panes remain active in the original window but are completely missing in the newly opened window.
Verify whether the issue occurs in all Excel files or just a specific workbook, and ensure your spreadsheet contains enough data rows to clearly observe the freeze panes effect.
Manually Reapply the Freeze Panes Setting
Since this is a known Excel behavior where a new instance drops the specific UI view settings, you must manually reapply the freeze panes in the newly opened window.
When you open an Excel workbook in a new window (via View > New Window), Excel creates a secondary view instance. Unfortunately, certain view-specific settings like Frozen Panes do not reliably carry over from the primary window. Reapplying the setting is the quickest workaround.
Click anywhere inside the newly opened Excel window to make it the active workbook.
Look at the top ribbon menu and click on the 'View' tab.
Click on 'Freeze Panes', then choose your preferred freeze option (e.g., Freeze Top Row, Freeze First Column, or Freeze Panes based on your current cell selection).
Report the Behavior to Microsoft
If this recurrent bug interrupts your workflow, report it directly to Microsoft to encourage a permanent fix in future updates.
Experience Flawless Spreadsheet Viewing with WPS Office
Tired of unpredictable display bugs in Microsoft Excel? WPS Office provides a free, lightweight, and highly compatible alternative that ensures your view settings work seamlessly across all tabs and windows.
- 1. Open your spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx or .xls file.
- 2. Access the View tab: Navigate to the 'View' tab on the main ribbon menu.
- 3. Lock your panes securely: Click 'Freeze Panes' to confidently lock your rows and columns without worrying about display bugs.
Frequently Asked Questions
Why do frozen panes disappear when I open a new window in Excel?
This is a known limitation and display bug in Microsoft Excel. When duplicating a view into a new window, Excel often resets the specific window display properties, dropping the frozen panes setting while retaining the data.
Can I apply freeze panes to all worksheets at once?
No, the freeze panes feature applies only to the active worksheet. You must navigate to each sheet individually and set the freeze panes via the View tab.
How do I remove frozen panes from my Excel workbook?
To unfreeze panes, navigate to the View tab, click on the Freeze Panes drop-down button, and select 'Unfreeze Panes'. This will restore normal scrolling for the entire worksheet.
Will saving the workbook fix the missing frozen panes in the new window?
Unfortunately, no. Saving only retains the view state of the primary window. If you close and reopen the file, you will need to open a new window and manually reapply the freeze panes again.
