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.

excel find cells that have a formula

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").

excel excel find cells that have a formula

b) In the "Go To Special" dialog box, click on "Formulas", click OK.

excel excel excel find cells that have a formula

c) All the cells with "Formulas" are selected / highlighted as shown below.

excel excel excel excel find cells that have a formula

 

You can find similar Excel Questions and Answer hereunder

1) How can I identify the cells that influence a particular cell to help with debugging of my spreadSheet or understand a spreadSheet that I inherited?

2) How can I enter information in multiple cells simultaneously?

3) One of my formulas has returned an error - how can I trace the error to fix it?

4) Find and count instances of a character in a string in Excel

5) I have a cell with nested formulas that returns an error. In Excel, how can I step through the formulas to help with debugging?

6) How can I identify all cells with Data Validation in my WorkSheet?

7) Given a raw data Table, how can I find the value of a field for a specific value of another field?

8) Formula does not calculate in Excel

9) How do I use Find to determine last occurrence of a string in a WorkSheet range using VBA?

10) I have read that Merging cells should be avoided if possible. In Excel, how can I then make my Title appear in the center of my Data Table?

11) How can I identify all cells with Conditional Formatting in my WorkSheet?

12) How can I sort data using multiple criteria?

13) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

14) How do I add a symbol like Triangle / Inverted Triangle for indicating trends in a cell using VBA?

15) How do i apply a formula to an entire column in Excel