Referencing help

  • Thread starter Thread starter NOLA help
  • Start date Start date
N

NOLA help

Im trying to determine a way that I can see all of the cells that reference
another cell. Similar to F2, in that it shows all of the cell which are
components to a cell's function, however, in "reverse" of sorts.... For
instance, cell B2, C2 and C3 all reference cell A1 in their functions. I
want to click on A1 and see then be pointed to the refering 3 cells.

Essentially, im want to change some values for some components of a sheet,
however, Im concerned that I dont know all of the other cells which rely on
those values and want to be able to locate and double check them all.

Help me. Please.
 
Perhaps you could enter:

=NA()

in A1, and then you will see #N/A in those dependent cells (as well as
any that are dependent on those).

Hope this helps.

Pete
 
Select A1

Tools>Formula Auditing>Trace Dependents.


Gord Dibben MS Excel MVP

On Fri, 18 Sep 2009 14:15:01 -0700, NOLA help <NOLA
 
Back
Top