One of the improvements in Excel 2013 is every excel file opens in a new window. This feature is handy to quickly compare the data in different workbooks. However the issue comes with closing the workbooks at once. In previous versions of excel you can use Alt+F4 to close multiple excel files at once. This shortcut will not work in Excel 2013. Each window has its close button and if you have multiple excel files open you need to close it individually which is tedious and also irritating. In this post we will see how to close multiple excel files at once with a single click.
We can do this in 2 ways.
Adding the close all option to QAT.
With a keyboard trick. 🙂
QAT stands for Quick Access tool bar. Follow the below steps, to add the close all option to QAT.
Go to More commands option in the QAT.
Select Commands not in the ribbon
From the list choose Close All and click on ADD and click ok. Now you can see the close all option added to the QAT. Just click on it to close all your Excel files at once
Alt key followed by the option number will be the shortcut for close all option in QAT.
Press the Shift key and click on close(X) button of any window. This opens up a Dialog box with an additional option of “Save All” (See the below image). Choose your option and all the files get closed instantly.
Hope you find this Excel Tip useful.
Don’t forget to share this post with your friends. Please share your opinions below in the comment box.