Menu

Change Worksheet Tab Color in 4-Ways in MS-Excel

0 Comments

Change Worksheet Tab Color in 4-Ways:

There are several ways to change the worksheet tab color by using the shortcut keys or other commands in excel. So, do one of the following methods.

Method-1

  1. Right click on the “Sheet tab, which appears at the bottom right corner of the excel workbook as given in the picture below.
  2. Then move your cursor on the “Tab color”, and then immediately a Color dialogue box appears
  3. Now you can select one of the Theme Colors or Standard Colors you want
  4. If you want remove the Color of a Sheet tab, Select “No Color”.

Method-2

  1. Go to the Home tab
  2. Then click on the drop-down arrow of the Format in the Cells group
  3. Afterwards, move your cursor on the “Tab color”, and then immediately a Color dialogue box appears
  4. Now you can select one of the Theme Colors or Standard Colors you want
  5. Look at the 5th step of a picture below.
  6. If you want remove the Color of a Sheet tab, Select “No Color”.

Method-3

Change All Sheet Tab Color at a Time:​

  1. To change all the Sheet tab color at a time, Right click on the “Sheet tab, which appears at the bottom right corner of the excel workbook as given in the picture below.
  2. Then click “Select All Sheets

3. Again, right click on the “Sheet tab

4. Then move your cursor on the “Tab color”, and then immediately a Color dialogue box appears

5. Now you can select one of the Theme Colors or Standard Colors you want

Remove All Sheet Tab Color at a Time:

  1. If you want remove the color of all the sheet tabs at a time, do the following.
  2. Right click on the “Sheet tab
  3. After that, click the “Select All Sheets

3. Again, right click on the “Sheet tab,

4. Now if you move the cursor on the “Tab color”, immediately a Color dialogue box appears

5. Finally, Select “No Color”.

Method-4

This is the last method on Change Worksheet Tab Color in 4-Ways

  1. Press Alt + H → O → T, and Select one of the Theme Colors or Standard Colors you want.
JOIN OUR NEWSLETTER
I agree to have my personal information transfered to MailChimp ( more information )
Join over 3.000 visitors who are receiving our newsletter.
We hate spam. Your email address will not be sold or shared with anyone else.

Leave a Reply

Your email address will not be published. Required fields are marked *