displyaing the referenced cells ?

[Romain Jouin]

Hi everyone !
Working on an excel file full of references, it would be very useful
to be able to make the display to jump directly to the cells
referenced by the active cells I currently see.
So if my cell TU789 reference the cell JI890, I don't want to search
for JI 890, but would like excel to automatically show me this cell.
Do you know if it is possible ?
Is there a shortcut for that ?
Thanks,
JR.

 

[Pete_UK]

It would be difficult to do that generically, as the cell could
contain a formula that references several other cells - which one
should be chosen in this case?

You might think about using a hyperlink formula (say in the top row of
your sheet with Freeze Panes set) and then in the cell next to it you
could enter the cell ref and then just click on the hyperlink to go
there.

Hope this helps.

Pete

 

[Mike Middleton]

Romain Jouin or JR -

Maybe the formula auditing tools will help:

In Excel 2003 and earlier, choose Tools | Formula Auditing | Trace
Precedents.

In Excel 2007, choose Formulas | (Formula Auditing) Trace Precedents.

- Mike

http://www.MikeMiddleton.com

 

[Romain Jouin]

It would be difficult to do that generically, as the cell could
contain a formula that references several other cells - which one
should be chosen in this case?

You might think about using a hyperlink formula (say in the top row of
your sheet with Freeze Panes set) and then in the cell next to it you
could enter the cell ref and then just click on the hyperlink to go
there.

Hope this helps.

Pete

Pete,
Thanks for your answer,
But I am not sure I got all the idea : are you suggesting to make a
dynamical hyperlink cell ? I never saw that, which vb function would
allow that ?
If you may develop, it is interesting.
Thanks again.
BR,
JR.

 

[Romain Jouin]

Mike,
Thanks for your idea.
The formula trace tool is since a long time a mystery for me as I
never could activate the arrow displayed on the screen to jump to the
pointed cell. I do see the arrow, but it is not reacting to any click.
Is there a trick to make it work ?
Thanks again,
JR.

 

[Shane Devenshire]

Hi,

With your cursor on the cell with the formula press Ctrl+[

When you are on the cell to which the formula refers you can get back by
pressing Ctrl+]

there are the keyboard equivalents to Trace Prescedents and Dependents

 

[Romain Jouin]

Hi,

With your cursor on the cell with the formula press Ctrl+[

When you are on the cell to which the formula refers you can get back by
pressing Ctrl+]

there are the keyboard equivalents to Trace Prescedents and Dependents

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

Mike,
Thanks for your idea.
The formula trace tool is since a long time a mystery for me as I
never could activate the arrow displayed on the screen to jump to the
pointed cell. I do see the arrow, but it is not reacting to any click.
Is there a trick to make it work ?
Thanks again,
JR.

strange : ctrl + [ work well, but ctrl + ] write down the current
date on the cell :s

 

[Romain Jouin]

I found a way :
1) ctrl + c => to copy the content of the cell
2) ctrl + g => go to
3) ctrl + v => paste the ref