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.
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.
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.
- Consequently, you will have your output as shown in the below screenshot.
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.
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.
- Eventually, you will have your output as shown in the below screenshot.
Similar Readings
- How to Make Excel Easier on the Eyes (12 Quick Tips)
- How to Make Excel Look Pretty (16 Easy Formats)
- How to Remove Background Color in Excel (5 Ways)
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.
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.
- Finally, you will finish changing your worksheet tab color to Yellow.
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.
Steps:
- In the beginning, select the worksheet tab Shortcut Keys.
- Next, press ALT > H > O > T.
- After that, select the color Yellow.
- Eventually, you will have your output as shown in the below screenshot.
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.
Steps:
- First, press  ALT + F11 to open the Microsoft Visual Basic window.
- Then, double-click on Sheet 5 (VBA Code).
- 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
- Now, press F5 to run the code.
- Finally, you will have your output as shown in the below screenshot.
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.
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.
- Finally, you will finish removing the 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.
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
- How Do I Change the Default Background Color in Excel
- How to Make Excel Look Like an Application (with Easy Steps)
- [Fixed!] Background Color Not Changing in Excel (6 Solutions)
- How to Change Background Color Based on Value in Excel
- How to Make Picture Background Transparent in Excel (2 Methods)
- How to Remove Background in Excel (2 Practical Cases)