Close all files without exiting Excel

  • Thread starter Thread starter jco
  • Start date Start date
J

jco

In Windows 2007, how do you close all the Excel spreadsheets at once, without
closing Excel? I'm looking for the equivalent of "Close All" that was under
File when you held the Shift key down in the previous version of Windows.
 
Assuming you are using Office 2007 then you can customize the QAT or the
Quick Access Toolbar, under Office button top left, then excel options
customize and all commands, they are in alphabetical order so just find one
called Close All and add it to the QAT

--


Regards,


Peo Sjoblom
 
Found it! Thanks.

Peo Sjoblom said:
Assuming you are using Office 2007 then you can customize the QAT or the
Quick Access Toolbar, under Office button top left, then excel options
customize and all commands, they are in alphabetical order so just find one
called Close All and add it to the QAT

--


Regards,


Peo Sjoblom





.
Click to expand...
 
Back
Top