CCH Walser

Normally, when you finish the content in a cell and press Enter key, the cursor will be moved to the next cell by default. But, sometimes, you just need stay in the same cell after pressing the Enter key. This article, I will introduce you some quick tricks to solve this job in Excel.

Stay in the same cell after pressing the Enter key with Excel Options

Stay in the same cell after pressing the Enter key with Shortcut Keys

In Excel, you can go to the Excel Options to set the option for changing the direction of the cursor after pressing the Enter key, please do as follows:

1. Click File > Options to go the Excel Options dialog.

2. In the Excel Options dialog box, click Advanced from the left pane, and in the right list box, under the Editing options section, uncheck After pressing Enter, move selection, see screenshot:

3. And then click OK button, from now on, when you enter the content into a cell and press Enter key, the input cell is still selected but not move.

1. So, the first thing you have to do is to enable developer option in your device
2. After enabling developer Options go to home page of settings and then click Developer option or search it in search bar
3. Now swipe and find minimum width and click on it