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.

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


<reader.life@gmail.com> wrote in message
news:1150394625.755262.266420@r2g2000cwb.googlegroups.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.
>

The 'F2' key toggles you between 'sticky' edit and 'moving' edit.
HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"reader.life@gmail.com" 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.
>
>