Referencing help

[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.

 

[Pete_UK]

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

 

[Gord Dibben]

Select A1

Tools>Formula Auditing>Trace Dependents.


Gord Dibben MS Excel MVP

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