How to Fix Freeze Panes Disappearing in Excel New Windows
Question details
The user needs to keep Freeze Panes active when viewing the same Excel workbook in multiple windows, but the setting disappears when opening a new window.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Viewing and editing a large dataset in the same workbook across multiple windows simultaneously.
- Observed behavior
- When using View > New Window to open another view of the same workbook, Excel drops or fails to consistently preserve the Freeze Panes setting between the windows.
Make sure your current workbook is saved before you begin. Remember not to duplicate your file to open it twice, as simultaneous edits on separate copies will result in lost changes.
Open a Separate Instance of Excel
Force Excel to launch a completely independent instance, allowing each window to maintain its own independent UI settings like Freeze Panes.
Using the standard 'View > New Window' option inside a single Excel process shares certain interface states, which causes Freeze Panes to reset. Bypassing this by forcing a completely new Excel application process solves the problem securely without risking version conflicts.
Press the Windows key on your keyboard and search for Excel in the programs list.
Press and hold the Alt key on your keyboard before you click the application.
While continuing to hold the Alt key, click on the Excel icon to launch it.
Keep holding the Alt key until a prompt appears asking 'Do you want to start a new instance of Excel?'. Click Yes.
In this newly opened, independent instance, go to File > Open and select your workbook. You can now apply Freeze Panes securely.
Switch to WPS Office for a Better Spreadsheet Experience
If you find Microsoft Excel's window management and disappearing Freeze Panes frustrating, try WPS Office. It is a free, lightweight alternative that handles multiple workbooks and complex data views seamlessly without dropping your preferred layout settings.
- 1. Download WPS Office: Install WPS Office Free on your device.
- 2. Open Your Spreadsheets: Open WPS Spreadsheet and seamlessly load your existing Microsoft Excel (.xlsx) files.
- 3. Apply Freeze Panes: Navigate to the View tab and select Freeze Panes to lock your important rows and columns effortlessly.
Frequently Asked Questions
Why does the View > New Window option remove my Freeze Panes in Excel?
When you use 'View > New Window', Excel opens a secondary view of the exact same workbook within the same application process. Due to how Excel synchronizes these views, window-specific UI configurations like Freeze Panes are often reset or cannot be independently maintained.
Can I simply make a copy of the workbook to open simultaneously?
You should avoid manually creating a copy of the workbook to open alongside the original. Doing so means you are working on two completely independent files; any changes saved in one copy will conflict with or overwrite changes in the other.
How do I know if I successfully opened a new Excel instance?
If you hold the Alt key while launching Excel correctly, a system dialog box will explicitly ask, 'Do you want to start a new instance of Excel?' Clicking 'Yes' confirms that a separate application process has been created.
Do I need to hold Alt every time I want a new instance?
Yes. If Excel is already running, clicking the Excel shortcut normally will simply bring up the existing instance. You must hold the Alt key to force the system to spawn a completely independent Excel process.
