My question is two-fold:
If I have a formula driven cell (i.e. the cell syntax in A1 looks as follows
"=F32") I can double-click A1 to have the selector move to F32. How do I turn
this dunctionon an off?
What is the keyboard shortcut for the double-click? (NB - not the shortcut
for editing, I know its F2).

Any help appreciated.

You can turn this off by turning on:
tools|Options|Edit tab|Check Edit Directly in Cell

And I _think_ that this may answer your second question.



Willem wrote:

My question is two-fold:
If I have a formula driven cell (i.e. the cell syntax in A1 looks as follows
"=F32") I can double-click A1 to have the selector move to F32. How do I turn
this dunctionon an off?
What is the keyboard shortcut for the double-click? (NB - not the shortcut
for editing, I know its F2).

Any help appreciated.

--

Dave Peterson

Willem

To turn off the selection of referenced cells go to ToolsOptionsEdit and
checkmark "edit directly in cell".

Can't think of a keyboard shortcut for d-click.


Gord Dibben MS Excel MVP

On Sun, 11 Jun 2006 23:15:01 -0700, Willem
wrote:

My question is two-fold:
If I have a formula driven cell (i.e. the cell syntax in A1 looks as follows
"=F32") I can double-click A1 to have the selector move to F32. How do I turn
this dunctionon an off?
What is the keyboard shortcut for the double-click? (NB - not the shortcut
for editing, I know its F2).

Any help appreciated.