By default, pressing the Enter key in Excel on an active cell submits anything you’ve typed into cell and selects the cell below it. However, you can also choose to stay on the active cell or go to the next cell instead. In this guide, we’re going to show you how to change pressing Enter behavior in Excel.
Follow the steps below to access the options page where you can change the Enter key settings.
- Open Excel Options by following File > Options
- Activate the Advanced tab
- The first setting – After pressing Enter, move selection – is what we are looking for
Your other option is to disable moving altogether. If you uncheck the After pressing Enter, move selection option, pressing the Enter key will only submit your entry, and stay in the same cell.
Remember to press OK to save your changes to the Excel Options dialog.