Tuesday, December 21, 2004

Close all files in Excel

There is a little known shortcut to a menu item that only appears when you use the shortcut.
Next time you have multiple workbooks open try this.
Hold down the SHIFT key and then click on File. You will see that the menu option Close has gone and in its place Close All appears.
Use this to close down all open workbooks.