hotkey for browsing through worksheets

R

Robert

is there a "hotkey" and/or keystroke, in Excel 2002, to
change to a different worksheet?

i'm doing some rapid data entry in multiple worksheets,
and taking my hand off the keyboard to put it on the
mouse to click on the worksheet tabs slows me down. i'm
looking for a "hotkey" to change to the next worksheet,
so i wont have to leave the keyboard...

if nothing is pre-defined in excel, can i accomplish this
through a macro? all suggestions are helpful.

thanks,

-robert
 
D

Doug Kanter

Assuming the geniuses at Microsoft haven't changed it, CTRL-F6. Also works
with MS Word and many other programs, Microsoft or otherwise. And, if you
have a worksheet with multiple sheets, CTRL-PgUp/PgDown will move you along
the series of tabs.
 
R

Robert

i thought i tried it all, but i guess i didnt try CTRL-
PgUp/PgDown.

PERFECT!!! thanks!
-----Original Message-----
Click to expand...
Assuming the geniuses at Microsoft haven't changed it,
CTRL-F6. Also works with MS Word and many other programs,
Microsoft or otherwise. And, if you have a worksheet with
multiple sheets, CTRL-PgUp/PgDown will move you along
the series of tabs.
 
D

Doug Kanter

You've tried CTRL-END and CTRL-HOME, right? I got a million of 'em (opening
jacket like a cheap watch salesman).
 
Top