Changing the Direction Moving Cells After Pressing ENTER

Click the Microsoft Office button and then click Excel Options. On the Advanced Category, under Edit choose After pressing ENTER, move selection Direction: Down, Right, Up, or Left.

If you enter data in a row in a row using the TAB key, then if it has reached the end of the table you press ENTER, the active cell will automatically jump to the next line in the cell located at the beginning of the table.

If you enter data in a cell. Then the cells are showing #####, meaning the data number you enter is wider than the width of the column. To overcome this, change the column width so that data can be accommodated figures.