Cell Movement After Enter

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:

1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
2. At the left of the dialog box click Advanced. (Click here to see a related figure.)
3. Make sure the Move Selection After Enter check box is selected.
4. Use the Direction drop-down list to specify the direction that Excel should move.
5. Click OK.

If you are using a version of Excel prior to Excel 2007, follow these steps instead:

1. Choose Options from the Tools menu. Excel displays the Options dialog box.
2. Make sure the Edit tab is selected. (Click here to see a related figure.)
3. Make sure the Move Selection After Enter check box is selected.
4. Use the Direction drop-down list to specify the direction that Excel should move.
5. Click OK.

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.