Is there a "jump to" command???

J

j5b9721

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?
 
R

Ron Coderre

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)
 
O

Otto Moehrbach

You can also press the F5 key and enter the cell address you want and click
OK. HTH Otto
 
J

j5b9721

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

j5b9721

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

Gord Dibben

You mis-understand what Otto is saying.

If you uncheck "Edit directly in cells" from Tools>Options>Edit, 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
 
R

Ragdyer

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.
 
Top