How To: How Can I Change the Behavior of the Enter Key in Excel

If you are used to excel, you will agree with me that when you press “Enter” after you have typed information into Excel , Excel will by default move the selection box one cell down. But this might not suit you always. Of course there are instances where you could prefer to enter information from left to right rather or even something else entirely. So how do you gets around this?

How To: How Can I Change the Behavior of the Enter Key in Excel

How To: How Can I Change the Behavior of the Enter Key in Excel

In this guide,we will put you through a very convenient setting in Excel which you could follow so as to make the needed changes to resolve your problem.

If you choose to change the direction of the selection moves when you take “Enter”, simply click the “File” tab.

How To: How Can I Change the Behavior of the Enter Key in Excel

How To: How Can I Change the Behavior of the Enter Key in Excel

Click “Options” in the list of items on the left on the backstage screen, .

How To: How Can I Change the Behavior of the Enter Key in Excel

How To: How Can I Change the Behavior of the Enter Key in Excel

There comes the display of The “Excel Options” dialog box. Click “Advanced” which you could see in the list of items appearing on the left.

How To: How Can I Change the Behavior of the Enter Key in Excel

How To: How Can I Change the Behavior of the Enter Key in Excel

Necessarily ensure the “After pressing Enter, move selection” check box is selected In the “Editing options” section. After this, make a choice of an option from the “Direction” drop-down list. An instance here is, we selected “Right”, this way the selection goes to the “Price (Euros)” column from the “Price (Dollars)” column in the price sheet which we sampled at the start of this article.

How To: How Can I Change the Behavior of the Enter Key in Excel

How To: How Can I Change the Behavior of the Enter Key in Excel

Take “OK” so as to accept the change, after this you could close the “Excel Options” dialog box.

How To: How Can I Change the Behavior of the Enter Key in Excel

How To: How Can I Change the Behavior of the Enter Key in Excel

Should you be opposed to a change in the selection when you press “Enter”, do well to turn off (deselect) the “After pressing Enter, move selection” check box. The selected cell at the moment will now remain selected when you press “Enter”.

Hope this tutorial has been helpful.




Share this on:Share on Facebook0Tweet about this on TwitterShare on Google+2Pin on Pinterest0Share on StumbleUpon0Digg this

Become a fan on Facebook and us on twitter for our new updates.

Leave a Reply