Fix Excel Freeze Panes Not Carrying Over to New Windows
Question details
The user needs Freeze Panes settings to remain active when opening an existing workbook in a new window for side-by-side viewing.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening a new window of the same workbook to view multiple sheets side by side.
- Observed behavior
- Freeze Panes settings remain in the original window but disappear in the newly opened window, forcing the user to reapply them manually.
Identify the specific rows and columns you need to keep visible before opening a new window, so you can quickly reapply the settings.
Manually Reapply Freeze Panes in the New Window
Because this behavior is a known limitation in Microsoft Excel, the most direct workaround is to manually set the freeze panes again in any secondary window.
Microsoft has confirmed that window-specific settings like Freeze Panes do not carry over when utilizing the 'New Window' feature. To view sheets side by side with locked headers, you must duplicate the view setup manually.
Go to the 'View' tab on the Excel ribbon and click on 'New Window' to open a second instance of your current workbook.
In the newly opened window, click on the worksheet tab you wish to view.
Click on the cell immediately below the row and to the right of the column you want to remain frozen.
Go to the 'View' tab, click on 'Freeze Panes', and select 'Freeze Panes' from the drop-down menu to lock your headers in place.
Use Custom Views to Quickly Restore Layouts
Create a Custom View to save your preferred freeze pane layouts so they can be quickly reapplied without selecting cells manually each time.
Experience Seamless Spreadsheet Viewing with WPS Office
If Excel's window limitations are slowing down your workflow, consider switching to WPS Office. It provides an intuitive tabbed interface, highly compatible spreadsheet management, and a lightweight, free alternative to Microsoft Office for your complex data tasks.
- 1. Download the Installer: Visit the official WPS Office website to download the free installation package.
- 2. Install and Open: Follow the straightforward installation prompts, then open your existing .xlsx workbooks directly in WPS Spreadsheets.
- 3. Manage Windows Effectively: Navigate to the View tab to easily utilize robust split-window and freeze-pane features.
Frequently Asked Questions
Why do my Freeze Panes disappear when I click 'New Window' in Excel?
This is a known limitation in current versions of Microsoft Excel. When a worksheet is opened in a new window for side-by-side viewing, window-specific display settings like Freeze Panes do not automatically copy over and must be reapplied manually.
Will Microsoft update Excel to fix this Freeze Panes issue?
Microsoft support has acknowledged the limitation. Users are encouraged to submit feedback or vote on existing user requests within the Excel application (Help > Feedback) to notify the product team of the demand for this feature.
Can I save my Freeze Panes layout so I don't have to reapply it?
Yes, you can use the 'Custom Views' feature under the View tab to save your layout. However, keep in mind that the Custom Views feature is automatically disabled if your workbook contains any formatted Excel Tables.
How do I view two sheets from the same workbook side by side?
Go to the View tab and click 'New Window'. Then, click 'View Side by Side' located in the same View tab. You can navigate to different sheets in each window, though you will need to reapply Freeze Panes in the second window.
