How to Change the Color of a Worksheet Tab

Firstly, why should you change the colour of your worksheet tabs?

Primarily, worksheet tab colors provide a visual cue that worksheets in an Excel file relate to each other, for example, team worksheets relating to a single department, data relating to a geographical location.

Like anything in Excel, changing the color of a worksheet tab is easy when you know how.

1/ Right click on the worksheet tab you want to change the color of.

2/ Choose Tab Color

3/ Click the desired colour and the tab will change

NOTE: To change multiple tabs to the same color at once, click on the first tab, hold down the Ctrl key on the keyboard and select the other tabs before right clicking on one tab and choosing Tab Color

Want help with Microsoft Excel?

Subscribe to my YouTube Channel here www.donnahanson.com.au/youtube

Subscribe to my free weekly or monthly productivity eNewsletters here www.donnahanson.com.au/subscribe

They are both free!