Close a New Window in Excel Without Closing the Workbook

How-to basics · Updated November 20, 2026

To close an extra window in Excel, activate that window and click its X in the upper-right corner, or press Ctrl+W on Windows. This closes the current window, not necessarily the workbook: if another window for the same workbook is open, that view stays available. Check which window is active before closing, especially if you have unsaved changes.

Excel’s New Window command creates another view of the workbook you already have open. It does not make a separate copy, so edits made in either view affect the same workbook. The steps below are for Excel for Microsoft 365 on Windows. Mac and web notes are included where the process differs.

What You’ll Need

  • Excel for Microsoft 365 on Windows, with the workbook and extra window open.
  • A moment to check the workbook name and save any changes you want to keep.
  • If you are unsure whether the extra window is a second view or a separate workbook, compare the names shown in the title bars before closing anything.

Step-by-Step

  1. Bring the extra window to the front. Click inside the window you want to close. If one window is covering another, use the taskbar preview or minimize the front window to reveal the one behind it. Closing a window is an action on the active window, so do not rely on which sheet or cell you last remember selecting.
  2. Check the title bar. Look at the workbook name at the top of Excel. When you use New Window, Excel may distinguish the views with labels such as Budget.xlsx:1 and Budget.xlsx:2; the exact display can vary. The shared workbook name is the key clue that the windows are views of one file. If the title shows a different workbook name, you may have opened a separate file instead.
  3. Confirm which view you intend to remove. If you opened a second view to compare worksheets, identify the one you no longer need. Closing either view does not delete a worksheet, erase the data, or remove the workbook from your computer. It simply removes that window from the screen.
  4. Save important edits before closing. Press Ctrl+S to save the workbook. With multiple views of the same workbook, changes made in one view belong to the shared workbook, not a separate copy. If there are unsaved changes, Excel may ask whether to save when you close. Choose Save to keep them, Don’t Save only if you intend to discard them, or Cancel if you want to return and check first.
  5. Close the active window. Click the X at the upper-right corner of the Excel window. Alternatively, press Ctrl+W. Both methods close the active workbook window. Avoid pressing Alt+F4 if your goal is only to remove one view; that shortcut is used to close the active application window and can have broader effects when you have several Excel windows open.
  6. Respond to any save prompt carefully. If Excel asks whether to save changes, read the workbook name in the prompt and choose the appropriate option. Selecting Cancel does not close the window; it takes you back to Excel. If you are uncertain whether an edit should be kept, cancel, inspect the workbook, and save a copy before deciding.
  7. Check that the other window is still open. If you created a second view using View > New Window, the remaining view should still show the workbook. You can continue working there, or close that window later when you are finished. If it was the only open view of the workbook, closing it will close the workbook window too.
  8. Use the right steps if you meant a new workbook. A blank workbook created with Ctrl+N is not another view of your existing file. Activate the blank workbook and close it with its X or Ctrl+W. The original workbook should remain open in its own window. Check the title bar so that you do not accidentally close the file you meant to keep.

On Mac: Activate the window and click its red close button, or press Command+W. If a save prompt appears, choose whether to save, discard, or cancel in the same way. In Excel for the web: the desktop New Window workflow is not generally available in the same way. Close the browser tab or browser window containing the workbook instead; that closes the browser view, not the workbook file itself. Check that changes have finished saving before you close the tab.

Common Mistakes

  • Closing the wrong window. If you have several workbooks open, the nearest X may belong to a different workbook than you intended. Click inside the target window and check its title bar first.
  • Assuming New Window made a copy. New Window creates another view of the same workbook. An edit in one view can appear in the other, and closing one view does not undo those edits.
  • Using the application close control by mistake. Closing an Excel window and quitting Excel are not always the same thing. Use the X for the specific window or Ctrl+W to close the active workbook window; avoid using a quit command if you only want to remove one view.
  • Choosing Don’t Save without checking. This can discard changes to the workbook. If you are not sure, choose Cancel, review the file, and save it before trying again.
  • Thinking a hidden window is closed. A window may be minimized, behind another window, or arranged off-screen. Closing a visible view is different from finding and restoring a hidden one.

