Change Worksheet Tab Color in Excel

Excel provides the option of applying colors to your worksheet tabs.  This can be useful if you have a large workbook comprised of many worksheets.  You might want to give each worksheet in a particular group a different color.  The tab color only appears when the worksheet is not the active worksheet.

To Change the Worksheet Tab Color

1. Select the tab of the worksheet or worksheets to which you wish to apply a color.
2. Click the Format button on the Home Ribbon under the Cells group and choose Tab Color under the Organize Sheets category.

Or

1. Right-click on the tab for the worksheet or worksheet group and then choose Tab Color from the contextual menu.
2. Choose a color from the Format Tab Color Palette.

To Remove a Tab Color

1. Select the tab of the worksheet or worksheets whose color you wish to remove.
2. Click the Format button on the Home Ribbon under the Cells group and choose Tab Color under the Organize Sheets category.

Or

1. Right-click on the tab of the worksheet or worksheet group and then choose Tab Color from the pop-up menu.
2. Choose No Color from the Format Tab Color Palette.

Similar Posts:

• Apply Colors and Shading to Cells in Excel 2007
• Adding Cell Borders in Excel 2007
• Easily Move or Copy a Worksheet in Excel
• Add Shading to a Paragraph in Word
• Grouping Worksheets in Excel
• Locking and Unlocking Cells in an Excel Worksheet
• Apply Cell Styles in Excel 2007

Tagged as: Excel Tips, Microsoft Office Tips, Tab Color