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.
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 tip to the Excel FAQ pages on my Contextures website.
Watch the Video
Watch this short video, to see the steps for closing all the open files in Excel 2013.