View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Luis
 
Posts: n/a
Default how to keyboard select cells for a formula if arrow keys don't wo

Steven,
Try putting the cursor in the spot where you want to add the cell, then
CLICK the cell you want to put with the mouse and it should show up in the
formula cell. Hope it helps.
Luis

"Steven" 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.