Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook Tabs?
Wondering if there is anything in the works for Workbook Tabs similar to
IE7.0 Tabs feature, so I don't have to continually minimize and maximize the various workbooks I have open at once. Anything like that currently available or planned? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook Tabs?
If you open your workbooks in a single instance of Excel, then its just:
Window click to select -- Gary''s Student - gsnu200759 "swam.utty" wrote: Wondering if there is anything in the works for Workbook Tabs similar to IE7.0 Tabs feature, so I don't have to continually minimize and maximize the various workbooks I have open at once. Anything like that currently available or planned? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook Tabs?
swam. utty,
(I'm assuming you are using a Windows machine) An easy keyboard shortcut to swtich between workbooks, [Ctrl] + [Tab] will cycle through all open workbooks in order (If you have 5 open, each press will cycle through them from the 1st one to the 5th one and then go back to the 1st one). If you want a keyboard shortcut to toggle between 2 of the 5 open, then you can select the 1st one you want, then the second one, then use [Alt] + [Tab] to toggle between the 2 ("Group similar taskbar buttons" needs to be turned off--Right-click taskbarpropertiesGroup similar taskbar buttons (Win XP)). [Alt] + [Tab] is Windows KB shortcut to switch among programs. Windows knows the order you've used all of your open programs (If "Group similar..." is turned off, Windows will treat each open workbook kinda like a separte program). Hold down [Alt] and press [Tab] once, then release [Alt], Win will switch from the current program to your last used program. Hold [Alt], press [Tab] twice, release [Alt], Win will switch from current to the 2nd-to-last used program. Etc, etc, etc... HTH, Conan "swam.utty" wrote in message ... Wondering if there is anything in the works for Workbook Tabs similar to IE7.0 Tabs feature, so I don't have to continually minimize and maximize the various workbooks I have open at once. Anything like that currently available or planned? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook Tabs?
Gary and Conan, thanks. I guess that works, but the point of Tabs is that
you can see the multiple sheets you have open without having to cycle through them all. I happen to have a shoirt memory, and I leave the sheet open for long periods and am frquently closing one of the, say, 10 and opening another, so the list changes. Tabs would really be the best Tabs option and works great with web pages. Was hoping it would work here too. I suggest it as a future "option". Till then I'll probably use either of your recommendations. Thanks again! "Conan Kelly" wrote: swam. utty, (I'm assuming you are using a Windows machine) An easy keyboard shortcut to swtich between workbooks, [Ctrl] + [Tab] will cycle through all open workbooks in order (If you have 5 open, each press will cycle through them from the 1st one to the 5th one and then go back to the 1st one). If you want a keyboard shortcut to toggle between 2 of the 5 open, then you can select the 1st one you want, then the second one, then use [Alt] + [Tab] to toggle between the 2 ("Group similar taskbar buttons" needs to be turned off--Right-click taskbarpropertiesGroup similar taskbar buttons (Win XP)). [Alt] + [Tab] is Windows KB shortcut to switch among programs. Windows knows the order you've used all of your open programs (If "Group similar..." is turned off, Windows will treat each open workbook kinda like a separte program). Hold down [Alt] and press [Tab] once, then release [Alt], Win will switch from the current program to your last used program. Hold [Alt], press [Tab] twice, release [Alt], Win will switch from current to the 2nd-to-last used program. Etc, etc, etc... HTH, Conan "swam.utty" wrote in message ... Wondering if there is anything in the works for Workbook Tabs similar to IE7.0 Tabs feature, so I don't have to continually minimize and maximize the various workbooks I have open at once. Anything like that currently available or planned? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook Tabs?
I have a COM Add-In that will display a command bar with the open workbooks
listed. Not quite a tabbed solution, but you might find it useful. You can use it as a floating command bar or dock it on any edge of the Excel window. See www.cpearson.com/Excel/WorkbookCommandBar.aspx -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "swam.utty" wrote in message ... Gary and Conan, thanks. I guess that works, but the point of Tabs is that you can see the multiple sheets you have open without having to cycle through them all. I happen to have a shoirt memory, and I leave the sheet open for long periods and am frquently closing one of the, say, 10 and opening another, so the list changes. Tabs would really be the best Tabs option and works great with web pages. Was hoping it would work here too. I suggest it as a future "option". Till then I'll probably use either of your recommendations. Thanks again! "Conan Kelly" wrote: swam. utty, (I'm assuming you are using a Windows machine) An easy keyboard shortcut to swtich between workbooks, [Ctrl] + [Tab] will cycle through all open workbooks in order (If you have 5 open, each press will cycle through them from the 1st one to the 5th one and then go back to the 1st one). If you want a keyboard shortcut to toggle between 2 of the 5 open, then you can select the 1st one you want, then the second one, then use [Alt] + [Tab] to toggle between the 2 ("Group similar taskbar buttons" needs to be turned off--Right-click taskbarpropertiesGroup similar taskbar buttons (Win XP)). [Alt] + [Tab] is Windows KB shortcut to switch among programs. Windows knows the order you've used all of your open programs (If "Group similar..." is turned off, Windows will treat each open workbook kinda like a separte program). Hold down [Alt] and press [Tab] once, then release [Alt], Win will switch from the current program to your last used program. Hold [Alt], press [Tab] twice, release [Alt], Win will switch from current to the 2nd-to-last used program. Etc, etc, etc... HTH, Conan "swam.utty" wrote in message ... Wondering if there is anything in the works for Workbook Tabs similar to IE7.0 Tabs feature, so I don't have to continually minimize and maximize the various workbooks I have open at once. Anything like that currently available or planned? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My worksheet tabs can not be seen in my workbook. | Excel Discussion (Misc queries) | |||
Workbook tabs | Excel Discussion (Misc queries) | |||
Is it possible to sort the tabs in a workbook? | Excel Discussion (Misc queries) | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Workbook Tabs | Excel Discussion (Misc queries) |