MS Excell 2003 worksheet, using XP, How do I get the IP to go to next row when pressing Enter, &.......?

Question

Windows 98 and Excell 2000 allowed me to do that. Also the Tab key would take me to the next column. With XP and Excell 2003, Tab takes me across the window. I cannot find anywhere in the program where I can change that function of the buttons. Please help. I do a lot of financial reports in Excell 2003. Using the arrow keys instead is cumbersome.

Answer 1

I'm using XP and 2003, and my tab button only goes one column. Hmm...

Under Fromat --> Options --> Edit, the third setting down says Move Selection After Enter Direction: Down. Make sure this option is selected. You can also change the Down to Right.