Selecting a specific worksheet

  • Thread starter Thread starter Jackie
  • Start date Start date
J

Jackie

I have 40 tabs (worksheets) named in my workbook. Is there an easier way to
go to a specific worksheet without have to tab over and past all the other
worksheets?

I just learned you can automatically alphabetize named tabs using VBA, but I
don't know anything about VBA.

Thank you,
Jackie
 
Hi Jackie
Maybe not what you want but did you know if you right click to the left of your
first tab, the scroll left-right arrows, you will get a drop-down menu with all
your Tabs and last entry showing "More sheets".
HTH
John
 
Hi John,

This discussion group has answered so many questions for me. Thank you! I
had no idea that shortcut existed. I will try this and see if I can learn
more about a Sheet Navigation Toolbard that Gord recommended.

Many, many thanks from this 'newbie' Excel user ~

Jackie
 
Hi Gord,

Thank you! I want to learn more about this process and will study the link
you provided.

To me...all of you guys and gals must be members in MENSA who understand the
intricacies of Excel.

Jackie
 
Thanks

Like any other endeavor, practice, practice, practice makes one become more
familiar with the intricacies.


Gord
 
Back
Top