How to Change Worksheet Tab Color

You can change the worksheet tab color to organize your work, especially when you have many worksheets with different topics. You can assign a color to several worksheets with the same topic. To change worksheet Tab color, please follow the steps below:

Step 1: Right-click on the worksheet tab you need to change, select "Tab Color" in the color dialog box;

Step 2: Select a theme color from the list for the Tab;

Step 3: Click "More Colors" to have more options if you cannot find a satisfied color.

Step 4: You can select a color from Standard window;

Step 5: You can also select a color from Custom window;

Step 6: Click OK at the bottom.

Alternatively, you can use the commands from ribbon.

Step 1: Click the "Home" tab from the ribbon;

Step 2: Click the "Format" command from the Cells section;

Step 3: Select "Tab Color" from the drop-down list and select a color.

Leave a Reply