How to Press Enter in Excel
Pressing Enter in Excel does two things at once: it confirms whatever you typed into the cell, and it moves the active cell to the next one down. That downward jump is the default behavior, but you can change the direction, freeze the cursor in place, or fill an entire range with a single keystroke once you know which variations to use.
This guide covers exactly what the Enter key does, how to make it move right instead of down, how to stay in the same cell after pressing it, and how to fix the most common reasons Enter starts behaving unexpectedly. Everything below is shown for both Windows and Mac.
What pressing Enter actually does
When you type a value or formula into a cell and press Enter, Excel commits the entry and then moves the active cell one row down. That is the whole job of the key in its default state: confirm, then advance.
A few details worth knowing:
- The movement happens after the entry is locked in, so your data is never lost by pressing Enter.
- If you press Enter on a blank cell without typing anything, Excel simply moves down one row.
- When you finish a row by tabbing across several cells and then press Enter, Excel jumps back to the column where you started typing and drops down one row. More on that pattern below.
- Enter also confirms a formula. After you finish writing a function, pressing Enter calculates it and shows the result.
So the short answer to “what does Enter do in Excel” is: it accepts your input and moves the selection down by one cell.
How to make Enter move right instead of down
The single most common request is to make Enter move the cursor to the right rather than down, which is handy when you enter data across a row at a time. You control this with a single setting.
On Windows:
- Go to File → Options.
- Select the Advanced category on the left.
- Under the Editing options group at the top, find the checkbox labeled “After pressing Enter, move selection.”
- Make sure it is checked, then use the Direction dropdown to choose Down, Right, Up, or Left.
- Click OK.
On Mac:
- Open Excel → Preferences (or press Command + Comma).
- Click Edit.
- Find “After pressing Return, move selection” and choose the direction you want from the dropdown.
- Close the Preferences window.
From that point on, pressing Enter (or Return) moves the active cell in whatever direction you picked. If you ever want it back the way it was, just return to the same setting and switch the direction to Down. Understanding this setting is one of the quickest ways to speed up data entry, and it pairs nicely with the other shortcuts in our list of the best Excel keyboard shortcuts.
How to stay in the same cell after pressing Enter
Sometimes you want to confirm an entry without the cursor jumping anywhere. To stay put, press Ctrl + Enter on Windows or Control + Enter on Mac instead of plain Enter. Excel commits the value and leaves the active cell exactly where it was.
This is genuinely useful when you want to type something, check the result, and then keep editing the same cell or its neighbors without re-selecting. It is also the foundation of the next trick.
Fill an entire selection with one value
Ctrl + Enter has a second job that most people never discover: it fills every selected cell with the same value in one shot.
- Select the range you want to fill — it can be a column, a row, or a scattered set of cells you picked with Ctrl-click.
- Type the value or formula you want.
- Press Ctrl + Enter (Windows) or Control + Enter (Mac).
Excel writes your entry into every cell in the selection simultaneously. If you typed a formula with relative references, each cell gets its own adjusted copy, exactly as if you had copied it down. This is a faster alternative to dragging the fill handle when you already have the target cells selected, and it complements Excel’s other autofill tools.
How Enter behaves inside a multi-cell selection
There is one more behavior that catches people off guard. If you select a block of cells first — say a 3-by-4 range — and then start typing and pressing Enter, the cursor does not leave the selection. Instead, it cycles down through the highlighted cells and, when it reaches the bottom of a column, wraps to the top of the next column within the selection.
This is intentional and useful: it lets you fill a fixed block of cells quickly without the cursor wandering off into the rest of the sheet. Shift + Enter moves backward through the same selection if you need to step up.
Tab versus Enter: a powerful one-two punch
Enter and the Tab key are designed to work together for row-by-row data entry:
- Tab confirms the entry and moves the active cell one column to the right.
- Enter, after you have tabbed across a row, returns the cursor to the column where you started the row and moves down one row.
So the workflow is: type a value, Tab, type the next, Tab, and so on across the row. When you reach the end, press Enter and Excel snaps back to the first column and drops to the next row, ready for the next record. This rhythm is far faster than reaching for the mouse, and it is one of the most efficient ways to move between cells while entering structured data. Shift + Tab moves left, the mirror of Shift + Enter.
Using Enter to confirm formulas and dialog boxes
Enter is not just for moving around. After you type a formula such as =SUM(A1:A10), pressing Enter calculates it and commits the result. In most dialog boxes and prompts, Enter also acts as the “OK” or “confirm” button, so you rarely need the mouse to accept your settings. When you are editing an existing cell’s contents and press Enter, Excel saves the edit and moves on according to your direction setting.
A quick note on line breaks
If what you actually want is a line break inside a single cell rather than moving to a new cell, that is a different keystroke: Alt + Enter on Windows or Control + Option + Return on Mac. Because it is a topic of its own, we cover it fully in our dedicated guides on adding a new line within a cell and starting a new line in Excel. This article stays focused on what the plain Enter key does for navigation.
Windows vs Mac Enter shortcuts
| Action | Windows | Mac |
|---|---|---|
| Confirm entry, move per direction setting | Enter | Return |
| Move backward (up / previous) | Shift + Enter | Shift + Return |
| Confirm and stay in the same cell | Ctrl + Enter | Control + Return |
| Fill selected range with one value | Ctrl + Enter | Control + Return |
| Confirm, move right | Tab | Tab |
| Move left | Shift + Tab | Shift + Tab |
| Line break inside a cell | Alt + Enter | Control + Option + Return |
| Change Enter direction | File → Options → Advanced | Excel → Preferences → Edit |
Troubleshooting the Enter key in Excel
Enter does not move the cursor at all. Open File → Options → Advanced (or Excel → Preferences → Edit on Mac) and confirm that “After pressing Enter, move selection” is checked. If the box is unchecked, Excel commits the entry but leaves the cursor in place. Also check that you are not stuck in Edit mode — look at the bottom-left status bar; if it says “Edit,” press Enter once more or press Esc to exit.
Enter moves the wrong way (right, up, or left instead of down). The direction dropdown in that same setting has been changed. Set it back to Down to restore the default. This setting is per-installation, so it can surprise you on a shared or new computer.
Enter jumps too far down the sheet. This usually means a block of cells is selected and Enter is cycling within it, or the cursor is wrapping to the next column of a selection. Click a single cell to clear the selection, then try again. If Enter skips multiple rows, check that no rows are hidden between your current position and where the cursor lands.
Enter adds a line break instead of moving. You may have accidentally pressed Alt + Enter, or a setting in a different app intercepted the key. Press Esc, then use a plain Enter. If you genuinely want in-cell line breaks, see the line-break guides linked above.
Nothing happens because Excel is busy. If a large recalculation or an open dialog is running, Enter may seem unresponsive. Wait for the operation to finish or close the dialog, then try again.
Frequently Asked Questions
What does Enter do in Excel?
Pressing Enter in Excel confirms the value or formula you typed into the active cell and then moves the selection one cell down by default. It commits your input first, so your data is never lost, and only then advances the cursor. The direction it moves can be changed in Excel’s options.
How do I make Enter move right instead of down in Excel?
Go to File → Options → Advanced (Excel → Preferences → Edit on Mac), find “After pressing Enter, move selection,” and change the Direction dropdown from Down to Right. From then on, pressing Enter moves the active cell one column to the right. Set it back to Down anytime to restore the default behavior.
How can I stay in the same cell after pressing Enter?
Press Ctrl + Enter on Windows or Control + Return on Mac. Excel commits your entry but keeps the active cell exactly where it is instead of moving. This is also the trick for filling an entire selected range with one value: select the cells, type once, then press Ctrl + Enter.
Why does the Enter key not move my cursor in Excel?
The most common cause is that “After pressing Enter, move selection” is unchecked in your Excel options, so the entry is confirmed but the cursor stays put. Check that setting under Advanced. If the status bar reads “Edit,” you may also be in edit mode — press Esc and try a plain Enter again.
What is the difference between Tab and Enter in Excel?
Tab confirms your entry and moves the active cell one column to the right, while Enter moves it down (by default). They are designed to work together: tab across a row to fill it, then press Enter to jump back to the starting column and drop down to the next row, which is ideal for entering records quickly.
Does Enter behave differently inside a selected range of cells?
Yes. If you select a block of cells first and then type and press Enter, the cursor cycles within the selection — moving down each column and wrapping to the top of the next column rather than leaving the highlighted area. This lets you fill a fixed block of cells without the cursor wandering off. Shift + Enter moves backward through the selection.
