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?