How To Make The Enter Key Make Cell Selection Move To Right In Excel

[papabill]

I'm sorry to keep asking such seemingly simple questions, but this one has caused me several days of hunting without finding an answer.

How do I set the spreadsheet to go to the cell on the right (like writing-left to right) when I enter a value and hit enter or tab? I have worn out the F1 key trying to ask the question, but nothing I enter gives me an answer.

Thanks

[Excel Fox]

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


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.

[papabill]

Thanks so much.