View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default change direction when pressing enter

Shift+Enter will change active cell to one above (assuming default is one
below)

If only 1 cell is selected, Ctrl+Enter will not move active cell (if
multiple cells are selected and you press Ctrl+Enter, the value inputed into
active cell will be applied to all cells within selection).

And of course, Tab & Shift+Tab move cell to right/left.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"RickMoore" wrote:

Is there a keyboard shortcut that changes the direction of the move when
pressing enter? I know how to do it in excel options, but I was wondering if
there was a shortcut.
--
Rick