How do i navigate between sheet tabs from my keyboard?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

It would help my data entry immensly by not having to use the mouse.
 
Ryan

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


Gord Dibben Excel MVP
 
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.)
 
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 |:>)
 
Hi CyberTaz

how do you activate the name box without using the mouse? (as per OP's
requirements)?
 
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.
 
You must log in or register to reply here.

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

Is there a keyboard shortcut to switch between Excel sheets? 1
Keyboard Shortcut 3
How do I jump between sheets in Excel using keyboard? 3
Tab navigation in a protected worksheet 5
Keyboard shortcut to 'Formula Bar' ? 5
Keyboard shortcut between sheet 1
USB Com ports 6
sheet tab options 1

Back
Top