How to change the selection direction in Excel 2013 when pressing Enter

By default Excel moves the active marker down when you hit Enter. If you for some reason want to change this you can easily do that.

This can be useful if your data is structured horizontally (or any other direction).

Go to 'File' and select 'Options'. Go to the 'Advanced' tab and under 'Editing options' you can find a checkbox for 'After pressing Enter, move selection' and a drop down menu where you can select your desired direction.

If the checkbox is unchecked it will stay in the same cell when you press Enter. Select between:

• Down
• Right
• Up
• Left