When you enter information in a cell, and then press the Enter key, Excel normally moves to the cell below the one in which you entered the information. You can configure Excel to move in a different direction after pressing Enter by following these steps:
- Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 and later versions, display the File tab of the ribbon and then click Options.)
- At the left of the dialog box click Advanced. (See Figure 1.)
- Make sure the After Pressing Enter Move Selection check box is selected.
- Use the Direction drop-down list to specify the direction that Excel should move.
- Click OK.
Figure 1. The Advanced options in the Excel Options dialog box.
There is one interesting thing about how Excel selects a new cell: If you press Shift+Enter (instead of Enter) when entering data, then Excel selects the cell in the opposite direction of what you have specified in step 4. Thus, if the Direction drop-down list is set to Down, and you press Shift+Enter, then Excel actually moves the selection upwards.