Colored Worksheet Tabs

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.

comments powered by HyperComments
READ  Toggle Row and Column Headings