Determine if a cell (value) is used in any formula

excel formula
Jake picture Jake · Mar 24, 2011 · Viewed 173.5k times · Source

I am trying to reverse engineer an ancient program written using VBA in excel and formulas in cells. There are many cells with values scattered across everywhere. Is there a fast way to check if a cell (value) is being used in another cell's forumla; or if the cell is just sitting there doing nothing so that I can delete/igonore it safely? Thanks in advance.

I used the Ctrl+F find tool and it seems like it does work, but I just want to be sure if there is another better way.

Answer

Benjamim picture Benjamim · Jul 19, 2012

On Excel 2010 try this:

  1. select the cell you want to check if is used somewhere in a formula;
  2. Formulas -> Trace Dependents (on Formula Auditing menu)

Related questions

How to turn a string formula into a "real" formula

I have 0,4*A1 in a cell (as a string). How can convert this "string formula" into a real formula and calculate its value, in another cell?

Read More
Fill formula down till last row in column

I'm trying to draw down the formula that's in cell M3 to the end of the data set. I'm using column L as my base to determine the last cell with data. My formula is a concatenation of two cells …

Read More
Using OR & AND in COUNTIFS

I would like to include an "AND" condition for one of the conditions I have in my COUNTIFS clause. Something like this: =COUNTIFS(A1:A196;{"Yes"or "NO"};J1:J196;"Agree") So, it should return the number of rows where: (…

Read More