I need to know how to color code tabs on the Excel worksheets
 

I know there is a way to do it, but for the life of me I cannot remember. I
have several dozen numbered worksheets in a folder and I want to color code
the tabs for ease in locating the worksheets for each vendor. Blue for Vendor
X, Red for Vendor Y, Orange for Vendor Z. . . I am currently using Office
2000.

I need to know how to color code tabs on the Excel worksheets
 

R-click on the "Tab" and select "Tab Color"

Kim@excal wrote:
I know there is a way to do it, but for the life of me I cannot remember. I
have several dozen numbered worksheets in a folder and I want to color code
the tabs for ease in locating the worksheets for each vendor. Blue for Vendor
X, Red for Vendor Y, Orange for Vendor Z. . . I am currently using Office
2000.

I need to know how to color code tabs on the Excel worksheets
 

Colored tabs were introduced in Excel 2002

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kim@excal" wrote in message ...
|I know there is a way to do it, but for the life of me I cannot remember. I
| have several dozen numbered worksheets in a folder and I want to color code
| the tabs for ease in locating the worksheets for each vendor. Blue for Vendor
| X, Red for Vendor Y, Orange for Vendor Z. . . I am currently using Office
| 2000.

I need to know how to color code tabs on the Excel worksheets
 

right click on the tab and there should be a choice saying "tab color". I'm
in office 2003, so it may be different?

"Kim@excal" wrote:

I know there is a way to do it, but for the life of me I cannot remember. I
have several dozen numbered worksheets in a folder and I want to color code
the tabs for ease in locating the worksheets for each vendor. Blue for Vendor
X, Red for Vendor Y, Orange for Vendor Z. . . I am currently using Office
2000.