Move Selection after Enter

[frankfarley]

I have Excell 2007. When I enter data into a specific cell and press "enter", the cursor will not move down to the next cell below. How do I change this funtion so that I don't have to "enter" and then press the arrow key to move down one cell?

 

[Von Pookie]

Check your settings. In Excel Options, go to Advanced and make sure the box for 'After pressing enter move selection...' is marked.

 

[daniels012]

In 2007 go to the winodws icon press it.
At the bottom is Excel Options, click it
Go to the Advanced tab at the side
Under editing options the first choice should be what you are looking for.

Michael

 

[frankfarley]

Check your settings. In Excel Options, go to Advanced and make sure the box for 'After pressing enter move selection...' is marked.

I do not have a tab on my tool bar for Excell Options.

 

[daniels012]

Next to Home you will see an icon circle with red, yellow, blue and green.
Click this and at the bottom should be Excel Options