View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mariano
 
Posts: n/a
Default 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?