98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

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:

• Quickly copy a formula across sheets
• Deleting cells, Rows & columns
• Autofit column width – Excel (all versions)