Home Excel Tips and Tricks Excel Formulas Display: Data Insight

Excel Formulas Display: Data Insight

129

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.

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