Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Switching between workbooks
I am using XP Pro and Excel 2000.
I always have five or six workbooks open at any time, along with Outlook, Word, Explorer, etc. In the past, I have been able to troggle between programs by using Alt + Tab. When I did that, each open Excel workbook would show up as a separate item, making it easy to toggle to the exact workbook I needed. Now something has changed. Alt + Tab still allows me to toggle, but I only have one icon for Excel. I have to go to Excel, then use Ctrl + Tab to rotate workbooks. I suspect I have accidentally changed a setting in either XP or Excel, but I don't know what it would be. Thanks for any help available. -- Jim |
#2
|
|||
|
|||
Hi
Have a look at Tools|Options|View|Windows In Taskbar and make sure it's checked!! -- Andy. "Jim" wrote in message ... I am using XP Pro and Excel 2000. I always have five or six workbooks open at any time, along with Outlook, Word, Explorer, etc. In the past, I have been able to troggle between programs by using Alt + Tab. When I did that, each open Excel workbook would show up as a separate item, making it easy to toggle to the exact workbook I needed. Now something has changed. Alt + Tab still allows me to toggle, but I only have one icon for Excel. I have to go to Excel, then use Ctrl + Tab to rotate workbooks. I suspect I have accidentally changed a setting in either XP or Excel, but I don't know what it would be. Thanks for any help available. -- Jim |
#3
|
|||
|
|||
Tools/Options/View tab - check "Windows in Taskbar"
Bob Umlas Excel MVP "Jim" wrote in message ... I am using XP Pro and Excel 2000. I always have five or six workbooks open at any time, along with Outlook, Word, Explorer, etc. In the past, I have been able to troggle between programs by using Alt + Tab. When I did that, each open Excel workbook would show up as a separate item, making it easy to toggle to the exact workbook I needed. Now something has changed. Alt + Tab still allows me to toggle, but I only have one icon for Excel. I have to go to Excel, then use Ctrl + Tab to rotate workbooks. I suspect I have accidentally changed a setting in either XP or Excel, but I don't know what it would be. Thanks for any help available. -- Jim |
#4
|
|||
|
|||
Jim, since you use the Alt + Tab shortcut, you can also use Ctrl + Tab and it
will flip between everything in the open program. For example, if you are in Excel and have 5 files open, and you also have 3 Word files open, the Ctrl + Tab combination will only flip between the files that match the program you have open, so it would only flip between the 5 Excel files. It does not, however, display which file it is switching to, it just flips to the next one in line. I use it sometimes. Kate "Jim" wrote: I am using XP Pro and Excel 2000. I always have five or six workbooks open at any time, along with Outlook, Word, Explorer, etc. In the past, I have been able to troggle between programs by using Alt + Tab. When I did that, each open Excel workbook would show up as a separate item, making it easy to toggle to the exact workbook I needed. Now something has changed. Alt + Tab still allows me to toggle, but I only have one icon for Excel. I have to go to Excel, then use Ctrl + Tab to rotate workbooks. I suspect I have accidentally changed a setting in either XP or Excel, but I don't know what it would be. Thanks for any help available. -- Jim |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Switching between workbooks
That ctrl+tab hint helped but why will my alt+tab between exel files not
work. Is this a new characteristic of XP because it is sure inconvenient? "Katydid" wrote: Jim, since you use the Alt + Tab shortcut, you can also use Ctrl + Tab and it will flip between everything in the open program. For example, if you are in Excel and have 5 files open, and you also have 3 Word files open, the Ctrl + Tab combination will only flip between the files that match the program you have open, so it would only flip between the 5 Excel files. It does not, however, display which file it is switching to, it just flips to the next one in line. I use it sometimes. Kate "Jim" wrote: I am using XP Pro and Excel 2000. I always have five or six workbooks open at any time, along with Outlook, Word, Explorer, etc. In the past, I have been able to troggle between programs by using Alt + Tab. When I did that, each open Excel workbook would show up as a separate item, making it easy to toggle to the exact workbook I needed. Now something has changed. Alt + Tab still allows me to toggle, but I only have one icon for Excel. I have to go to Excel, then use Ctrl + Tab to rotate workbooks. I suspect I have accidentally changed a setting in either XP or Excel, but I don't know what it would be. Thanks for any help available. -- Jim |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Switching between workbooks
Fri, 27 Jul 2007 15:18:03 -0700 from rick
: That ctrl+tab hint helped but why will my alt+tab between exel files not work. Is this a new characteristic of XP because it is sure inconvenient? Tools | Option | View | Show | Windows in Taskbar But you can go between workbooks with Ctrl-F6 anyway. -- "The internet is famously powered by the twin engines of bitterness and contempt." -- Nathan Rabin, /The Onion/ Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate different sheets to different workbooks | Excel Worksheet Functions | |||
linking to multiple workbooks | Excel Discussion (Misc queries) | |||
Linking Workbooks | Excel Worksheet Functions | |||
Automatic updating worksheet data between different workbooks | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |