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

R

reader.life

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to keyboard select cells for a formula if arrow keys don't wo 3
how to select cells with keyboard if the arrows don't let you go out of the formula 2
Editing conditional formatting formula, arrow keys insert range. 6
Cannot navigate between cells using arrow keys 2
Not able to navigate between cells using keyboard arrow 1
in excel - arrow keys won't work & cursor will not select a cell 4
How do I move to other cells in spreadsheet using up down arrow? 2
Problem when navigating between cells 2

Top