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

  • Thread starter Thread starter Kim@excal
  • Start date Start date
K

Kim@excal

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.
 
Colored tabs were introduced in Excel 2002

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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.
 
right click on the tab and there should be a choice saying "tab color". I'm
in office 2003, so it may be different?
 

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

Similar Threads

Move data on multiple tab to one 2
sorting rows of data 7
In WORKDAY function, how to exclude multiple/variable holiday rang 4
Windows 10 Win 10 Home activation code pricing 12
How to sum 5
coding error I don't know how to debug? 1
Enter Value based on Cell Color 1
How do I get excel to shade grey at every different vendor name? 3

Back
Top