View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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. *