Worksheets - Visibility

  • Thread starter Thread starter Doria/Warris
  • Start date Start date
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
 
Hi Alex!

Try right clicking on any of the arrows immediately to the left of the
worksheet tabs.
 
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
 
You must log in or register to reply here.

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

Similar Threads

Worksheets - Visibility 5
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Need to merge worksheets - Excel 2003 0
Is there an easy keyboard shortcut to scroll between worksheets? 1
Excell 2000 worksheet help 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
In Excel 2000, how do I add a vertical scroll bar to a split scre. 1
How to have Excel worksheet open and see all the corners? 1

Back
Top