displyaing the referenced cells ?

  • Thread starter Thread starter Romain Jouin
  • Start date Start date
R

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.
 
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
 
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
 
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
Click to expand...

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.
 
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.
 
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
 
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

Romain Jouin said:
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.
Click to expand...
Click to expand...

strange : ctrl + [ work well, but ctrl + ] write down the current
date on the cell :s
 
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
 
Back
Top