Add A Little Color To Your Life

Add A Little Color To Your Life

Ok, so maybe not exactly to “your life”, but would you settle for a little color added to your Excel worksheet tabs?



Of course I’ve got to mention one small catch… this one wasn’t in Excel 97 or 2000. It seems to be an additional feature of the newer versions.

So, anyway, here’s the deal—you can now turn this…


Into this…


It’s an incredibly quick and easy way to color code your worksheet tabs, or maybe to simply make the most frequently used tabs stand out from the rest.

Whatever reason just popped into your mind, it’s a great tool for organizing your files.

So let’s get to the “how to”.

Tab color is just one click away, that is, one right click away.

Right click over the tab that needs to be colored.


From the pop-up menu choose the Tab Color choice.

When the Format Tab Color window opens pick a color and click OK.



The tab color is set.

You will find that while the sheet is selected the color will only show as an underline below the sheet name.

Once you select a different sheet the entire tab will be displayed in color.

Looking to remove the color completely?

No problem. Right click again, select Tab Color and choose None from the Format Tab Color window. Now click OK.

And there you have it… now you’re ready to color your “Excel world” beautiful!

~ April

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.