Find cells that have a formula in Excel

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 find cells that have a formula

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

excel find cells that have a formula

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

excel find cells that have a formula


You can find similar Excel Questions and Answer hereunder

1) How do I enter a formula in a cell using VBA (using Absolute Reference)?

2) How can I identify cells with Circular Reference in a WorkSheet?

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

4) I am a construction Engineer. Considering a room with dimension, 14ft x 12ft can I find the side of the largest square tile which can tile the room?

5) How can I clear all formats (formats alone not data) from a range of cells?

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

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

8) Formula converts date to quarter and year in Excel

9) Formula does not calculate in Excel

10) how to combine the content of two or more cells in Excel


Here the previous and next chapter