View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NOLA help NOLA help is offline
external usenet poster
 
Posts: 1
Default Referencing 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.