Is there a "jump to" command???
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?
|