Moving Between Worksheets

M

MarySue

OK, this will probably win the "Dumb Question of the Day" award, but I'm a
newbie, so I'll ask anyway. I have an Excel 2002 file that has LOTS of
worksheets. I am constantly moving between worksheets, and spend too much
time trying to find the right sheet. Is there any way I can add a new
worksheet that has nothing but "links" to the actual sheet I'm looking for,
maybe something that works like a website link to other web pages? Is there
another way or better way to quickly select the right worksheet? Thanks for
your help.
 
P

Peo Sjoblom

You can right click on the arrows to the left of the first sheet tab and it
will give you a list of all sheets and you can select them from there, that
is probably easier and more user friendly than to create a special sheet with
links to all other sheets

Regards,

Peo Sjoblom
 
B

Beege

I've done this before, and it works quite well. Create a hyperlink for each
sheet on new sheet. The wizard will ask what to link it to, either an
external file or a worsheet in the open file. HTH
 
M

MarySue

Wow - thanks for all the responses. I had no idea those kind of capabilities
were available. The "right-click" is already a blessing compared to what I
was doing, but I'm anxious to try the other solutions as soon as I get a
chance. Thanks so much for all your help!
 
Top