How to change curser movement upon pressing enter (left or right) instead of down

Copper Contributor

Just updated to Microsoft 365 from office 1997.  Previously when I entered data in a cell and pressed "enter" the cursor would move to the right.  Now, the cursor moves down instead.


Where can I change the direction upon hitting enter?

2 Replies


Select File > Options.

Select Advanced in the navigation pane on the left hand side.

Make sure that the check box 'After pressing Enter, move selection' is ticked.

Select Right from the drop-down below it.

Click OK.