Office Settings & Configuration

Stop Excel from Opening Two Windows for the Same Workbook

Emma BrownEmma Brown Nov 18, 2026 869 views

Question details

The user wants Excel to open a workbook in one window instead of two.

Stop Excel from Opening Two Windows for the Same Workbook
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.
Before you start

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.

Solution 1Recommended

Close the Extra Excel Window and Save the Workbook

Use this method when Excel shows multiple numbered windows for the same workbook.

1
Select the extra window

Click the workbook window you do not need, such as the one labeled with -2 in its title bar.

2
Close only that window

Click that window's close button (X), rather than quitting Excel or choosing File > Close. The other workbook window should remain open.

3
Save the remaining view

In the remaining workbook window, click Save or choose File > Save to save the workbook without the extra view.

4
Check the result

Close and reopen the workbook from File > Open to check that it now opens in one window.

Close the Extra Excel Window and Save the Workbook
If two windows still appear: Remove the extra window again and save the workbook from the remaining window. The workbook may have retained its previous window state.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel XLS and XLSX formatsUse a free, lightweight Office alternativeContinue working with existing Excel files in WPS Spreadsheet
microsoft office alternative - wps office

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.