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

In default, when pressing Enter in a worksheet, the cursor moves to the cell below. However, in some situations, especially when you enter data, you can change the selection to move the cell left. Please see 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 "Left" from the drop down list "After pressing Enter, move selection" under the section of "Editing options";

Step 5: Click "OK" at the bottom.