How To Change Sheet Tab Color In Excel 2010

by on
2

It would be great to assign colors to sheet tab in Excel workbook to differentiate each worksheet visually. By default Excel 2010 assigns white color to active & blue to inactive sheet tab. This post covers applying colors to worksheets tabs.

54d1273428131-how-change-sheets-tab-color-excel-

For changing tab color, head over to Home tab and from Cells group, open Format options, under Tab Color sub-menu, select a tab color.


52d1273428130-how-change-sheets-tab-color-excel-

Now the sheet tab color is changed. Repeat the procedure for coloring other sheet tabs as well.

53d1273428130-how-change-sheets-tab-color-excel-

Advertisement
  • jb

    If the worksheet tab color option is grayed outed, Why is it grayed out and how can I get the tab color option operational?

  • merdce

    No need to such a long way to change tab color. Just right click on tab name, the same options will apeear (you’ll see ‘tab colors’) and you could change it more easily.