How do I double click a cell and jump to cell's referenced cell

[Guest]

Hi,

Someone once showed me how if you have a a reference to a cell in one sheet
you could double click on the cell and it would jump to the referenced cell
in the reference cell's sheet.

For example.

Cell With Reference Referenced Cell in other
Sheet
A1 <--double click sheet1 cell A1 takes you to --> =Sheet2!A1

 

[Dave Peterson]

You have to make sure you have
tools|options|edit tab|"edit directly in cell" unchecked

 

[RagDyeR]

In addition to what Dave said, you could keep the "Edit In Cell" option in
force, and *still* jump to the referenced cell by using a keyboard shortcut.

<Ctrl> < [ > will take you to the referenced cell(s) of the cell in focus,
And if that cell happens to be on the same sheet,
<Ctrl> < ] > will return you to the original cell.
--

HTH,

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

You have to make sure you have
tools|options|edit tab|"edit directly in cell" unchecked