How to Move Cursor to Cell Below When Pressing Enter

In default, when pressing the "Enter" key in a worksheet, the cursor moves to the cell below. However, you can change the direction to cells (e.g., up, right, left). To change the selection back, please follow the steps below:

Step 1: Click the "File" Tab from the ribbon;

Step 2: Click "Options" from the left navigation menu;

Step 3: Click "Advanced" from the left navigation menu in the dialog box;

Step 4: Select "Down" from the drop down list "After pressing Enter, move selection" under the section of "Editing options";

Step 5: Click "OK" at the bottom.

Leave a Reply