If you are on Excel 2007 or above, run this code from a sub-routine, or immediate window

Code:
Application.MoveAfterReturnDirection = xlToRight
OR

Go to Excel Options >> Advanced >> Editing Options >> Ensure the 'After pressing Enter, move selection' is checked >> Select 'Right' in the drop-down below.