well I found it
it's the first option in the Excel Option>Advance options>editing options. Just press down on the scroll down menu and choose a selection of Down, Right, Up , Left.
Hi everyone,
I have a simple question that I cannot get. Okay so when I type an entry into a cell, I would like for it to automatically move unto the next cell whenever I press the left or right arrow keys. When I press the right arrow key, it Scrolls the whole page to the right (not what I want it to do). As of now, I have only been able to go to Excel Options and change the direction the cell moves when I press ENTER. Other than that, whenever I want to select another cell close to the one I am currently working with, I have to stop, deselect it with the mouse by selecting another one. I have used Excel at another PC and the entry automatically goes to the next cell when I press the right arrow key for the next one and does not make the page scroll.
What option do I have to change in order to do this?
Thank you so much for the help !

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic