View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Is there a "jump to" command???

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.