In MS Excel, my "Enter" button acts like my "Tab" button. How do I get it back?

Question

Something happened in my MS Excel 2003. Before, when I hit "Enter", it would go to the next row. Now, when I hit "Enter" it moves to the next column (just as if I've hit the "Tab" button). How do I get it back to move to the next row?

Answer 1

Under Tools, select the options menu. There is a setting under the "Editing" tab that controls this. Somehow it must have been changed.
You will see a selection for "After Pressing Enter, move selection: [Choose from Drop-down list] "Down, Right, Up, Left"

I am using Excel 2007, so I may have more options. I think you may have only down and right. You will need to select the "down" choice to have it automatically move to the next row when you hit enter.

Answer 2

precisely what i've got been asserting. The buttons on solutions could be: Thumb Up, Thumb Down, WTF, and that isn't A Thumb (center finger). This covers each and every thing. ^__^ of path I additionally think of there could be an entire class of "WTF ??" fabric, stuff it particularly is in simple terms too strange and random to throw out fullyyt with the abusive stuff. Why could AnswerFail have all the relaxing, you already know?

Answer 3

You might have the scroll lock on your keyboard. You can also GO to TOOLS- OPTIONS - EDIT TAB- and edit "Move selection after enter" to whatever you wish.

Answer 4

First Question is do you have a special keyboard that you bought? you might have to reload the software for that but if not go into your control panels and click on keyboard and other hardwares and change your keys!

Answer 5

If sticky keys is enabled, then that is probalby the problem

Answer 6

you probably have a defective/broken keyboard. there might be a broken wire, or sodder somewhere in the KEYBOARD. you should see if you can send your pc into a shop to have it tested.