This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2007 - Colored Worksheet Tabs

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.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2007 - Colored Worksheet Tabs.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.