Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
jco jco is offline
external usenet poster
 
Posts: 11
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 136
Default 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.



  #4   Report Post  
Posted to microsoft.public.excel.misc
jco jco is offline
external usenet poster
 
Posts: 11
Default 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.



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why excel close all files when I just want to close one files hon123456 Excel Discussion (Misc queries) 2 December 8th 10 12:12 PM
exiting excel ONLY the workbook will close Brandon Excel Discussion (Misc queries) 12 May 27th 10 09:59 PM
why do all excel files close when one closes? janet inglis Excel Discussion (Misc queries) 7 February 5th 09 12:38 PM
how can I close a worksheet without exiting the wookbook Grumpy Ump 1 Excel Discussion (Misc queries) 2 September 21st 07 11:15 PM
Excel 2002: Can I save all files in one go without exiting ? Mr. Low Excel Discussion (Misc queries) 0 July 6th 07 04:26 PM


All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"