Excel search for cell references in formulas

excel search excel-2003 worksheet-function
CFNinja picture CFNinja · Aug 22, 2011 · Viewed 30.1k times · Source

I inherited a big model and have been trying to reverse engineer some of the formulas. There are a lot of fields. I am not sure if everyone of them is necessary.

Is it possible to search an Excel document (with 5 worksheets) to find if say, AZ12 is used in any formula? Or $AZ12 or $AZ$12?

Answer

CFNinja picture CFNinja · Aug 22, 2011

Tools > Formula Auditing > Trace Precedents or Trace Dependents (Excel 2003)

Formulas > Trace Precedents or Trace Dependent (Excel 2010)

Related questions

Excel: Search for a list of strings within a particular string using array formulas?

I want to search a cell for a list of words. I thought this would work as an array formula: {=FIND(<list of words I want to search for>,<cell I want to search>)} But it …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More