Change worksheet tab colour in Excel

Microsoft Excel 2016, 2013 and 2010 allow users to change the worksheet tab colour using the Format menu option or Context menu.

Method 1 :- Using Format Menu

  • Select the worksheet tab whose the colour needs to be changed.


  • Navigate to Cell menu section and click the drop down arrow available below the format menu


  • Navigate to Tab Colour menu option and select your preferred colour.

Method 2 :- Using Context Menu

This is the quickest way for changing the tab colour.

  • Right click on the worksheet tab to launch the context menu.
  • Navigate to Tab Colour menu option and select the preferred colour of your choice.


In Category: Excel 2010, Office 2010

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.