How to Change Worksheet Tab Color in Excel (5 Handy Methods)

In many cases, we may need to add or change the worksheet tab color in Excel. This helps you identify any worksheet very easily. Also, adding or changing worksheet colors helps categorize the worksheets. This article demonstrates how to change worksheet tab color in Excel with 5 methods.


Download Practice Workbook

You can download the practice workbook from the link below.


5 Methods to Change Worksheet Tab Color in Excel

Let’s assume you have an Excel workbook with multiple worksheets as shown in the below screenshot. Now, for some reason, you need to change the tab color of those worksheets. This will help you identify any specific kind of worksheet faster. In the following stages of the article, we will see 5 methods to change the color of the following worksheet tabs in Excel.

5 methods to change worksheet tab color in excel

We have used Microsoft Excel 365 version for this article, you can use any other versions according to your convenience.


1. Right-Click on Worksheet Tab in Excel

In this method, we will change the color of the Single Sheet Right Click tab to color Yellow. Now, follow the steps below to do so.

Right-Click on Worksheet Tab in Excel

Steps:

  • First, Right-Click on the worksheet tab you want to change the color of. In this case, the tab is Single Sheet Right Click.
  • Next, select Tab Color.
  • After that, select the color Yellow.

Right-Click on Worksheet Tab in Excel

  • Consequently, you will have your output as shown in the below screenshot.

Right-Click on Worksheet Tab in Excel

Read More: How to Make Excel Spreadsheet Colorful (6 Simple Tricks)


2. Changing Tab Color of Multiple Worksheets

Now, suppose you need to change the tab color of multiple worksheets such as Single Sheet Right Click and Multiple Sheet Right Click at once. Now, to do so follow the below steps.

Changing Tab Color of Multiple Worksheets

Steps:

  • At the very beginning, select the worksheet tab Multiple Sheet Right Click.
  • Then, press SHIFT on your keyboard and select the worksheet tab Single Sheet Right Click.
  • Next, select Tab Color.
  • After that, select the color Yellow.

Changing Tab Color of Multiple Worksheets

  • Eventually, you will have your output as shown in the below screenshot.

Changing Tab Color of Multiple Worksheets


Similar Readings


3. Using Format Button

Another method to change the worksheet tab color is to use the format button in excel. Now, to change the worksheet tab Format Button color to Yellow follow the below steps.

Using Format Button

Steps:

  • First, select the worksheet tab Format Button.
  • Then, go to the Home tab.
  • After that, click on the button Format.
  • Next, go to Tab Color.
  • Consequently, select the color Yellow.

Using Format Button

  • Finally, you will finish changing your worksheet tab color to Yellow.

Using Format Button


4. Applying Shortcut Keys to Change Worksheet Tab Color

In this method, we will change the color of the worksheet tab Shortcut Keys to Yellow using shortcut keys. Now, to do so follow the below steps.

Applying Shortcut Keys to Change Worksheet Tab Color

Steps:

  • In the beginning, select the worksheet tab Shortcut Keys.
  • Next, press ALT > H > O > T.
  • After that, select the color Yellow.

Applying Shortcut Keys to Change Worksheet Tab Color

  • Eventually, you will have your output as shown in the below screenshot.

Applying Shortcut Keys to Change Worksheet Tab Color

Read More: How to Make Excel Look Like a Page (with Easy Steps)


5. Utilizing VBA Code to Change Worksheet Tab Color in Excel

Also, you can change the worksheet tab color in excel using VBA code. Now, to change the color of the worksheet tab VBA Code to Yellow follow the below steps.

Utilizing VBA Code to Change Worksheet Tab Color in Excel

Steps:

  • First, press  ALT + F11 to open the Microsoft Visual Basic window.
  • Then, double-click on Sheet 5 (VBA Code).

Utilizing VBA Code to Change Worksheet Tab Color in Excel

  • Now, copy the following code and paste it into the blank space.
'This code will help you change worksheet tab color
Sub ChangeSheetColor()
'This line of code will declare a variable
Dim Sht As Worksheet
'This line of code will assign the variable to a worksheet
Set Sht = Worksheets("VBA Code")
'This line of code will change the sheet tab color
Sht.Tab.Color = vbYellow
End Sub

Utilizing VBA Code to Change Worksheet Tab Color in Excel

  • Now, press F5 to run the code.
  • Finally, you will have your output as shown in the below screenshot.

Utilizing VBA Code to Change Worksheet Tab Color in Excel

Read More: Excel VBA to Open Workbook in Background (2 Useful Examples)


How to Remove Worksheet Tab Color in Excel

Sometimes you may require removing the worksheet tab color. In this case, suppose you want to remove the color of the worksheet tab Remove Color. Now, to do so follow the below steps.

How to Remove Worksheet Tab Color in Excel

Steps:

  • First, Right-Click on the worksheet tab you want to change the color of. In this case, the tab is Remove Color.
  • Next, select Tab Color.
  • After that, select No Color.

How to Remove Worksheet Tab Color in Excel

  • Finally, you will finish removing the worksheet tab color in Excel.

How to Remove Worksheet Tab Color in Excel


Practice Section

For doing practice by yourself we have provided a Practice section like below in another worksheet. Please do it by yourself.

Practice Section


Conclusion

In this article, I have shown how to change worksheet tab color in Excel with 5 different methods. Also, I have shown how to remove the worksheet tab color. Last but not the least, I hope you found what you were looking for from this article. If you have any queries, please drop a comment below. Also, if you want to read more articles like this, you can visit our website ExcelDemy.


Related Articles

Sowmik Chowdhury
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo