Check out font colors with the Cycle Font Color button in Excel

Using colors in Excel just got easier! Skip steps, save clicks and get chromatic! Mary Ann Richardson shows us how to use this easy Excel tool.

When you're working in Excel and not sure what color font you should use, you could click on the font color tool and then click on one of the colors to see how it looks on a selected cell. This can become quite tedious, as you have to click twice to view each different color till you come up with the right one.

One solution is to drag the Font Color box off the toolbar so that it floats and you only need to click the color. Or, you can add the Cycle Font Color button to your toolbar—it will let you cycle through each color until you come up with one you like. To add the Cycle font Color button to your formatting toolbar, follow these steps:

  1. Go to Tools | Customize
  2. Click the Command tab.
  3. Select Format under Category.
  4. Select Cycle Font Color under Commands and drag it to your Formatting toolbar.
  5. Click close.

Now you can click this button to see how each color looks with your selected text.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox