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

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
right click the sheet tab and you can see the fillcolor ( I think it is available for excel version after 2000 ).
 

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,749

ADVERTISEMENT

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?
 

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
hhhmmm. I think that was xp or 2002.

for 2003, Format > Sheet > Tab Color.
 

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,749
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.
 

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
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.
 

Forum statistics

Threads
1,140,938
Messages
5,703,271
Members
421,289
Latest member
fbohlandt

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
Top