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

Microsoft Excel 2003 Visual Tweaks - Change the Color of a Worksheet Tab

Manipulating a spreadsheet workbook with many worksheets and having trouble finding the correct worksheet when you need it? You can change the color of individual worksheet tabs to make them stand out from the rest. For example, you could make Accounts Payable the color red, Accounts Receivable the color green, Profits the color black, etc. Just right-click on a tab in the tabsheet at the bottom of the current worksheet and select "Tab color". Then select a desired color from the palette and click "OK".

Note that the currently selected tab will always show a default color, but the tab will have a colored line underneath. Then, when you switch to a different tab, the previous tab will fully display in your chosen color.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Visual Tweaks - Change the Color of a Worksheet Tab.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.