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

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

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.

Thanks so much.