When i press "ENTER", it move rightward, (i want it to go down!)

G

Guest

IN Excel, when i press "ENTER", it moves to the cell next to it. But i want
it to move "one cell under" (go downward) the active cell.

How do i change the settings?



Cuz before i wasn't like this!
 
G

Guest

Click on Tools and then OPTIONS and then click on the tab EDIT.

There you will see an option: Move selection after Enter

There will be a drop down box where you will be able to choose.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I press "enter" but it doesn't move to next row down. 1
"Move selection after Enter" 3
XL2007: Down <> down on Enter? 3
change direction active cell indicator moves when enter key is pre 2
How do I change the direction of my cursor when I press enter? 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Get excel to automatically go to the next cell w/o pressing enter 1
Press Enter and Move Back to Column A Automatically 3

Top