Use Colors to Organize Excel Tabs

Steps to Add Color to Tabs and Organize Them

1. Right-click the desired tab:
   
2. Go to Tab Color and then select the desired color:
   
3. The key is to make groupings of colored tabs so that it is easy to navigate large workbooks. You can re-organize tabs by holding the left-click button over a tab and then moving it around:
   

Now it is easy to see which data set is which and this will make it much easier for you to use this workbook.  Just make sure not to use colors that will annoy you later, such as bright yellow.

This is a simple tip but trust me when I say that it will make your life easier.  Download the accompanying workbook to see these colored tabs in action.