Link to home
Start Free TrialLog in
Avatar of Lucynka
Lucynka

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?
Avatar of SheharyaarSaahil
SheharyaarSaahil
Flag of United Arab Emirates image

Hello Lucynka =)

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! :-?
Avatar of Lucynka
Lucynka

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
Avatar of kmorris1186
kmorris1186

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Lucynka

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.

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 ??
Avatar of Lucynka

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? :)
Avatar of Lucynka

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 :-?
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"
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 :-?
Control + PageUp and Control + PageDown will move to the next sheet in a book as well.
Avatar of Lucynka

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.
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? :)
Avatar of Lucynka

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
Avatar of Lucynka

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.
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.
Avatar of Lucynka

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.:-)
Avatar of Lucynka

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.
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? :)
Does your friend have 2003 as well?

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.
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/

Avatar of Lucynka

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!
Avatar of Lucynka

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.
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?
Avatar of Lucynka

ASKER

It's Excel 2003
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Lucynka

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