Change How the ‘Enter’ Key Operates (Excel 2007)
When you enter data into a cell and then hit the ENTER key, Excel will automatically move you to the cell below. If you want to enter data going across the row, you can change it to move to the cell to the right after you hit the ENTER key.