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

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

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

JerryJuice wrote:

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

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!
================================================== ===

"Dave Peterson" wrote in message
...
You have to make sure you have
tools|options|edit tab|"edit directly in cell" unchecked

JerryJuice wrote:

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