formatting worksheet tabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i would like to format my worksheet tabs with different colors & fonts. is there a way to do this in excel 2k? i thought this option was available in the older versions?
thanks for any help
terri tilghma
 
Terri

Only in 2002 and 2003. Earlier versions do not allow, no how.

Gord Dibben Excel MVP
 
Hi Terri,
What you were used to seeing was probably Lotus 1-2-3 or
Lotus Notes.

See topic "Changing the Colors of Worksheet Tabs (#tabs)"
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs

for how to set sheet tab color in Excel 2002 and up.

For Excel 95 and up you can name sheet tabs
so that they can be nicely sorted into categories. I think sorted tabs
makes a lot more sense that trying to make meaningful color coded
sheet tabs anyway but a lot of people wanted colored sheet tabs
like they were used to so they were added in Excel 2002..
 
Back
Top