How to change the cell moving direction when pressing Enter button

When you press the Enter key in Microsoft Excel, the cell pointer automatically shifts one cell down.
The steps listed below can be used to alter this behavior.
When you want the cursor to travel to the right because your spreadsheet is more horizontal than vertical, changing the orientation is advantageous.

Microsoft Excel 2007 and newer

1. Open Excel.
2. Select Options from the File menu.
3. Change the Direction under Advanced by clicking Advanced in the Advanced Windows.
4. Change After pressing Enter, move selection.

When you press Enter after doing the aforementioned steps, the pointer will travel in the desired direction.

Microsoft Excel 2003 and older

1. Launch Excel.
2. Click Options after selecting Tools.
3. Change the Move selection after Enter setting by selecting the Edit tab in the Options box, as shown below.
4. Click Ok after changing the direction from down to right, up, or left.

When you press Enter after doing the aforementioned steps, the pointer will travel in the desired direction.