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:
- Conditional Formatting
- Data Validation