Excel: Close All Open Workbooks

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: I have 22 Excel Workbooks open. I want to keep Excel open but close all the workbooks. Excel no longer has a Close All icon on the ribbon, and selecting File, Close 22 times can get monotonous.

Strategy: You can add a Close All button to your Quick Access toolbar. Follow these steps:

  1. Right-click the Quick Access toolbar and choose Customize Quick Access Toolbar.
  2. In the left dropdown, choose Commands Not in the Ribbon.
  3. Find the Close All item in the left list. Select Close All. Click the Add button to add the icon to the Quick Access toolbar. Click OK to close the Excel Options dialog.

Results: The Close All icon will be available on the Quick Access toolbar. When you click this icon, Excel will still individually ask you about any unsaved documents. However, it is a faster way of closing all open workbooks than manually closing each one.

  1. Close All, but keep Excel open.

    Gotcha: The Close and Close All icons look the same in the Quick Access toolbar. If you want to have both Close and Close All, add them to the Excel ribbon so that the label will appear for each icon.

    Additional Details: If your workbooks are unsaved, Excel will ask you if you want to save each one. Here is a cool trick: hold down the shift key while clicking Don't Save. Excel will repeat that answer for all of the remaining workbooks.

  2. Shift while clicking to apply the answer to all workbooks.