Is there a "jump to" command???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You can also press the F5 key and enter the cell address you want and click
OK. HTH Otto
 
Hi Ron...
I'm only trying to move up or down the spread sheet to another location, not
editing any cells.
 
Hi Otto...
I'm only trying to move up or down the spread sheet, not wanting to edit any
cells.
 
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
 
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.
 
Back
Top