One of the new features in Excel 2013 is that each file opens in a separate window. Having each file in its own window makes it easier to compare files side-by-side, and most of the time I like the separate windows.
No Close All Files Command
One thing that I don’t like is that, unlike previous versions, there is no Exit button or command, to close all the files.
Each window has its own Close button, and if you’ve got lots of files open, it’s a pain to close each window individually.
Use the Taskbar Command
One solution is to use the Close All Windows command on the taskbar.
- Point to the Excel icon in the taskbar, and right-click on it
- In the popup menu, click Close All Windows
Add Commands to the QAT
Another option is to move the Close All and Exit commands to the Quick Access Toolbar (QAT).
- Click the Customize arrow at the end of the QAT.
- Click More Commands
- In the Choose Commands From drop down, select All Commands
- In the list of commands, select Close All
- Click Add, to move the command to the QAT
- Then, select the Exit command, and add it to the QAT
- Click Close, to return to the Excel window.
Now you can click Close All, to close all the files, but leave Excel open. Or, click Exit, to close all the files, and close Excel.
I’ve added this Close All Excel Files tip to the Excel FAQ pages on my Contextures website.
Watch the Video
YOu can watch this short video, to see the steps for closing all the open files in Excel 2013.
________________
Debra – I use ALT + F4 to close all the files at once. It prompts me to save – including an option to save all – if I haven’t saved one or all of the files.
OK. I just realized you were talking about Excel 2013, not Excel 2010. Please accept my apology and feel free to delete both of my comments.
No problem Bob! The ALT + F4 shortcut is a good tip for previous versions of Excel, which most people are still using.
I always enjoy your tips Debra, but this reminds me of how much I loathe SDI. I really do wish Microsoft would leave the SDI “feature” as an option. I might be a curmudgeon, but I am also a power user who’s easily distracted and it’s not uncommon for me to have a dozen applications open at once (once of which is always Excel, and that will likely have half a dozen documents open). For me, SDI just adds to taskbar clutter and makes it more difficult to Alt-Tab to the bit of work I am interested in.
Thank you so much Debra, I really appreciate your tips. Have a good day!
Thanks very helpful to know!
This brings up a related question.
Why is it when I open up an Excel (or any msoffice) file, it opens a virtual copy? Let me explain…
If I open up two Excel files (let’s call them A and B), and I am a power user and I Alt-Tab to cycle through my choices of open windows, Why is it that I have three or even four Excel windows to choose from? At least one of the files will have a duplicate one to choose from and this drives me crazy. I just want to Alt-Tab between my A and B spreadsheets but I wind up landing on A from A, instead of B from A. This has bugged me for years.
Hello! If you see NameOfDoc.xlsx:2 and NameOfDoc.xlsx:1, for example, you probably saved the workbook at one point while you were using a New Window. Just close one of the copies, and it should not prompt you to save anything, because the actual source is still open. However, you do want to resave the document once the workbook only has one instance open. That should prevent the doc from opening in two windows.
If I understood your question correction, another thing that could be going on is that you are pressing the TAB key for longer than necessary. IF you hold down the Alt key,and then just click tab, you’ll notice that the toggle can go through every open window when you use Alt with Tab. Instead, Ctrl F6 only toggles between documents of the same type.So use Ctrl F6 to move forward one document, and then SHIFT CTRL f6 to go backwards in the cycle. That way you only use 2 of the four documents.
LH
Hi, everybody
The simplest way, I’ve discovered today (the 2nd day when company deployed office 2013), is to hold Shift key and click the cross sign on top right corner (close window). The behavior to be the same as Alt+F4 on previous versions of excel. Even more there comes the fourth choice in appeared the window: Save all.
@Rostyslav, great tip, thanks!