A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Close all oben workbooks at once in Excel 2007



 
 
Thread Tools Display Modes
  #1  
Old January 30th, 2010, 08:00 PM posted to microsoft.public.excel.setup
Alojz
external usenet poster
 
Posts: 156
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  
Old January 30th, 2010, 08:21 PM posted to microsoft.public.excel.setup
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
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  
Old January 31st, 2010, 10:38 AM posted to microsoft.public.excel.setup
Alojz
external usenet poster
 
Posts: 156
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:57 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.