Highlighting linked columns

[Guest]

A co-worker asked me this:
when you are linking within the same doc but on diff tabs and you want the
cursor to highlight the column you linked it to - how would you do that?

 

[Dave Peterson]

Maybe this is close.

I can do this in xl2002:
Tools|formula auditing|trace precedents

then double click on that arrow near the tiny worksheet icon. You'll see the
Edit|goto dialog. Select the range you want and hit ok.

I'm not sure where this is hidden on earlier versions.

 

[Norman Jones]

Maybe this is close.

I can do this in xl2002:
Tools|formula auditing|trace precedents

then double click on that arrow near the tiny worksheet icon. You'll see
the
Edit|goto dialog. Select the range you want and hit ok.

I'm not sure where this is hidden on earlier versions.

For xl2k, very similar:

Tools | Auditing | Trace Precedents

 

[Dave Peterson]

Thanks.

For xl2k, very similar:

Tools | Auditing | Trace Precedents