Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

There used to be a check-box in preferences in Excel 2003 to disable moving down on Enter key after you edited a cell. Where could I find that setting in Excel 2007?

<whining on>It drives me insane how microsoft trashes users skills and "fingers" memory to make what their new users may be will find easier. What about us, using these products for ten years?<whining off>

I want to control moving around with arrow keys, and Enter to only return me from the cell editing mode to navigation, not moving down. I'm not in a data entry business!! I'm analyzing data, editing just few cells time-to-time.

share|improve this question
up vote 5 down vote accepted

Office 2007 still has all the same options as previous version (for the most part). When you can't find something you're used to in Office 2007, it's usually under the Office Button. :)

Anyhow, to change the Enter key behavior you need to access the Excel Options window. To do this you can click on the Office Button--> Excel Options (located at the bottom)--> Advanced.

The first entry under "Editing options" is where you can set up what the Enter key does.

share|improve this answer
Thank you, techie007! – earlyadopter May 13 '10 at 18:43

In Excel 2007 there isn't a way to set the key's default to just accept the data and leave the cursor in the same place. Referring to techie007's answer you can make the cursor go up, down left or right. And, that sucks! That's the one main feature I miss most from the older versions of Excel.

However, Ctrl + ENTER will accomplish what you're looking for.

share|improve this answer
please note that the order of the answers changes so you shouldn't refer to an answer by direction (above/below etc) but refer to the poster's name. – Dave Sep 14 '12 at 13:41

Excel in Office Professional Plus 2010:
File > options > Advanced > [] After Pressing Enter, move selections (up, down, right left) or not at all.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .