How to Display Formulas in Excel

In this lesson you will learn interesting trick, how to display cells that contain formulas.


To select all the formulas at once, click the "Home" tab and then "Find and Select" -> "Formulas".

Find And Select Formulas

The result

After selecting this option Excel will select all cells containing the formulas.

Excel find and select formulas

Now you can choose one of the options fill the cells to always know where the formulas are.

Also in the same way you can find and select cells which contains:

Conditional formatting

In Excel, you can also highlight cells that contain formulas by using conditional formatting. Here's how:

  1. Select the range of cells that you want to check for formulas.
  2. Go to Home > Conditional Formatting > Highlight Cells Rules > More Rules.
  3. In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format".
  4. Enter the formula =ISTEXT(A1) (replace A1 with the first cell in your selected range).
  5. Select a formatting style and click "OK".

The cells containing formulas will now be highlighted with the selected formatting style.