Excel guide · 4 min read
Excel Enter key moves the wrong direction? How to fix it
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C |
|---|---|---|---|
| 1 | What happens | Cause | Fix |
| 2 | Enter moves right, up or left | The Enter direction setting was changed | File > Options > Advanced > Direction: Down |
| 3 | Enter confirms but doesn't move | After pressing Enter, move selection is off | Tick it in the same place |
| 4 | Enter loops round the same few cells | A range is selected | Click one cell, then type |
| 5 | Enter jumps back to an earlier column | You moved across with Tab first | Nothing: it returns to where you started |
| 6 | Cell stays selected after entering | Ctrl+Enter was pressed | Press Enter on its own |
| 7 | Arrow keys scroll the sheet instead | Scroll Lock is on | See the arrow keys guide |
1. Set the Enter direction back to Down (Windows)
Someone (or a macro) changed the direction, often to Right for typing across rows. The setting belongs to Excel itself, not to a workbook, so once it's changed every file you open behaves the same way. That's also why a colleague's file "works fine" on their computer.
- File > Options (on the Home screen, Options is at the bottom left; you may need More... first).
- Click Advanced.
- At the top, under Editing options, tick After pressing Enter, move selection.
- Set Direction to Down (the other choices are Right, Up and Left).
- Click OK. No restart needed.
2. Enter confirms the entry but doesn't move
The same checkbox is off. With "After pressing Enter, move selection" unticked, Enter stores what you typed and leaves the same cell selected. Some people like that for checking each entry, so it may have been switched off on purpose on a shared computer. Tick it again in File > Options > Advanced.
If it keeps switching back by itself, a macro or add-in is probably changing it: VBA can set Application.MoveAfterReturn and Application.MoveAfterReturnDirection. Try File > Options > Add-ins, set Manage to COM Add-ins or Excel Add-ins, click Go, and untick add-ins one at a time to find the one that does it.
3. On a Mac: the Return key setting
Excel for Mac calls it Return and keeps the setting in a different place.
- In the menu bar, click Excel > Preferences (called Settings on newer versions of macOS).
- Under Authoring, click Edit.
- Tick After pressing Return, move selection and set Direction to Down.
- Close the window; the change applies straight away.
4. Shortcuts that look like the wrong direction
If the setting is Down and Enter still seems to misbehave, it's usually one of these, and they're all working as designed:
- Shift+Enter moves the opposite way (up when the direction is Down). Handy for going back one row to fix a typo.
- Tab moves right and Shift+Tab moves left. Typing across a row with Tab and then pressing Enter jumps down a row and back to the column where you started, so you can enter a record per row without touching the mouse. It looks like Enter moved diagonally; it's on purpose.
- Ctrl+Enter enters the value and keeps the same cell selected. If you've got into the habit of pressing it, the selection never moves.
- Alt+Enter on Windows starts a new line inside the cell instead of moving. If text ends up on two lines, that's why.
- Arrow keys scrolling the whole sheet instead of moving the selection is Scroll Lock, a different problem with its own fix.
5. Enter stays inside a selected range
When more than one cell is selected, Enter moves only within the selection: down the first column, then to the top of the next column, then back to the start. That's useful for filling a block (select it, type, Enter, type), but confusing if you selected the range by accident and Enter seems to loop round the same few cells. Click a single cell and Enter behaves normally again.
Two related shortcuts work with a selection: Ctrl+Enter puts what you typed into every selected cell at once, and on a protected sheet where only unlocked cells can be selected, Tab jumps from one input cell to the next. That makes a simple data-entry form without any macros.
Common mistakes
Changing the setting in one workbook and expecting the others to stay different
It's an Excel-wide setting. Every workbook uses the same Enter direction.
Looking for the Mac option under Excel Options
On a Mac it's Excel > Preferences (or Settings) > Edit, and it's called Return.
Blaming the setting for Tab then Enter
Enter returns to the column where you started tabbing. That's Excel's design for row-by-row entry, not a fault.
Pressing Ctrl+Enter out of habit
Ctrl+Enter keeps the cell selected. Use Enter alone to move on.
FAQ
Why does Enter move to the right in Excel?
The Direction setting has been changed to Right. Go to File > Options > Advanced, and under Editing options set Direction to Down.
How do I make Enter go down in Excel?
File > Options > Advanced > tick After pressing Enter, move selection > Direction: Down > OK. On a Mac, Excel > Preferences > Edit > After pressing Return, move selection.
Why doesn't Excel move to the next cell when I press Enter?
After pressing Enter, move selection is turned off. Tick it in File > Options > Advanced. Also check you're not pressing Ctrl+Enter, which keeps the cell selected.
Why does Enter go back to a different column?
If you moved across the row with Tab, Enter returns to the column you started from on the next row. It's designed for typing one record per row.
Does the Enter direction setting save with the file?
No. It's part of Excel's own options, so it applies to every workbook on that computer and doesn't travel with the file.
Related guides
- Excel Tab key not working: why it happens and how to fix it
- Excel arrow keys not working: 6 fixes
- Excel ribbon missing: how to get it back
- Excel formula bar missing or not showing: how to get it back
Updated