Welcome toExcel2007.Tips.Net
Helpful Links
Excel2007 Tips
Health Tips
Pet Tips
Word2007 Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
What Happens after You Press Enter
Summary: What happens when you press Enter in a cell depends on how you have Excel configured. Here's the way you can control the action Excel takes.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:
- Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
- At the left of the dialog box click Advanced. (Click here to see a related figure.)
- Make sure the Move Selection After Enter check box is selected.
- Use the Direction drop-down list to specify the direction that Excel should move.
- 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.
Related Tips:
More Power! For some people, the prospect of creating Word macros can be scary. WordTips: The Macros can help you conquer your fears and you'll discover you're much more confident and productive as you make Word do exactly what you want. This is an invaluable source for learning macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of WordTips. Learn at your own pace, exactly the way you want. Check out WordTips: The Macros today!