The Descending Cursor
Microsoft Excel is optimized for rapid data entry down columns. By default, when you type a number or text into a cell and press the “Enter” key on your keyboard, Excel instantly moves your active selection down to the cell immediately below it. While this is perfect if you are typing a long list of expenses row by row, it can be incredibly irritating if you are building a complex dashboard, formatting a single cell with multiple colors and borders, or entering data horizontally across a row. You are forced to constantly reach for your mouse or the up-arrow key to re-select the cell you just finished typing in.
How to Stop the Cursor from Moving
You can completely disable this behavior deep within Excel’s global application options. Once disabled, pressing Enter will confirm the data input, but the highlight box will remain stubbornly locked onto the exact same cell.
1. Open Microsoft Excel.
2. Click on the File tab in the top-left corner of the ribbon.
3. Look at the very bottom of the left-hand sidebar and click on Options.
4. In the Excel Options dialog box that opens, click on Advanced in the left pane.
5. Look at the very first section at the top, labelled Editing options.
6. The very first checkbox in this list is After pressing Enter, move selection.
7. Simply uncheck the box.
8. Click the OK button at the bottom of the window.
Now, when you type data and hit Enter, your active selection will stay exactly where it is.
How to Change the Direction Instead
If you don’t want to disable the movement entirely, but rather want Excel to move horizontally (perfect for entering data across a timeline or a row of dates), you can change the default direction instead of unchecking the box.
1. Return to the Editing options menu as described above.
2. Ensure the After pressing Enter, move selection box is checked.
3. Look at the drop-down menu immediately below it, labelled Direction:.
4. By default, it is set to “Down.” Click the menu and select Right (or “Up” or “Left”, depending on your workflow).
5. Click OK.
When you press Enter now, Excel will behave like a typewriter, seamlessly moving your active cell to the right so you can rapidly fill out adjacent columns.