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.