You can download the Excel file that contains the macros here. The macros give us a lot more flexibility when we want to control which workbooks are saved before closing. In this section I will share a few macros that can be used to close all open workbooks. Tip #3: Close All Open Workbooks with a Macro I mentioned this tip in my post on 17 Excel shortcuts for 2017. To add the Close All button to the QAT, open the Excel Options window (File>Options) and follow the steps on the image below.Īfter pressing the Close All button we will be prompted with the same window as described in tip #1.īonus Tip: We can also use the keyboard shortcut Ctrl+W to close a single workbook. The QAT buttons can be accessed with a keyboard shortcut by pressing the Alt Key and the number assigned to the button. The advantage here is that we can use a keyboard shortcut to press the button.

This does the same thing as the Shift+Close Window shortcut. We can also add the Close All button to the Quick Access Toolbar (QAT) to close all open workbooks. Tip #2: Add the Close All Button to the Quick Access Toolbar You can press this to Save All the unsaved workbooks in one step.Ĭlicking the Cancel button will cancel the entire operation and the wordbooks that are still open will remain open.īut what if we don't want to save all or some of the open workbooks? We'll get to that in tip #3. The window also contains a Save All button. The pop-up window will appear and you will have to press Save or Don't Save for each unsaved workbook. If any of the open workbooks have NOT been saved, then you will be prompted to save the file. If all of the open workbooks have been saved, then they will all be closed.

The Close Window button is the “x” in the top-right corner of the application window. The quickest way to close all open workbooks is to hold the Shift key while pressing the Close Window button. And at the end of the day, we just want to close all open workbooks and go home! So this post contains a few tips for quickly closing all open files to help beat rush hour traffic. I try to stay disciplined with this, but sometimes it's hard. If you use Excel all day every day like I do, then it can be easy to have a lot of workbooks open at the same time. Bottom line: Learn a few shortcuts and tips to save and close all open Excel workbooks.

Shortcut to close all windows at once