How to enable double-clicking to goto the cell a formula refers t.

E

Elaine Ray

I'm using Excel 2002 on Windows XP and since getting a new laptop, when I
double-click on a cell containing a formula, it no longer takes me to the
cell which the formula refers to.

Any ideas?
 
G

Gord Dibben

Elaine

Tools>Options>Edit. Uncheck "edit directly in cell".

Gord Dibben Excel MVP


On Fri, 5 Nov 2004 06:03:02 -0800, "Elaine Ray" <Elaine
 
D

Dave Peterson

When you double click on the cell, does it look like excel expects you to start
editing that cell?

If yes, then turn off "edit directly in cell"

You can find that option under: Tools|Options|Edit tab.
 
Top