Cellwise Start free

Excel guide · 4 min read

Excel Enter key moves the wrong direction? How to fix it

Quick answerThe direction Enter moves is a setting. On Windows, go to File > Options > Advanced, and under Editing options tick "After pressing Enter, move selection" and set Direction to Down. On a Mac it's Excel > Preferences (Settings on newer macOS) > Edit > "After pressing Return, move selection". If the setting is already right, check whether a range is selected (Enter then moves inside it) or whether you pressed Tab or Ctrl+Enter.

Sample data

Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.

RowABC
1What happensCauseFix
2Enter moves right, up or leftThe Enter direction setting was changedFile > Options > Advanced > Direction: Down
3Enter confirms but doesn't moveAfter pressing Enter, move selection is offTick it in the same place
4Enter loops round the same few cellsA range is selectedClick one cell, then type
5Enter jumps back to an earlier columnYou moved across with Tab firstNothing: it returns to where you started
6Cell stays selected after enteringCtrl+Enter was pressedPress Enter on its own
7Arrow keys scroll the sheet insteadScroll Lock is onSee 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.

  1. File > Options (on the Home screen, Options is at the bottom left; you may need More... first).
  2. Click Advanced.
  3. At the top, under Editing options, tick After pressing Enter, move selection.
  4. Set Direction to Down (the other choices are Right, Up and Left).
  5. 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.

  1. In the menu bar, click Excel > Preferences (called Settings on newer versions of macOS).
  2. Under Authoring, click Edit.
  3. Tick After pressing Return, move selection and set Direction to Down.
  4. 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

Updated