Worksheets - Visibility

D

Doria/Warris

Hi,

My Excel workbook has got many worksheets and in addition they have quite
long names.
As you can imagine, I have to scroll the horizontal bar continuosly in order
to go from one to another.
Is there a way to make them more visible, for instance by creating two
worksheet rows or anything else?

I use Office 2000.

Thank you
Alex
 
N

Norman Harker

Hi Alex!

Try right clicking on any of the arrows immediately to the left of the
worksheet tabs.
 
D

David McRitchie

Hi Alex,
Color Tabs is only available in 2002 and not available in Excel 2000.
Actually I don't think color tabs would really help you much anyway.
Two rows of worksheet tabs is not available in any version of Excel.
Both of these are available in Lotus Notes and 1-2-3.

Some additional things that can be done, and that you can do in 2000 are:
sorting the worksheet tabs,
renaming the worksheet tabs so they can be sorted logically (k.shortcuts)
Table of Contents, or other means of providing hyperlinks to sheets
more detail in: http://www.mvps.org/dmcritchie/excel/colors.htm#tabs
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Top