Assign Color to Worksheet Tab - ExcelRace

Advertisements

ads
Responsive Ads Here

Post Top Ad

Your Ad Spot

Friday, 14 October 2016

Assign Color to Worksheet Tab

In Excel, you can assign color to worksheets tab is helpful to identify easily with different types of colors. There are two method to change/assign the tab color.

Method 1:

Right click on the worksheet tab where you want to assign color, you will get a option to choose as shown in the below picture.

assign color
Right Click on sheet tab

And select the option "Tab Color", it will show you the colors that want to apply for sheet tab as shown in the below image.

Assign color
Select Color from Popup


Select the desired color from the above window, your sheet tab will be colored now as below. 

 
Assign color
Now color assigned to worksheet Tab

Method 2:

The second method is by selecting option from the Menu "Format", which is to assign color for the worksheet tab as you like,  the following procedure will follow to assign color.
Go to menu bar and click Home->Format->Tab Color to change the tab color as shown in the below picture.
 

assign color
Select tab color from Menu bar


Select the required color then automatically it will change. If you want to change more color then click more color option, a window will appear as below.
 

Assign color
Choose color as you like


From the above window, you can choose the different colors to change it.

Thank You Visit Again!!!...

No comments:

Post a Comment

Post Top Ad

Your Ad Spot