Site icon ExcelNotes

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.

Exit mobile version