Moving Between Worksheets

  • Thread starter Thread starter MarySue
  • Start date Start date
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.
 
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
 
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
 
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!
 
Back
Top