Report Offensive Message

Hi Mary Ann -

Thank you for this post and for the VBA Code!

When I teach an Excel Class, I always demonstrate several ways to Show / Highlight the cells that contain formulas.

I use the Ctrl+ ~ Keyboard Shortcut so that you can actually see each formula in the worksheet. This is a "Toggle" so it is easy to restore the normal view of the worksheet.

When I want to demonstrate how easy it is to have "hard-coded values" in a cell that should contain a Formula, I use Edit - Go To (or Ctrl+G or F5) and then select Special - Formulas (or Constants)

Highlighting the Formulas in a worksheet is a great way to have them selected and then apply either formatting of a Cell Style.

If you want to watch a short video on this topic, here is the link to the one that I created:

http://www.thecompanyrocks.com/excels/2008/07/how-to-reveal-the-formulas-in-all-cells/

Thanks again!

Danny Rocks
www.thecompanyrocks.com