Problem in using ALT+TAB in EXCEL 2007

Question

Hello every1,

My query is that the alt+tab short cut key is not working properly in microsoft excel. I can explain the same through example.

Suppose I'm working on excel sheet A and B simultaneously. I entered information in sheet A and immediately want to go to sheet B, so I pressed alt+tab, but it does not swap at once. So, I pressed the tab button again and then it gets swap.

Be free for any clarification

URGENT

Answer 1

Hi Himanshu,

There should not be any problem using the ALT+TAB Combo to switch Workbooks. 

However, make sure this checkbox has been clicked under Excel Options > Advanced

Show all windows in the Taskbar

If you are taking about different worksheets in a workbook, you can use CTRL+Page UP/Down

Hope this helps

Regards

PatelK

Answer 2

Thanx, but the check box is already clicked.

I have to click alt+tab twice to switch over to the next excel sheet. Further the shortcut is working absolutely fine with Microsoft word

Answer 3

Are you using Windows 7 ?

Answer 4

no windows 10

Answer 5

Hi,

I've found another problem with ALT+TAB when using Excel 2007.

Right after I upgrade from windows 7 to 10 I can no longer switch between the "find and replace" dialog box and active worksheet using ALT+TAB. It's a pain to either close the "find and replace' dialog box or use mouse to switch when there are a lot of things to edit.

Did windows 10 change some sort of settings?