How to Assign a Color to an Excel Sheet Tab - dummies

How to Assign a Color to an Excel Sheet Tab

By Faithe Wempen

Here’s a formatting trick to keep your Excel workbooks organized. Each Excel worksheet tab can have a different color, or you can color several tabs all the same to indicate that they’re somehow related. You can use your color assignments to keep track of your projects. The coloring is all up to you!

To assign a color to a sheet tab, follow these steps:

  1. Right-click the tab and hover your mouse over Tab Color on the contextual menu.

  2. In the Theme Colors palette that appears, click the desired color.


When a colored tab is active (that is, when that particular sheet is displayed), the color appears slightly washed out in a soft gradient. But when you select a different tab, the inactive tab(s) appear in its full colorful glory. To remove the color, repeat the preceding steps and click No Color in Step 2.