Display Cells Containing Formulas

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

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:

  • Comments
  • Conditional Formatting
  • Constans
  • Data Validation