Change Worksheet Tab Color in Excel

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

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
• Grouping Worksheets in Excel
• Adding Cell Borders in Excel 2007
• Add Shading to a Paragraph in Word
• Apply Cell Styles in Excel 2007
• Locking and Unlocking Cells in an Excel Worksheet
• Using Conditional Formatting in Excel 2007

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