Quick view of Cell References??
BTW, I thought Trace Dependents would work, however the arrows weren't to
helpful, and it looks like it only traces on the current active worksheet, I
need one to go across all worksheets.
A list would be a lot easier to use then arrows.
"Mariano" wrote:
Is there a way to get a quick view of all the cells that have a formula that
reference a particular cell?
For example-
If Sheet2!B3 is being used in 10 different formulas in 10 different cells,
can I see that without manually checking?
|