Stop Excel from Opening Two Windows for the Same Workbook
Question details
The user wants Excel to open a workbook in one window instead of two.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook opens with multiple windows after an additional window or view was created.
- Observed behavior
- Two windows display the same workbook name with different numbers, such as -1 and -2.
Check the title bars to confirm that both windows show the same workbook name with different numbers. Identify which window you want to keep open.
Close the Extra Excel Window and Save the Workbook
Use this method when Excel shows multiple numbered windows for the same workbook.
Click the workbook window you do not need, such as the one labeled with -2 in its title bar.
Click that window's close button (X), rather than quitting Excel or choosing File > Close. The other workbook window should remain open.
In the remaining workbook window, click Save or choose File > Save to save the workbook without the extra view.
Close and reopen the workbook from File > Open to check that it now opens in one window.

Work with Excel Files in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet for an easy transition, though it does not change Excel's saved window settings.

Frequently Asked Questions
Why does my Excel workbook name have a number after it?
A number such as -1 or -2 can indicate that Excel has multiple windows open for the same workbook. Check both title bars to see whether they show the same file name.
Will closing the extra window close the workbook?
Clicking the extra window's own close button should close that window while leaving the other workbook window open. Avoid quitting Excel or choosing File > Close for this step.
Why do both windows return when I reopen the workbook?
The workbook may have been saved with multiple windows. Close the extra window using its close button, then use File > Save in the remaining window before reopening the workbook.
Does WPS Office fix Excel's duplicate window setting?
No. Remove the extra window and save the workbook in Excel. WPS Spreadsheet is an alternative for opening and editing compatible Excel files.




