displaying worksheet tabs in two rows?

[dannycombs]

I have a workbook with more than 60 separate worksheets. Is there an
way to display the named worksheet tabs at the bottom of the screen i
multiple rows, two or even five, rather than have to scroll back an
forth?
Thanks,
Dann

 

[Jason Morin]

You can right-click over the tab navigation keys to the
bottom left. However, with 60 worksheets, it will only
display 15. You'll have to click "More sheets..." to view
the list for the remaining ones.

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi Danny
that is not possible

 

[dannycombs]

Thanks. The right click list definitely helps. I don't suppose ther
is a key somewhere or some way to exand that list from the default 1
plus More... to like 25 or 35 plus More...?

 

[Frank Kabel]

Hi
no

 

[Dave Peterson]

You may want to build a table of contents worksheet that contains a short
description and a hyperlink to that page.

David McRitchie has some code that can help:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

If you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Dave Peterson]

And add a hyperlink to each sheet that takes you back to the table of contents.

 

[David McRitchie]

Hi Danny,
As a followup and summary to some of the other replies in this thread.

I seldom put a hyperlink back to the TOC, because that page
is always first (by sorting worksheet tabs), and the leftmost navigation
arrow will take you to that page.

Also when you use hyperlinks, you can use your browsers Forward (Alt+RtArrow)
and Back (Alt+LtArrow) buttons. There are turquoise toolbar arrow buttons
on the web toolbar as well.

If the Table of Contents is the first worksheet you can use the leftmost
sheet navigation arrow instead of putting in a hyperlink in each sheet
back to the Table of Contents. On my Builtd TOC page, you can see that
I name that page $$TOC so that sorting worksheet tabs will put that page
in front of the other tabs with worksheet names that don't begin with $ signs.
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Right clicking on the navigation arrows to brings up a list of worksheet names,
works best if your worksheet tabs are sorted.
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets)

You can bring up the "More" directly in the list rather than starting with the
first 15 by using macro
http://www.mvps.org/dmcritchie/excel/sheets.htm#moresheets




--