Close all files without exiting Excel
 

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.

Close all files without exiting Excel
 

Are you sure that there is a Windows 2007?
Do you mean Excel 2007?
Do you mean Windows 7?

Which version of Excel are you running, and which version of Windows?
--
David Biddulph

"jco" wrote in message
...
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.

Close all files without exiting Excel
 

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" wrote in message
...
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.

Close all files without exiting Excel
 

Found it! Thanks.

"Peo Sjoblom" wrote:

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" wrote in message
...
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.


.