Summary: Customize your Excel 2007 spreadsheet’s worksheet tabs with colors.
If you are designing a large Microsoft Excel 2007 spreadsheet with multiple worksheets, it may prove useful to customize the tab bar by giving each worksheet a different color.
For example, in a large spreadsheet containing multiple years’ worth of financial information, you could highlight each year’s Accounts Payable in red and Accounts Receivable in green, making them easier to find.
Sample colored sheet tab bar in Excel 2007
Via the Ribbon:
1. Click the “Home” tab.
2. In the “Cells” group, click the “Format” pull-down.
3. Underneath “Organize Sheets”, click “Tab Color”.
4. Choose your desired color from the current theme, standard color, a “Colors” dialog box via “More Colors”, or remove any existing color by clicking “No Color”.
Changing the color of a worksheet tab in Excel 2007 to red via the ribbon
Via the worksheet tabs:
1. Right-click a worksheet tab and select “Tab Color”.
2. Choose your desired color from the current theme, standard color, a “Colors” dialog box via “More Colors”, or remove any existing color by clicking “No Color”.
Changing the color of a worksheet tab in Excel 2007 to tan via right-clicking a worksheet tab
Two notes:
* When coloring and selecting sheet tabs, the selected tab will appear in white (default color scheme), underlined with the tab’s current color.
* With the default color scheme, you may find that lighter-colored sheet tabs prove to be more readable.