How do i navigate between sheet tabs from my keyboard?

G

Gord Dibben

Ryan

CTRL + PageUp and CTRL + PageDown to cycle through sheet tabs.


Gord Dibben Excel MVP
 
D

Dave Peterson

ctrl-pgup and ctrl-pgdn will cycle through the worksheets.

ctrl-F6 and ctrl-shift-F6 will cycle through the open windows. (As will
ctrl-tab and shift-ctrl-tab.)
 
C

CyberTaz

Hi Ryan-

You can also click in the Name box (left end of the Formula Bar where the
Active Cell reference appears) and type the goto location, such as
Sheet5!b200 then press Enter.

HTH |:>)
 
J

JulieD

Hi CyberTaz

how do you activate the name box without using the mouse? (as per OP's
requirements)?
 
D

David McRitchie

You can use Go To Ctrl+G which is also F5.

I certainly find such things to avoid the mouse to
a waste of time.
 
Top