Microsoft Excel Question.Why does the cursor go to the right when I hit Enter? Shouldn’t it supposed to go do?

Question

Microsoft Excel Question.Why does the cursor go to the right when I hit Enter? Shouldn’t it supposed to go down the next cell??? Why is it going to the right???? Thats for the TAB key....

Enter should go to the cell below....

Can someone help me fix the settings?? Thanks

Answer 1

Click on Tools → Options and click on the Edit tab.  There is an option for Move selection after Enter.  You can switch that on or off, and select which Direction the cursor moves there.

 

Answer 2

Go to MOButton>Excel options>advanced. It is the very first choice: After hitting enter cursor goes: up down left right. Go for it.

Answer 3

Click the round excel button (top left hand corner)



Click excel options



Click advanced tab (which is on the left)



At the very top, under "editing options" it says:

"after pressing enter, move selection____"

Just click the down arrow and select what you want it to do. You can get it to move up, down, right, or left. Up to you.

Answer 4

In excel 2003 that can be changed on the Tools/Options/Edit dialog.



In 2007 and 2010 you find it under the office bubble. I think it's still called options.

Answer 5

i'd oftentimes use tab to flow from cellular to cellular. counting on what you're doing, urgent enter ought to reason it to stay interior a similar cellular if documents already exists contained in the cellular earlier selection.