SUMMARY: If you’re editing a wide worksheet with the 10-key, you might find it more convenient to have the ENTER key move the cursor to the cell to the right.
By default, when editing a worksheet in Microsoft Excel 2010, you can press the Tab key to move the selection cursor to the cell to the right, and Enter moves to the below cell.
If you’re editing a wide worksheet with a 10-key, you might find it more convenient to have theEnter key move to the cell to the right, just like the Tab key. The following shows you how to make this change. In fact, you can have Enter move up or to the left, if desired:
1. Select the “File” tab in the Ribbon.
2. The Microsoft Office Backstage View appears. Click the “Options” button.
(Or instead of steps 1 and 2, press Alt + T, then the letter O.)
3. The “Excel Options” dialog box appears. Click “Advanced” in the left pane.
4. In the right pane, underneath “Editing Options”, make sure “After pressing Enter, move selection” is checked.
5. Underneath, click the pull-down next to “Direction” and choose the desired direction the cell selection should move after pressing Enter.
6. Click “OK” on the bottom-right of the dialog box to close it.