How to disable moving down on Enter key in Excel 2007?

Question

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.

Answer 1

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.