Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 30th 10, 07:00 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 161
Default Close all oben workbooks at once in Excel 2007

Hi, in Excel 2003 I am able to close all open workbooks at once. Click on x
button on one of workbooks while holding shift key does it. I remember
somebody posted how to do the same in Excel 2007, but forgot the trick. It
has something to do with general setup of Excel. Any idea? Thanks in advance.
Alojz

  #2   Report Post  
Old January 30th 10, 07:21 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 833
Default Close all oben workbooks at once in Excel 2007

If you type:-

close all workbooks

- into the F 1 Help Facility you will see all of the options that are
available.

Please hit Yes if my comments have helped.

"Alojz" wrote:

Hi, in Excel 2003 I am able to close all open workbooks at once. Click on x
button on one of workbooks while holding shift key does it. I remember
somebody posted how to do the same in Excel 2007, but forgot the trick. It
has something to do with general setup of Excel. Any idea? Thanks in advance.
Alojz

  #3   Report Post  
Old January 31st 10, 09:38 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 161
Default Close all oben workbooks at once in Excel 2007

Hi, I did not find what I wanted in F1 help instructions. I know I can add
icon for closing all open workbooks to the ribbon with my favorites.
However, I would prefer to do it as simply as just clicking on x while
holding shift key and I know it works somehow, when I set up Excel in proper
way. But forgot how to set up Excel. In F1 help file I did not find such
instructions. Also, in Excel 2003 it was possible to use several others icons
in combination with shift key. Shift key in this case works as switch. For
instance, if I click on insert row icon while holding shift key, it actually
removes the row. I like this feature and would like to use the same feature
in Excel 2007. Then, I can save space in my favorite icons riboon for other
icons, I do not need to place twin icons in there, just place one of the
couple and via shift key to call the opposite action.

"trip_to_tokyo" wrote:

If you type:-

close all workbooks

- into the F 1 Help Facility you will see all of the options that are
available.

Please hit Yes if my comments have helped.

"Alojz" wrote:

Hi, in Excel 2003 I am able to close all open workbooks at once. Click on x
button on one of workbooks while holding shift key does it. I remember
somebody posted how to do the same in Excel 2007, but forgot the trick. It
has something to do with general setup of Excel. Any idea? Thanks in advance.
Alojz



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
How to close all open workbooks in Excel 2007 Alojz Setting up and Configuration of Excel 0 September 17th 09 11:04 PM
Close all workbooks and keep excel running Scott Hutslar Excel Discussion (Misc queries) 5 June 25th 08 11:16 PM
why do all excel worksheets/workbooks close when I close one? Penny Excel Discussion (Misc queries) 1 November 29th 06 03:49 AM
close workbooks without closing excel ? Clute Excel Discussion (Misc queries) 2 August 5th 06 09:50 PM
Why does Excel close all workbooks? JVernon Setting up and Configuration of Excel 1 July 5th 05 10:38 PM


All times are GMT +1. The time now is 01:23 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017