EXCEL 2000 - hod to i add color to the tabs?

S

sokevin

hi i am on excel 2000, is there a way to add color to the workshee
tabs?

i know i can do right click on excel 2002.

cheers
:cool
 
D

David McRitchie

Coloring the worksheet tab is not available before Excel 2002.

I believe the normal reason to color tabs is to provide an
organization to them. You can sort sheet tabs with a macro.
You can enhance your sorted arrangement by preceding the
sheet tab with some less conspicuous small letters. i.e.
k.FunctKeys, k.ShortCutKeys

If working with dates for sheetnames, spell the year out and place it first
2002-10, 2002-11, 2002-12, 2003-01

See “sort sheet tabs” in
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets
The main topic on that page is to create a Table of Contents with
hyperlinks to the other sheets. A builtin alternative to navigate
to a sheet is to RClick on a scrolling arrow in lower left corner,
the sheets are listed in the same order as the worksheet tabs
at the bottom of your spreadsheet.
 
N

Norman Jones

Hi Sokevin,

The colored tabs feature was introduced with xl2002 and is not available in
earlier versions.
 
Top