how to keyboard navigate to other cells during editing formula, when arrow keys don't work

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.

When editing a cell, notice the bottom left area of the Status Bar.
If it displays "Enter"...you are able to select other cells with the arrow
keys.
If it displays "Edit"...you the arrow keys navigate within the formula.

To toggle between "Enter" and "Edit" mode...use the [F2] key

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"[email protected]" 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.
>
>