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

  • Thread starter Thread starter sokevin
  • Start date Start date
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
 
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.
 
Hi Sokevin,

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

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

Back
Top