Tips

  • Use New Window for comparison, then close only the view you no longer need. In desktop Excel, the command is on View > New Window. You can use View > Arrange All to arrange open workbook windows so they are easier to identify. When done comparing, activate the extra view and close it.
  • Keep one view open while you work. Two views can be useful for comparing different sheets, but they can also make it less obvious which window is active. Before typing or closing, check the title bar and selected worksheet tab.
  • Save before closing if the changes matter. Ctrl+S is a simple precaution, especially after editing multiple sheets. If AutoSave is available and turned on for a cloud-stored workbook, still check the save status before closing rather than assuming every change has finished syncing.
  • Use the keyboard shortcut when windows overlap. Click the target window once to activate it, then press Ctrl+W. On Mac, use Command+W. The shortcut avoids aiming at a small close button, but it still acts on the active window, so identifying that window remains important.
  • Remember that closing a view is not a way to undo work. If an unwanted edit was made, use Undo while the workbook is open or restore an appropriate saved version if available. Closing the extra view does not reverse changes made through it.

Troubleshooting

The wrong workbook closed. First look for another open Excel window using the taskbar on Windows or the app switcher on Mac. If the workbook is still open, activate it and continue. If it was the last window and Excel asked about saving, choose the option that matches your intent. If you discarded changes by mistake, check whether the file has version history or another backup available; recovery depends on where and how the workbook was saved.

The extra window is missing, but you think it is still open. On Windows, hover over or select the Excel icon on the taskbar to view open-window previews, then choose the right workbook window. You can also use View > Switch Windows if that command is available in your Excel ribbon. On Mac, use the Window menu to switch among open workbook windows. If a window appears to be off-screen after using another monitor, reconnect that display or move the window back onto the current screen using your operating system’s window controls.

Ctrl+W does not seem to close the view. Click inside the workbook first, then try again. If focus is in a cell-editing field, a dialog, or another part of Excel, the shortcut may not have the result you expect. You can also click the target window’s X. If a dialog is open, deal with or dismiss the dialog before attempting to close the window.

Excel asks whether to save, and you do not know what to choose. Choose Cancel to stop the close and return to the workbook. Review recent changes and press Ctrl+S if you want to keep them. Choose Don’t Save only when you are sure you want to discard the unsaved changes. The prompt may refer to changes made from either view because both views share the same workbook.

The close button is unavailable or the workbook will not close. A modal dialog may need your response first, or Excel may be waiting for a file operation to finish. Complete or cancel the dialog, wait for any saving or syncing to finish, and try again. If Excel is not responding, allow it time to recover before ending the task; forcing it to quit can lose unsaved work.

You are using Excel for the web. A browser tab is not the same as a desktop workbook window. Close the tab with the browser’s tab close button, and confirm the workbook’s save indicator is up to date first. To use the desktop New Window command, open the workbook in the Excel desktop app if your account and file permissions allow it.

Frequently Asked Questions

Does closing a new window in Excel delete the workbook?

No. Closing one window removes that view from the screen. If another window showing the same workbook is open, it remains open. Closing the last open view closes the workbook window, but it does not delete the saved file from your computer or cloud storage.

Will closing one view undo edits made in another?

No. New Window displays the same workbook in another view, not a separate copy. Changes made in either view belong to the same workbook. Save the file if you want to keep those changes; closing a view does not reverse them.

What is the shortcut to close a workbook window?

In Excel for Microsoft 365 on Windows, press Ctrl+W to close the active workbook window. On Mac, press Command+W. Make sure the window you want to close is active before using either shortcut.

How can I tell whether I opened a new window or a new workbook?

Check the title bars and the contents. A new view made with View > New Window shows the same workbook and usually has the same file name, sometimes with a view number. A workbook created with Ctrl+N is a separate, usually blank workbook with its own title.

Can I close an extra window without saving?

Yes. If Excel presents a save prompt, choose Don’t Save to discard unsaved changes, but do this only when you are certain. If you want to close the view while keeping edits, choose Save. Choose Cancel if you need to inspect the workbook before deciding.

Does closing the browser tab close an Excel for the web workbook?

It closes that browser view, not the workbook file itself. Check that the latest changes have saved before closing the tab. When you reopen the workbook, it should be available from its storage location, subject to your account access and connection.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.