Hints and tips home » Excel hints and tips » Closing Multiple Open Worksheets At Once

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

Added by Orok on 27th September 2006

More Excel hints and tips, like:

• Shortcut keys to move between sheets
• Use the Format Painter to copy formatting more than once in Excel
• Hiding and unhiding rows using the keyboard