Close all files without exiting Excel

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

David Biddulph

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?
 
P

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
 
J

jco

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





.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top