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.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Use a workbook for some time and you may find that it gets progressively slower to open and save. Here are some ...Discover More
Don't you hate opening a workbook and seeing error messages? If you see a message that some "invalid names" were detected ...Discover More
Tired of your workbooks being left open on the screen where they can be seen by anyone passing by? Here's a way to have ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.