How do i navigate between sheet tabs from my keyboard?
 

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

On Mon, 2 May 2005 17:02:02 -0700, Ryan T <Ryan
wrote:

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

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.)





Ryan T wrote:

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

--

Dave Peterson

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 |:)

"Ryan T" wrote:

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

Hi CyberTaz

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

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"CyberTaz" wrote in message
...
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 |:)

"Ryan T" wrote:

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

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.

"JulieD" wrote in message ...
Hi CyberTaz

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

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"CyberTaz" wrote in message
...
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 |:)

"Ryan T" wrote:

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