Possibility of giving color to different tab in latest version of Excel

Asked By 0 points N/A Posted on -
qa-featured

It was possible to give different color to every tab in Excel 2003 and Excel X. Does the latest version give this option? 

SHARE
Answered By 20 points N/A #108762

Possibility of giving color to different tab in latest version of Excel

qa-featured

Hello Gaynor Marise,

For sure you can give different color to every tab in the later versions excel. For excel 2007, use the following procedure:

To change the tab color of a single worksheet, use the following procedure:

  1. Locate the tab of the worksheet that you want to change the color by clicking on the drop down menu and then right click on the tab.
     
  2. Thereafter you will select Tab Color from menu list so as to open the color palette.
     
  3. You will then pick a color for the worksheet tab, but if you don not find just click More Colors which is at the bottom of the color palette so as to open the Custom Color Palette.

  

To change the tab color of multiple worksheets, use the following procedure:

In this case, of the selected worksheet tabs will be the same color.

  1. If you want to select more than one worksheet tab, you will need to hold down the CTRL key on the keyboard and then you will click on each tab.
     
  2. Thereafter you will right click on one of the selected worksheet tabs so as to open the drop down menu.
     
  3. You will then select the Tab Color from the menu list so as to open the color palette.
     
  4. You will then pick a color for the worksheet tab from the palette.Use  More Colors at the bottom of the color palette if you do not find the color you want.

__

Regards
Mahesh Babu

Related Questions