Sheet Tabs

[Pamela]

Is there a way to change the color of your sheet tabs in
an Excel workbook. I thought I did it before, but it may
have been in Lotus. Thanks

 

[battycat]

Select the tab, right click on the tab and pick tab color
from the quick menu

 

[Katherine Coombs]

Note that this only works in XL2002 and higher

Select the tab, right click on the tab and pick tab color
from the quick menu

 

[David McRitchie]

Hi anonymous poster Pamela (no lastname),
In Excel only in Excel 2003 can you change the color of your sheet tabs,
so you may have used that or you may have used Lotus 1-2-3 (or Lotus Notes).

Try to include a better descriptive subject name when you post,
should have included the word color. But don't change subject
title once posted.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[Katherine Coombs]

David,

This functionality is also available in XP/2002.

Cheers,
katherine

Hi anonymous poster Pamela (no lastname),
In Excel only in Excel 2003 can you change the color of your sheet tabs,
so you may have used that or you may have used Lotus 1-2-3 (or Lotus Notes).

Try to include a better descriptive subject name when you post,
should have included the word color. But don't change subject
title once posted.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Select the tab, right click on the tab and pick tab color
from the quick menu