asked on
Alt Tab between applications
I can normally switch between all my open windows by using Alt Tab keys. So, if I have three Excel files open, it will allow me to switch between them all, together with all the other open windows (Outlook, folders, etc)
My colleaugue has a situation where this changes at times to an ability to only switch between applications and not betwen open windows within an applications. So, for example, if he has three Excel files open, as well as Outlook and a couple of folders, pressing Alt Tab will enable him to switch only between Excel, Outlook and folders, and not between the three Excel files.
How can he change this to the way I have it set up?
My colleaugue has a situation where this changes at times to an ability to only switch between applications and not betwen open windows within an applications. So, for example, if he has three Excel files open, as well as Outlook and a couple of folders, pressing Alt Tab will enable him to switch only between Excel, Outlook and folders, and not between the three Excel files.
How can he change this to the way I have it set up?
Windows XP
Last Comment
SheharyaarSaahil
ASKER
This is something our IS dept would have to do and they are extremely slow. This changes on him - one day it does it and then another it does not. Or it switches on him within the same day. Is there some lpace he can control it in the Control Panel?
Are these Excel files in a new window by itself or are they sharing the same taskbar window? I know Excel 97 does this where they put all the files in the single Excel program.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I think they are sharing the same taskbar window when maximized. He has only one Excel open. He also arranges them and then uses the mouse to move between them but he would much rather use Alt Tab.
He is using Excel '03.
He is using Excel '03.
yeah that's apoint to consider.... happens with ONLY different Excel sheets or word documents, ie windows, notepad txt files also behave in the same manner ??
ASKER
We tested it with Word and a couple of Outlook messages. It switches between those, but not in Excel. So it works well with those other applications, but not with Excel.
then kmorris's suggestion seems to be right on target.... have you tried it? :)
ASKER
We opened two sessions of Excel and now it does it. We would like it to work with just one Excel session so we can have the windows arranged side by side.
That might not work then. At least not that I know of. You will need to open them in a new Excel program.
>> We opened two sessions of Excel and now it does it.
two sessions mean two separate windows?
so are you trying to switch between Excel Books\Sheets with ALT+TAB and you are saying that this works in your case :-?
two sessions mean two separate windows?
so are you trying to switch between Excel Books\Sheets with ALT+TAB and you are saying that this works in your case :-?
What exactly do you mean "now it does it"? When lets say i have 2 excel sheets on my desktop. If i open one, it will open in Excel in its own windows. Then i open the the 2nd one. It will open in its own excel, with 2 seperate entries showing on the taskbar. I can Alt Tab between them no problem.
Possibly try this:
Rick click on an empty portion of the task bar.
uncheck "Group similar taskbar items"
Possibly try this:
Rick click on an empty portion of the task bar.
uncheck "Group similar taskbar items"
OK, I thought of something else. So you just have one Excel program on the taskbar now. Switch to that single Excel file (I know it has multiples, but try this). After you have the Excel file in front of you, hit the ctrl+tab key and see if that will scroll through the 3 excel files in the program.
and i have just tried it myself.... i opened an Excel window... a Book1 opened by default
then i click on NEW, a new book opened as BOOK2
and when i hit ALT+Tab i got the option to choose either BOOK1 or BOOK2
hmmmmmm :-?
then i click on NEW, a new book opened as BOOK2
and when i hit ALT+Tab i got the option to choose either BOOK1 or BOOK2
hmmmmmm :-?
Control + PageUp and Control + PageDown will move to the next sheet in a book as well.
ASKER
>>>What exactly do you mean "now it does it"?
I mean that it now switches between the two Excel workbooks when using Alt and Teb keys. The problem is that he wants to have only one Excel session open becasue he wants to cascade the windows.
>>Control + PageUp and Control + PageDown will move to the next sheet in a book as well.
We want to move between different workbooks, not sheets.
I mean that it now switches between the two Excel workbooks when using Alt and Teb keys. The problem is that he wants to have only one Excel session open becasue he wants to cascade the windows.
>>Control + PageUp and Control + PageDown will move to the next sheet in a book as well.
We want to move between different workbooks, not sheets.
what do you mean by session? means BOOK
coz when you will open Excel, you will get BOOK1
now if you click on New file, a new excel window with BOOK2 name will open and this BOOK2 will have its own window!
what are you referring to? :)
coz when you will open Excel, you will get BOOK1
now if you click on New file, a new excel window with BOOK2 name will open and this BOOK2 will have its own window!
what are you referring to? :)
ASKER
>>Rick click on an empty portion of the task bar.
uncheck "Group similar taskbar items"
This option does not appear when I right-click on the taskbar
uncheck "Group similar taskbar items"
This option does not appear when I right-click on the taskbar
ASKER
>>Rick click on an empty portion of the task bar.
uncheck "Group similar taskbar items"
And also, I always have similar items grouped (working with many Excel file at the same time) and yet my Alt Tab function works right.
It might be a keayboard issue after all. We might have to buy a new one.
uncheck "Group similar taskbar items"
And also, I always have similar items grouped (working with many Excel file at the same time) and yet my Alt Tab function works right.
It might be a keayboard issue after all. We might have to buy a new one.
if i understand correctly, you want to use ALT+TAB to switch between 2 Sheets in 1 Book. This is not possbile. You will have to use CTRL+PGUP and CTRL+PGDN to switch sheets.
The only alternative is to open the same book twice. That downside to this, is the 2nd one will be in read only mode and you cant make changes.
you will have to have the sheets in seperate books if you want to have full access to both sheets and be able to ALT+TAB through them.
The only alternative is to open the same book twice. That downside to this, is the 2nd one will be in read only mode and you cant make changes.
you will have to have the sheets in seperate books if you want to have full access to both sheets and be able to ALT+TAB through them.
ASKER
>>what do you mean by session? means BOOK
coz when you will open Excel, you will get BOOK1
now if you click on New file, a new excel window with BOOK2 name will open and this BOOK2 will have its own window!
what are you referring to? :)
I mean that we go to the Start button and start Excel. We open a file. Then we go to Start button again, open another session of Excel and from that window open the second file. It then acts as if we had two different appliactions open and tabs between them.:-)
coz when you will open Excel, you will get BOOK1
now if you click on New file, a new excel window with BOOK2 name will open and this BOOK2 will have its own window!
what are you referring to? :)
I mean that we go to the Start button and start Excel. We open a file. Then we go to Start button again, open another session of Excel and from that window open the second file. It then acts as if we had two different appliactions open and tabs between them.:-)
ASKER
>>if i understand correctly, you want to use ALT+TAB to switch between 2 Sheets in 1 Book. This is not possbile. You will have to use CTRL+PGUP and CTRL+PGDN to switch sheets.
No, we want to move between two workbooks by using Alt Tab. It works on my computer but not my friend's.
No, we want to move between two workbooks by using Alt Tab. It works on my computer but not my friend's.
means when you open TWO EXCEL programs.... it tabs!
but when you open TWO BOOKS from one Excel window.... it doesn't!
is this time we are on right track? :)
but when you open TWO BOOKS from one Excel window.... it doesn't!
is this time we are on right track? :)
Does your friend have 2003 as well?
If you uncheck that box that says "Window on taskbar" then it should.
If you uncheck that box that says "Window on taskbar" then it should.
How about what I mentioned earlier? Have you tried that out yet?
Switch to that single Excel file (I know it has multiples, but try this). After you have the Excel file in front of you, hit the ctrl+tab key and see if that will scroll through the 3 excel files in the program.
Switch to that single Excel file (I know it has multiples, but try this). After you have the Excel file in front of you, hit the ctrl+tab key and see if that will scroll through the 3 excel files in the program.
If they have office 2000, here is a fix:
This problem occurs if the Windows in Taskbar check box is selected (on the Tools menu, click Options, and then click the View tab).
This problem was first corrected in Microsoft Office 2000 Service Pack 3 (SP-3).
http://support.microsoft.com/kb/305694/EN-US/
This problem occurs if the Windows in Taskbar check box is selected (on the Tools menu, click Options, and then click the View tab).
This problem was first corrected in Microsoft Office 2000 Service Pack 3 (SP-3).
http://support.microsoft.com/kb/305694/EN-US/
Here is SP1 for Office 2003 as well:
http://www.microsoft.com/downloads/details.aspx?FamilyId=9C51D3A6-7CB1-4F61-837E-5F938254FC47&displaylang=en
http://www.microsoft.com/downloads/details.aspx?FamilyId=9C51D3A6-7CB1-4F61-837E-5F938254FC47&displaylang=en
ASKER
>>means when you open TWO EXCEL programs.... it tabs!
but when you open TWO BOOKS from one Excel window.... it doesn't!
is this time we are on right track? :)
Yes!
but when you open TWO BOOKS from one Excel window.... it doesn't!
is this time we are on right track? :)
Yes!
ASKER
>>hit the ctrl+tab key and see if that will scroll through the 3 excel files in the program.
Yes it does. It's not exactly what we want, though... Sorry.... It scrolls through all Excel files we have open.
But what we want is the Alt Tab becasue there you can choose which files you want to move between. And as a default, it scrolls through the ones you used most recently. This si what we need. It works on one computer but not on another.
Yes it does. It's not exactly what we want, though... Sorry.... It scrolls through all Excel files we have open.
But what we want is the Alt Tab becasue there you can choose which files you want to move between. And as a default, it scrolls through the ones you used most recently. This si what we need. It works on one computer but not on another.
If this Excel 97? I remember using this and there's no way around it (not that I can find) besides opening two or more instances of Excel (which is not what you want). Unless someone else has a better way around this, I think you will have to do one of the following:
1. Open multiple instances/windows of Excel documents and alt+tab between them.
2. Open one instance of Excel with the 3 documents. Use alt+tab to display the Excel file, then use ctrl+tab to switch between the different worksheets.
So is it Excel 97 or is it a higher version?
1. Open multiple instances/windows of Excel documents and alt+tab between them.
2. Open one instance of Excel with the 3 documents. Use alt+tab to display the Excel file, then use ctrl+tab to switch between the different worksheets.
So is it Excel 97 or is it a higher version?
ASKER
It's Excel 2003
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
>>>>then i tick Show Windows in Taskbar again......i got two windows named Book1 and Book2 in taskbar and i could tab them!
I did the same thing and got the same result. My friend tried it and it worked for him, too. He might have problems with his keyboard, too, and that's why it switches on him without him knowingly changing the View settings.
Thanks for looking into it!! I'll split the points betwen you and kmorris1186
I did the same thing and got the same result. My friend tried it and it worked for him, too. He might have problems with his keyboard, too, and that's why it switches on him without him knowingly changing the View settings.
Thanks for looking into it!! I'll split the points betwen you and kmorris1186
cool :)
Ask him to uninstall his present keyboard and its software.... and hook another one and then check if same issue..... this normally caused by keyboard softwares! :-?