how to select cells with keyboard if the arrows don't let you go out of the formula
 

Hi,

I've got a problem using keyboard to select cells when editing some "
sticky" formula. By "sticky", I mean when the arrows don't move you out
of the cell you are editing.

I found this problem does not exist when starting a new formula, where
you can use arrow keys to select other cells. It is a problem for
editing existing formula.

For example, when you return to re-edit an existing formula like the
MIN, once you insert the cursor there, the arrow keys only moves within
the cell rather than allowing you to select other cells needed to
complete the formula.

how to select cells with keyboard if the arrows don't let you go out of the formula
 

Press F2 when editing formula - it takes practice to get it right
Why not just pull the 'range finder' borders?
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


wrote in message
ups.com...
Hi,

I've got a problem using keyboard to select cells when editing some "
sticky" formula. By "sticky", I mean when the arrows don't move you out
of the cell you are editing.

I found this problem does not exist when starting a new formula, where
you can use arrow keys to select other cells. It is a problem for
editing existing formula.

For example, when you return to re-edit an existing formula like the
MIN, once you insert the cursor there, the arrow keys only moves within
the cell rather than allowing you to select other cells needed to
complete the formula.

how to select cells with keyboard if the arrows don't let you go o
 

The 'F2' key toggles you between 'sticky' edit and 'moving' edit.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


" wrote:

Hi,

I've got a problem using keyboard to select cells when editing some "
sticky" formula. By "sticky", I mean when the arrows don't move you out
of the cell you are editing.

I found this problem does not exist when starting a new formula, where
you can use arrow keys to select other cells. It is a problem for
editing existing formula.

For example, when you return to re-edit an existing formula like the
MIN, once you insert the cursor there, the arrow keys only moves within
the cell rather than allowing you to select other cells needed to
complete the formula.