Change Directions in MS Excel

Dennis Faas's picture

The default behavior of the Enter key in MS Excel drives some folks crazy. When you click on Enter, some people would prefer that the cursor move to the next cell on the right, while others prefer the cursor move downward. Fortunately, MS Excel can accommodate these preferences and more.

To change the way MS Excel reacts after you click Enter, follow the steps below:

  • Click on Tools | Options.  
  • Click on the Edit tab.  
  • Click the Move Selection After Enter check box 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 clicked, deactivate the check box for the Move Selection After Enter option.

After you have changed the way MS Excel reacts after you click Enter, this change will remain in effect for all new and existing workbooks.

When you become a member at, 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