Changing Directions In MS Excel
- by Carol Bratt on 20071001 @ 12:29AM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: cursor, pressed, drop-down list, cell, selection)
The default behavior of the Enter key drives some Excel folks crazy. When you press Enter, some users would prefer that the cursor to move to the next cell on the right, while other folks prefer the cursor to move down.
Fortunately, MS Excel can accommodate these preferences and more. To change the way Excel reacts after Enter is pressed follow the steps below:
- Go to Tools | Options.
- Select the Edit tab.
- Click the Move Selection After Enter checkbox to activate the Direction drop-down list.
- In the drop-down list, select from the following options:
- Down
- Right
- Up
- Left
If you prefer that the cursor stay in the active cell when Enter is pressed, deactivate the check box for the Move Selection After Enter option.
After you have changed the way Excel reacts after Enter is pressed, this change remains in effect for all new and existing workbooks.
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
