Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default Color in MS 2003 Excel Tabs | Excel Discussion (Misc queries) | |||
Should be able to color code or highlight Excel worksheet tabs. | Excel Worksheet Functions | |||
Code to create tabs in single excel sheet | Excel Discussion (Misc queries) | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
MS Excel should allow you to change the color of the tabs or the . | Excel Worksheet Functions |