Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

3 Answers 3

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

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
    
Same for Excel 2007. –  pnuts Oct 4 '12 at 16:30

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.