Welcome toExcel2007.Tips.Net
Helpful Links
Bugs and Pests Tips
Health Tips
Money Tips
WordTips
Newest Tips
Specifying the Number of MRU Files
Seeing How Excel Evaluates Formulas
Highlighting a Cell if It Contains Specific Text
Creating a List of Worksheet Formulas
Subscribe
Specifying Enter Key Behavior
Summary: When you are entering data in a worksheet and you press Enter, it is the signal to Excel that you are done with the current cell. What happens next depends on a setting you make that indicates which way you want Excel to move the selection.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:
- Click the Office button, then click Excel Options. Excel displays the Excel Options dialog box.
- At the left side of the dialog box, click the Advanced option. (Click here to see a related figure.)
- 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.
- 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.
- Click on OK.