• Blog
  • Excel Downloads
    • Audit Tickmark Toolbar
  • Courses
    • Power BI
  • Contact
  • Checkout

Excel Zoom

...because it's more than just a calculator


10 Excel Tips For Increased Productivity

July 4, 2014 by Mark 4 Comments

Excel Tip #2: Color Code Tabs

Excel Tip Tab ColorIn especially large Excel files with many, many tabs it might be useful to color code the tabs so you can easily find related spreadsheets.

To color code your Excel tabs:

  1. Right click on the tab you want to add color to.
  2. Select Tab Color from the menu.
  3. Click the color you want to use from the color pallet that pops up.

This is a nice way to group related income or expense tabs, or to keep last year’s spreadsheets in one color with this year’s data a different color.

Tip: You can highlight multiple tabs and apply the same color to all of them at once by using CTRL+Click on each non-consecutive tab, or Shift+Click for a group of tabs that are all next to each other.

Pages: 1 2 3 4 5 6 7 8 9 10 11

Filed Under: Tips Tagged With: Automatic, Cell, Formats, Shortcuts, Tips

Looking For More Help?

Contact us with any specific questions or feedback. We love to hear from you!

Recommend a new product and EARN! Contact us here for info

Need to level up your career? See our amazing Excel Courses here

Looking for the Excel Audit Tickmark Toolbar? Click Here, NOW ONLY $97!

Subscribe to our mailing list
  • Facebook
  • Twitter

Search this site…

Power BI Webinar
Power BI Course
Free Excel Dashboard Webinar

Copyright © 2025 · Magazine Pro Theme on Genesis Framework

Login Form

Lost your password?