Is there an easy way to locate the cells in Excel that contain a formula? Yes, there is!
Open the Go to-window (Ctrl+G) and click on Special. Choose the radio button Formulas:
Click OK, and all the cells that contain a formula are highlighted!
Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.