color tab on spreadsheet

[Guest]

hi
I have a file with 20 tab and names nearly same. So I would like to color the tab. Do you know how to do it
thanks for hel
Benjamin

 

[Ron de Bruin]

Is only possible in Excel 2002 and 2003 Ben

 

[Peo Sjoblom]

Only way is to get Office XP (excel 2002) onward

--

Regards,

Peo Sjoblom

hi,
I have a file with 20 tab and names nearly same. So I would like to color

the tab. Do you know how to do it ?

 

[Guest]

Ouuuiiinnnnn
thanks a lot, I still won't lost my time to searhc.....

 

[David McRitchie]

Hi Ben,
Twenty worksheets doesn't sound like a lot of names.

You can name sheets anything you want to make them unique.

Sorting the worksheet names makes it a lot easier to find names,
you may have to be careful if you have 3D references to multiple
worksheets i.e. sheet1:Sheet130
http://www.mvps.org/dmcritchie/excel/excel/buildtoc2.htm#sortallsheets

You could make a table of contents
http://www.mvps.org/dmcritchie/excel/excel/buildtoc.htm

If the worksheet names include dates, you would want the do be
something like yyyymmdd or yyyy_mmdd so that they sort
properly.

If you want to categorize them you add a prefix to the worksheetnames.

I had Lotus Notes which like Lotus 1-2-3 had colored tabs, I can remember
coloring the tabs and impressing someone with them, but I can't remember
what I had categorized with them. What do you use the colors to categorize.