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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|