How to Setup Moving Cursor to the Cell Up When Pressing Enter

In default, when pressing Enter in a worksheet, the cursor moves to the cell below. To change selection move to the cell up, 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 "Up" 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