How to change tab colors in Excel

You can watch a video tutorial here.

Spreadsheets can get massive and complicated really fast. You get a thousands of rows and hundreds of columns, added that with multiple tabs, it is always best to keep your work as tidy as possible. One way to handle multiple tabs is to change their color.



Step 1 – Hold “Ctrl” and click on the tabs you want to color.

The “Avocado Sales” and “Forecasting” tab have been used for this example.

Step 2 – Right click and in the options menu, click Tab Color

There are several color options to choose from.

Step 3 – Choose your preferred tab color and click.

Once you find your color, press on click. For this example, Red was used to highlight the tab.