
Tips.Net > ExcelTips Home > Workbooks > Closing All Open Workbooks
Summary: Excel provides a handy (but little-known) shortcut for closing all the workbooks you have open. This tip explains how easy it is to use this shortcut. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
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.
Tip #3065 applies to Microsoft Excel versions: 97 2000 2002 2003
Organize Your Data! Using the powerful sorting capabilities of Excel can help you get your data into just the order you need. Find out how you can use the full capabilities of sorting to your benefit.
Check out ExcelTips: Serioius Sorting today!
Want to make Excel do even more? The way is easy when you know how to use macros. This great e-book makes it easy. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site