View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default 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.