Highlight Cells in Excel that Contain a Formula

Is there an easy way to locate the cells in Excel that contain a formula? Yes, there is!

Open the Go to-window (Ctrl+G) and click on Special. Choose the radio button Formulas:


Click OK, and all the cells that contain a formula are highlighted!


Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.

Did you enjoy this article? Get free email updates! Enter your email address here:

Delivered by FeedBurner

Clip to Evernote

Leave a Reply

Your email address will not be published. Required fields are marked *

8 − = zero

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>