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