Change the Cursor Direction in Excel for Windows
By default, Microsoft Excel automatically moves the active cell highlight, or cell cursor, down one cell when you press the Enter key on the keyboard. This is a default setting because this is how most users input data. However, you may prefer your cursor to move to the right, left, or up when you enter data. You may even prefer that it not move at all.
It’s easy to change the cursor’s movement direction in Excel for Windows.
Open Excel. Select the File tab of the ribbon to open the File menu. Select Options in the menu to open Excel Options. Select Advanced in the left pane of the dialog box. In the Editing Options section, go to After pressing Enter, move selection in the right pane. Select the down arrow next to Direction and choose up, left, or right. To have the cell cursor remain on the same cell, remove the check mark from the box next to After pressing Enter, move selection. Select OK to save your changes. The Excel cursor direction is now changed.
Change the Cursor Direction in Excel for Mac
Changing the Excel cursor direction is similar on the Mac.
Open Excel. Select the Excel menu option. Select Preferences in the menu to open Excel Preferences. Select the Edit option. In the Editing Options section, go to After pressing Enter, move selection in the right pane. Select the down arrow next to Direction and choose up, right, or left. To have the cell cursor remain on the same cell, remove the check mark from the box next to After pressing Return, move selection. Select OK to save your changes. Your Excel cursor direction is now changed.
