ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Change Sheet "TAB" colour? (https://www.excelbanter.com/new-users-excel/4732-change-sheet-%22tab%22-colour.html)

Kane

Change Sheet "TAB" colour?
 
Is there a way to change the colour of one "Sheet Tab" , among 12 others?

cwilson

Right click on the tab and select tab color.

"Kane" wrote:

Is there a way to change the colour of one "Sheet Tab" , among 12 others?


IanRoy

Right click the tab, choose color.

"Kane" wrote:

Is there a way to change the colour of one "Sheet Tab" , among 12 others?


Debra Dalgleish

If you have Excel 2002, or later version, right-click on the sheet tab
Choose Tab Color, and select a colour.

There's a picture in the Excel FAQ:

http://www.contextures.com/xlfaqApp.html#TabColour


Kane wrote:
Is there a way to change the colour of one "Sheet Tab" , among 12 others?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Kane

I should have indicated the version ... Excel 2000. I gather from what has
been said, is that this function is not available in 2000, as it is in v2002.
Can I do this in xl2000?
Tks.... Wayne

"Debra Dalgleish" wrote:

If you have Excel 2002, or later version, right-click on the sheet tab
Choose Tab Color, and select a colour.

There's a picture in the Excel FAQ:

http://www.contextures.com/xlfaqApp.html#TabColour


Kane wrote:
Is there a way to change the colour of one "Sheet Tab" , among 12 others?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



Debra Dalgleish

No, you can't change the tab colour in Excel 2000. The feature was
introduced in Excel 2002.

Kane wrote:
I should have indicated the version ... Excel 2000. I gather from what has
been said, is that this function is not available in 2000, as it is in v2002.
Can I do this in xl2000?
Tks.... Wayne

"Debra Dalgleish" wrote:


If you have Excel 2002, or later version, right-click on the sheet tab
Choose Tab Color, and select a colour.

There's a picture in the Excel FAQ:

http://www.contextures.com/xlfaqApp.html#TabColour


Kane wrote:

Is there a way to change the colour of one "Sheet Tab" , among 12 others?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com