tab sheet

  • Thread starter Thread starter briank
  • Start date Start date
B

briank

Is is possible to increase the current one row of viewed
worksheets at thew bottom of the screen to a mutltiple row
format? I'm trying to view most, if not all of my tabs.
Thanks.
 
Are you aware of the built-in table of contents (TOC) that XL provides for
sheet tabs?

If you right click in the scroll arrows that are to the left of the tab
names, you will see a list of approximately 15 sheet names.
If there are more, this list can be infinitely expanded to a scrolled TOC.

This list however, is in the order of the sheets as they appear in the WB.
They are not alphabetized, but I guess you could move the sheets around in
the WB manually, thus making this list alphabetical.

You might wish to look at David McRitchie's web page on this subject:

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


HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Back
Top