How-To Geek

How to Change the Behavior of the Enter Key in Excel

00_lead_image_enter_key_behavior

By default, when you type information into Excel and then press “Enter”, Excel will move the selection box one cell down. However, what if you want to enter information from left to right instead?

We’ll show you a simple setting in Excel you can change that will solve your problem.

To change the direction the selection moves when you press “Enter”, click the “File” tab.

01_clicking_file_tab

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

02_clicking_options

The “Excel Options” dialog box displays. Click “Advanced” in the list of items on the left.

03_clicking_advanced

In the “Editing options” section, make sure the “After pressing Enter, move selection” check box is selected. Then, select an option from the “Direction” drop-down list. For example, we chose “Right” to make the selection go from the “Price (Dollars)” column to the “Price (Euros)” column in the price sheet pictured at the beginning of this article.

04_after_pressing_enter_option

Click “OK” to accept the change and close the “Excel Options” dialog box.

05_clicking_ok

If you don’t want the selection to change when you press “Enter”, turn off (deselect) the “After pressing Enter, move selection” check box. The currently selected cell will stay selected when you press “Enter”.

Lori Kaufman is a writer who likes to write geeky how-to articles to help make people's lives easier through the use of technology. She loves watching and reading mysteries and is an avid Doctor Who fan.

  • Published 02/23/16

Other How-To Geek Articles You Might Like

Enter Your Email Here to Get Access for Free:

Go check your email!