Specifying the Behavior of the Enter Key

When you type information into a cell, it is normal to press the Enter key at the end of your entry. Excel allows you to specify exactly what should happen after you press Enter. Basically, you can specify that nothing happen (the cell into which you entered information remains the currently selected cell) or that a different, adjacent cell is automatically selected.

To make your specification, follow these steps:

  1. Display the Excel Options dialog box. (In Excel 2007 click the Office button and click Excel Options. In Excel 2010 and Excel 2013 display the File tab of the ribbon and click Options.)
  2. At the left side of the dialog box, click the Advanced option. (See Figure 1.)
  3. Figure 1. The advanced options of the Excel Options dialog box.

  4. The first option in the Editing Options section of the dialog box is entitled After Pressing Enter, Move Selection. Either select or clear the check box, depending on whether you want the selection to move or not when pressing Enter.
  5. If you select the After Pressing Enter Move Selection check box, use the Direction drop-down list to specify the direction of the cell that should be selected.
  6. Click on OK.