Equivalent of Alt+Tab for going between worksheets?

J

Jonathan

Hi all,

I know using CTRL+ Page Up/Dn goes through the tabs in a worksheet, but I'm
looking for one that skips the in between. I want to go from Tab 1 to Tab 6
back and forth without the mouse and without scrolling through all the other
tabs. Basically it's the ALT+Tab equivalent to go back to your last open
program/window whatever for excel. Does this exist?
 
M

Mike H

One way,

right click the FF - Rewind buttons to the left of the status bar and you
get a popup of all your sheets. Click the one you want.

Mike
 
G

Gord Dibben

None that I know of.

You could temporarily hide the intervening sheets then use CTRL + PageUp and
Down but that would be a PITA in my estimation without a macro to hide and
unhide all at once.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I alt-tab between windows in Excel with 07? 2
Switching between sheets in same workbook (Like Alt + Tab & Choose 4
WANT TO ALT/ESC TO BOUNCE BACK & FORTH BETWEEN TWO WORKSHEETS 2
How to refer to tab names? 1
How to switch between worksheets without using mouse? 2
Moving between the tabs on a worksheet 3
Hide/unhide TAB Script 1
copying "staggered" outline data from one tab to another, lining up the data on the target tab 1

Top