When pressing Enter key in a worksheet, the cursor moves to the cell below. However, you can change the default and move the cursor to the cell right, this is very useful when entering data. 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 "Right" from the drop down list "After pressing Enter, move selection" under the section of "Editing options";
Step 5: Click "OK" at the bottom.