Tools-Options
Edit Tab

Move selection after Enter....select direction

HTH,
Paul

--

"CGN Bear" <CGN wrote in message
...
In previous versions of EXCEL there was a way to change the direction of
the
cell movement (right, left, up, down) after entering data and pressing the
ENTER key. How is this done now?