Articles → EXCEL → Change tab color in excel 2007

Change tab color in excel 2007

In this article I will explain how to change tab color in excel. This topic contains following sections

     1. Software requirement

     2. Prerequisite knowledge

     3. Open a new excel

     4. Change tab color

     5. Output

Software requirement

Before you start reading this tutorial you should make sure that excel 2007(or above) is installed on your machine.

Prerequisite knowledge

Before you go ahead, it is required that you should know basics about excel.

Open a new excel

First of all open a new excel file and save it with the name ‘Tab_Color_Demo.xlsx’ (you can give any name).

Change tab color

You can change the tab color by 2 ways

Option 1-

     1. Right click on the tab

     2. Click on ‘Tab Color’

     3. A color picker appears to select color as shown in figure below

Click to Enlarge

Option 2-

     1. Select tab

     2. Go to ‘Home’ tab

     3. In the ‘Format’ click on ‘Tab Color’

     4. A color picker appears to select color as shown in figure below

Click to Enlarge

Output

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Tuesday, May 13, 2014

Query/Feedback

Your Email Id

Subject

Query/Feedback	Characters remaining 250