Changing Directions In MS Excel

Dennis Faas's picture

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:

  1. Go to Tools | Options.
     
  2. Select the Edit tab.
     
  3. Click the Move Selection After Enter checkbox to activate the Direction drop-down list.
     
  4. 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!

| Tags:
Rate this article: 
No votes yet