What Happens When Your Press Enter in Excel 2007 & 2003?

Microsoft Excel 2007

When you press Enter after typing information into a cell, Excel will normally save your information and then moves to the next cell beneath the one where you pressed Enter. You can modify this behavior, however:

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.

3.     Under Editing Options, make sure that the checkbox for "After pressing Enter, move selection" is checked; it should be by default.

4.     Using the direction drop-down list, change the direction as desired. Changing the direction affects how Excel behaves in all workbooks.

 

Microsoft Excel 2003

To change what happens when you press Enter in Excel 2003, follow these steps:

1.     On the Tools menu, click Options

2.     Click the Edit tab.

3.     Select the Move Selection after Enter Check Box.

4.     Select a direction in the Direction box.

5.     Click OK.