find cells that have a formula in Excel
Q101. I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?
Note: This would be very helpful if you have inherited a complex WorkSheet and want to understand how the WorkSheet has been set up.
For example, in the table below, I would like to quickly identify the cells that have formulas.
To do it in Excel, here is the answer:
a) Press F5 and in the "Go To" dialog that pops up, click on "Special" (Alternatively, click on "Find & Select" under "Home". Click on "Go To Special").
b) In the "Go To Special" dialog box, click on "Formulas", click OK.
c) All the cells with "Formulas" are selected / highlighted as shown below.