To press Enter in Excel and stay in the same cell, press Ctrl+Enter instead of Enter. Excel confirms what you typed and keeps that cell selected. To make plain Enter always stay put, go to File > Options > Advanced and untick After pressing Enter, move selection. If you actually want a new line inside the cell, press Alt+Enter.
Applies to: Excel for Microsoft 365, Excel 2024, 2021, 2019 and 2016 on Windows. Mac steps are below.
Method 1: Ctrl+Enter (one cell at a time)
- Type in the cell.
- Press Ctrl+Enter.
The entry is confirmed and the same cell stays selected, so you can format it or check a formula result straight away. Bonus: if you select several cells first, type a value and press Ctrl+Enter, Excel puts that value in every selected cell.
Method 2: Stop Enter from moving the selection
- Go to File > Options > Advanced.
- Under Editing options, untick After pressing Enter, move selection.
- Select OK.
Enter now confirms the entry and stays in the cell every time. To move the other way instead, keep it ticked and change Direction to Right, Up or Left. This setting applies to all workbooks.
Method 3: Alt+Enter for a new line in the cell
If you pressed Enter to start a new line of text and Excel jumped to the next cell, press Alt+Enter instead. Excel adds a line break inside the cell and turns on Wrap Text. More on line breaks is in returning in a cell in Excel, and on the layout side in wrapping text in Excel.
On a Mac
- To stop Return from moving, go to Excel > Preferences (or Settings) > Edit and untick After pressing Return, move selection.
- For a new line in a cell, press Option+Return (or Control+Option+Return in some versions).
When staying in the cell is useful
- Checking a formula: type a formula, press Ctrl+Enter, and the result and the formula bar both stay in view so you can spot mistakes before moving on.
- Formatting right after typing: enter a date or amount and immediately apply a format with Ctrl+Shift+4 (currency) or Ctrl+Shift+3 (date) without stepping back.
- Copying a formula down afterwards: with the cell still selected, double-click the fill handle to fill the column.
- Filling a block with the same value: select the range, type once, press Ctrl+Enter. Handy for “N/A” or “0” in many blanks at once; combine with Home > Find & Select > Go To Special > Blanks to select only empty cells first.
Other keys that confirm an entry
- Tab: confirms and moves right.
- Shift+Enter: confirms and moves up.
- Shift+Tab: confirms and moves left.
- Esc: cancels the entry and keeps the old value.
- The check mark next to the formula bar: confirms and stays, like Ctrl+Enter.
Troubleshooting
Ctrl+Enter fills many cells
Several cells were selected. Click a single cell first.
Enter still moves after changing the option
Check the option saved. Some add-ins or shared settings reset it; turn it off again and restart Excel.
Arrow keys or Enter don’t move at all
That’s a different issue, often Scroll Lock, and the fix is to unlock the cursor in Excel.
Frequently asked questions
Does this work in Excel for the web?
Ctrl+Enter and Alt+Enter work in the browser. The move-selection option is only in the desktop app.
How do I see which cell is active?
To make it stand out, you can highlight the active cell in Excel.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.