Home Excel Tips and Tricks Display Cells Containing Formulas

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”.

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:

Further reading: 
Basic concepts 
Getting started with Excel
Cell References