It would help my data entry immensly by not having to use the mouse.
G Gord Dibben May 3, 2005 #2 Ryan CTRL + PageUp and CTRL + PageDown to cycle through sheet tabs. Gord Dibben Excel MVP
D Dave Peterson May 3, 2005 #3 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.)
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 May 3, 2005 #4 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 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 May 3, 2005 #5 Hi CyberTaz how do you activate the name box without using the mouse? (as per OP's requirements)?
D David McRitchie May 4, 2005 #6 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 can use Go To Ctrl+G which is also F5. I certainly find such things to avoid the mouse to a waste of time.