by Allen Wyatt
(last updated November 29, 2014)
You already know that you can close an open workbook using any number of methods. What if you have a bunch of open workbooks and you want to close them all, however? You can do this in one swift action by holding down the Shift key as you display the File menu. Notice that when you do, there is a Close All option on the menu. Choose this, and all your workbooks are closed. You will, of course, be prompted to save changes on each open workbook, if necessary.
Note that this only works if you hold down the Shift key when displaying the File menu. If you don't, then Close All does not appear.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3065) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
When you need to work on a workbook, you may want to do so without modifying the original contents of the workbook. This is ...Discover More
This tip presents two techniques you can use to print multiple workbooks all at the same time. Both techniques involve ...Discover More
All good things must come to an end at some point. When you are done sharing your workbook with others, this is how you can ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."