How do you shade the tab's (sheet's) name?

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
right click the sheet tab and you can see the fillcolor ( I think it is available for excel version after 2000 ).
 
Upvote 0
right click the sheet tab and you can see the fillcolor ( I think it is available for excel version after 2000 ).
I use Excel 2003 and there is no option fill color.. :oops: Could it be that it is only available for older versions?
 
Upvote 0
hhhmmm. I think that was xp or 2002.

for 2003, Format > Sheet > Tab Color.
The tab color only underlines the sheetname.

The one I am seeing is that the entire sheetname is shaded with background color.
 
Upvote 0
ah. not sure about that. but if you have time searching on the internet regarding the tab color in excel you can found a few thread regarding this and format > sheet > tab color work for 2003.
 
Upvote 0

Forum statistics

Threads
1,214,875
Messages
6,122,044
Members
449,063
Latest member
ak94

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top