FINDING A NAMED TAB

T

twinpat

I put a lot of worksheets in one workbook. If I have 100 worksheets in one
workbook and their tab names are 1, 2, 3, 4 etc all the way thru 100, and I
want to find sheet named 50, for instance, without clicking on each tab to
find it, is there a way to find it more quickly?
 
T

Tanya

I put a lot of worksheets in one workbook.  If I have 100 worksheets inone
workbook and their tab names are 1, 2, 3, 4 etc all the way thru 100,  and I
want to find sheet named 50, for instance, without clicking on each tab to
find it, is there a way to find it more quickly?

If you right-click on the navigation arrow to the left of your tabs,
you will see a list of your worksheet names. You can select the one
you want to jump to.

When I create/work with workbooks with many worksheets, I often create
a "Navigation" tab that has hyperlinks to each worksheet. Then on each
worksheet I have a cell that 'links' back to the navigation tab.
 
T

Tanya

I put a lot of worksheets in one workbook.  If I have 100 worksheets inone
workbook and their tab names are 1, 2, 3, 4 etc all the way thru 100,  and I
want to find sheet named 50, for instance, without clicking on each tab to
find it, is there a way to find it more quickly?

If you right-click on the navigation arrow to the left of your tabs,
you will see a list of your worksheet names. You can select the one
you want to jump to.

When I create/work with workbooks with many worksheets, I often create
a "Navigation" tab that has hyperlinks to each worksheet. Then on each
worksheet I have a cell that 'links' back to the navigation tab.
 
D

Dave Peterson

Rightclick on the VCR/DVD like controls at the bottom left corner.

You'll see a list of sheet names -- and with that many you'll also see a "More
sheets" option. Click on that and you can choose to select any of those sheets.

You want to look at:
http://contextures.com/xlToolbar01.html
(From Debra Dalgleish's site.)

It builds a toolbar that you can use with any workbook to navigate to any
worksheet.

There's a link to an xl2007/ribbon version (by Ron de Bruin) on Debra's site.

=======
If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)
 
D

Dave Peterson

Rightclick on the VCR/DVD like controls at the bottom left corner.

You'll see a list of sheet names -- and with that many you'll also see a "More
sheets" option. Click on that and you can choose to select any of those sheets.

You want to look at:
http://contextures.com/xlToolbar01.html
(From Debra Dalgleish's site.)

It builds a toolbar that you can use with any workbook to navigate to any
worksheet.

There's a link to an xl2007/ribbon version (by Ron de Bruin) on Debra's site.

=======
If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top