Geekers - When we run the Microsoft Office Excel application, we will be given a workbook in which there are many worksheets. By default, Microsoft Excel 2013 displays only one worksheet, namely Sheet1, but we can add the next worksheet by simply clicking the plus (+) button on the right side of Sheet1. Sheet1, Sheet2 and so on will appear as tabs with the same appearance.
If we work with many worksheets (worksheets), it might be very helpful if each worksheet tab is given a different color. We can go to a particular worksheet by remembering the color that has been given. Color can make the overall workbook look more attractive and can relieve boredom a bit. Then, how do you change the color of each sheet tab in Microsoft Excel?
Well, this time I will share about how to color sheet tabs in excel very easily. how do? Just follow the steps below.
How to Color Sheet Tabs in Excel
There are 2 ways that I will share to color sheet tabs in excel. Please choose which method you want to use. Immediately, see the steps - the following steps.
A. Using the Format Menu
1. First, please open and create several sheets in excel. As in the picture below.
How to Color Sheet Tabs in Excel How to Color Sheet Tabs in Excel
2. Then, please go to the Home menu which is at the top. As in the picture below.
click home click home
3. Then, please click the Format menu. As in the picture below.
click format click format
4. Then, please click "Tab Color", then please choose the color you want. As in the picture below. Oiya, make sure you are on the sheet that you want to color, OK?
How to Color Sheet Tabs in Excel How to Color Sheet Tabs in Excel
5. Your sheet has changed to the color you want. As in the picture below.
color sheets color sheets
B. Using the Fast Way
1. Please right-click on the sheet that you want to color. Then, click “Tab Color�. Then, several color options will appear. Please choose the color you want. As in the picture below.
tab col, or tab col, or
2. Your sheet has changed to the color you want. As in the picture below.
How to Color Sheet Tabs in Excel How to Color Sheet Tabs in Excel
Then, Can We Return The Color Back As It Was?
Of course you can. Immediately, refer to the following steps:
1. First, please open the sheet that you have colored in excel. As in the picture below.
color color
2. Then, please go to the Home menu which is at the top. As in the picture below.
click home click home
3. Then, please click the Format menu. As in the picture below.
How to Color Sheet Tabs in Excel How to Color Sheet Tabs in Excel
4. Then, please click the “Tab Color�, then please select “No Color� . As in the picture below. Oiya, make sure you are on the sheet that you want to remove the color from.
no color no color
5. Your sheet has changed to its original color. As in the picture below.
sheet sheets
Well, how? The method is quite easy and very simple, right? Now we can give the sheet tab the color you want. So, our sheet tabs become more colorful and not monotonous, aka pleasing to the eye heheheh.
That's how to Color the Sheet Tabs in Excel easily that you can try. If this article can help you, please share it with your friends so they also know how to easily color tab sheets in Excel. Hopefully this article can be useful for all of us. If there is a writing error please forgive. Thank you 🙂
RELATED TUTORIALS
* 2 Ways to Sort Data in Microsoft Excel
* Guide on how to make graphs in Excel
* 3 Ways to Make Tables in Excel (All Excel Versions)
* How to Make a Calendar in Excel Easily