Referencing help
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
On Sep 18, 10:15*pm, NOLA help <NOLA
wrote:
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. *
|