Close all files without exiting Excel

[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.

 

[Peo Sjoblom]

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

 

[jco]

Found it! Thanks.

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





.