- Make it move up, right or left, not down
- Change cursor direction in Excel
- Excel for Windows:
- Office for Mac:
- Using a tab and entering keys when entering data
Make it move up, right or left, not down
By default, Excel automatically moves the selection of the active cell, or cell cursor down one cell when you press a key Enter on keyboard. In Excel, this option is set by default to make data entry easier, as it is the most common way for users to enter data.
These instructions apply to Excel 2019, 2016, 2013, 2010, and Excel for Office 365.
Change cursor direction in Excel
You can change the default cursor behavior to move right, left, or up instead of down. It is also possible that the cursor does not move at all, but remains in the current cell even after pressing the Enter key. Changing the direction of the cursor is done using parameters Additionally in the dialog box Excel options †
Excel for Windows:
Click on the tab File on the ribbon to open the file menu.
Click parameters: in the menu to open Excel options.
Click Additionally on the left side of the dialog box.
In section Editing options go to † press Enter † move selection in the right panel. Click the down arrow next to Direction and select up, left, or right.
To keep the cell cursor in the same cell, uncheck in the field next to Move the selection after pressing the Enter key.
Office for Mac:
Click on the menu item excel †
Click Institutions in the menu to open Excel Settings † †
Press Change †
In section Editing options go to † press Enter † move selection in the right panel. Click the down arrow next to Direction and select up, right, or left.
To keep the cell cursor in the same cell, uncheck in the field next to Move the selection after pressing the “Back” key.
Using a tab and entering keys when entering data
If you periodically enter data row by row instead of down by column, you can use tab key to navigate the worksheet from left to right, instead of changing the default direction using the instructions above.
After entering the first data cell, press the tab to move one cell to the right in the same row.
Continue to enter data and use the key tab move to the next cell on the right until the end of the data line is reached.
Press key Enter to return to the first column to start the next row of data.