sCycling Through Colors in MS Excel


excel logo

There is a tool in MS Excel that allows you to cycle through the font colors available to you, however, it is little known because it is not readily available to you.

Follow the steps below to add the tool so that it is available to you:

  1. In the Excel Options dialog box, click the Office button (in version 2007) and then click Excel Options. In Version 2010, click on File | Options.
  2. Click the Customize option (2007) or Quick Access Toolbar option (2010) at the left side of the dialog box.
  3. In the Choose Commands From drop-down, select All Commands.
  4. In the list of commands, click on Cycle Font Colors to select it.
  5. Click the Add button and it will be copied to the right-hand side of the dialog box.
  6. Click OK.

The Cycle Font Colors tool will now be available to you on your Quick Access toolbar (QAT).

Now, all you have to do is click on the Cycle Font Color tool and the font color in your selected cells will change accordingly. Click again, and the color will change again.

About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol’s Corner Office or follow Carol on FaceBook and Twitter.