if your looking at a cell in spreed sheet and the data refering to it is
located in a different location on that page, or a different page. Is there a
way to jump to that location?

Does it have to be set up to work this way and how?

If you set up Excel to edit only in the formula bar, then double-clicking on
a cell with references to other cells moves the selection to the referenced
cells and make one of them the active cell.

Example:
A1: =D12+D18
Dbl-click A1....D12 and D18 are now selected (D12 is the active cell).

From the Excel Main Menu
<tools<optons<edit....UNcheck: Edit directly in cell

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"j5b9721" wrote in message
...
if your looking at a cell in spreed sheet and the data refering to it is
located in a different location on that page, or a different page. Is
there a
way to jump to that location?

Does it have to be set up to work this way and how?

You can also press the F5 key and enter the cell address you want and click
OK. HTH Otto
"Ron Coderre" wrote in message
...
If you set up Excel to edit only in the formula bar, then double-clicking
on a cell with references to other cells moves the selection to the
referenced cells and make one of them the active cell.

Example:
A1: =D12+D18
Dbl-click A1....D12 and D18 are now selected (D12 is the active cell).

From the Excel Main Menu
<tools<optons<edit....UNcheck: Edit directly in cell

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"j5b9721" wrote in message
...
if your looking at a cell in spreed sheet and the data refering to it is
located in a different location on that page, or a different page. Is
there a
way to jump to that location?

Does it have to be set up to work this way and how?

Hi Ron...
I'm only trying to move up or down the spread sheet to another location, not
editing any cells.

"Ron Coderre" wrote:

If you set up Excel to edit only in the formula bar, then double-clicking on
a cell with references to other cells moves the selection to the referenced
cells and make one of them the active cell.

Example:
A1: =D12+D18
Dbl-click A1....D12 and D18 are now selected (D12 is the active cell).

From the Excel Main Menu
<tools<optons<edit....UNcheck: Edit directly in cell

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"j5b9721" wrote in message
...
if your looking at a cell in spreed sheet and the data refering to it is
located in a different location on that page, or a different page. Is
there a
way to jump to that location?

Does it have to be set up to work this way and how?

Hi Otto...
I'm only trying to move up or down the spread sheet, not wanting to edit any
cells.

"Otto Moehrbach" wrote:

You can also press the F5 key and enter the cell address you want and click
OK. HTH Otto
"Ron Coderre" wrote in message
...
If you set up Excel to edit only in the formula bar, then double-clicking
on a cell with references to other cells moves the selection to the
referenced cells and make one of them the active cell.

Example:
A1: =D12+D18
Dbl-click A1....D12 and D18 are now selected (D12 is the active cell).

From the Excel Main Menu
<tools<optons<edit....UNcheck: Edit directly in cell

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"j5b9721" wrote in message
...
if your looking at a cell in spreed sheet and the data refering to it is
located in a different location on that page, or a different page. Is
there a
way to jump to that location?

Does it have to be set up to work this way and how?

You mis-understand what Otto is saying.

If you uncheck "Edit directly in cells" from ToolsOptionsEdit, when you
double-click on a cell with dependents, you will jump to the first of those
dependents and any other dependents will be highlighted.

Try this with the edit directly in cell unchecked.

In D32 enter =A1*B16

Double-click on D32 to see the "jump to" feature which will select A1 and
highlight B16.


Gord Dibben MS Excel MVP


On Sun, 23 Sep 2007 09:06:01 -0700, j5b9721
wrote:

Hi Otto...
I'm only trying to move up or down the spread sheet, not wanting to edit any
cells.

You can also "jump to" a precedent cell *without* losing the "edit in cell"
functionality.

Simply select the formula containing cell and
<Ctrl < [
to jump to those precedent cells.

ALSO,
<Ctrl < ]
to jump *back* to the dependent cell.


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You mis-understand what Otto is saying.

If you uncheck "Edit directly in cells" from ToolsOptionsEdit, when you
double-click on a cell with dependents, you will jump to the first of
those
dependents and any other dependents will be highlighted.

Try this with the edit directly in cell unchecked.

In D32 enter =A1*B16

Double-click on D32 to see the "jump to" feature which will select A1 and
highlight B16.


Gord Dibben MS Excel MVP


On Sun, 23 Sep 2007 09:06:01 -0700, j5b9721

wrote:

Hi Otto...
I'm only trying to move up or down the spread sheet, not wanting to edit
any
cells.