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

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

Bernard Liengme

Press F2 when editing formula - it takes practice to get it right
Why not just pull the 'range finder' borders?
best wishes
 

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 keyboard navigate to other cells during editing formula, when arrow keys don't work 1
Re: Convert Array Formulas to Regular Formulas 0
how to scroll while in formula bar (Excel 2007) 0
how to edit formula without changing formula of each cell 2
Formula To Keep Certain Cells Blank 5
Formula results don't change when it's pasted/dragged into a new c 2
How to use the Stop If True Condition for highlight cells 1

Top