WANT TO ALT/ESC TO BOUNCE BACK & FORTH BETWEEN TWO WORKSHEETS

[redneckrunt]

I USED TO COULD BOUNCE BACK AND FORTH BETWEEN TWO WORKSHEETS BY USING THE ALT
ESC KEYS. IT WON'T LET ME DO THAT NOW. WHAT HAS CHANGED? HOW DO I GET IT
BACK? I HAVE TO COMPARE ADDRESSES ON TWO DIFFERENT WORKSHEETS. A SUBSCRIBER
LIST AND A ROUTE LIST

 

[Pendelfin]

Hi

Have you tried using ctrl page up or down - this usually works for me if you
are moving between worksheets within the same spreadsheet . if it is
different spreadsheets the Alt Tab should work.

If you can't see the other spreadsheets open when you Alt Tab then goto
Tools Options and within view make sure you have a tick for Windows in
Taskbar.

Hope this helps.

Pen

 

[Gord Dibben]

Have you thought of creating a new window and arranging the two windows side
by side so both sheets are visible at same time?

Window>New Window

Window>Arrange>Vertical


Gord Dibben MS Excel MVP