USING EDIT FIND to locate cell references

R

Ron Wilson

If I put various cell references inside a formula, is there an easy wa
to find the reference without going into each and every cell. Fo
example if cell C6 is "=IF(ISERROR(T9/Q9),"",T9/Q9)" and I want to fin
all references to T9 can I somehow convert cell C6 to be say the text o
the formula and then do a Edit Find on all cells in the worksheet?
I hope that i explained myself. Thanks
 
R

RagDyer

I don't quite follow you, but does this help:

Select T9, then,
<Tools> <Auditing> <Trace Dependents>
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
R

Ron Wilson

RagDyer said:
I don't quite follow you, but does this help:

Select T9, then,
<Tools> <Auditing> <Trace Dependents>
--
HTH,

RD
That helps if we are in the same worksheet. What if we are referencin
a cell in a different file
Click to expand...
 
R

RagDyer

It'll *still* take you there also, as long as the file is open.

Don't you get a arrow pointing to a WS icon?

Hover your cursor to where the arrow meets the icon.
When the cursor changes from a cross to an arrow, *Double* click.

This gives you a "Go To" dialog window, showing *all* the dependent
locations.
You'll notice the focus is in the *empty* "reference" box.
Simply click on one of the locations in the "Go To" window, which enters
that location into the reference box.
Just click <OK>, and you'll be taken to that cell location.

Once you're there, you can create a "precedent" link, to take you back to
where you came from.

Actually, you could "jump" all over the place, once you've established the
links.

Another thought.
If you *start* with the formula cell, and say the *first* precedent cell
reference in that formula is in a closed WB, this will take you to that
first cell, no matter where it is, opened or closed file, same drive or even
a network drive:

<Ctrl> < [ >


--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Top