Inserting Numeric Data and Text

Click the cell that will contain the data. Type the text data and the figures in it, then press the Enter key on the keyboard.

Once you enter data in a cell and then press ENTER, Excel will automatically move the active cell to the next empty cell. In order to direct the cell to the direction that you will need after pressing ENTER, the following way.

Press the TAB	Move to the next cell
Press SHIFT + TAB	Move to the cell on the left
Press ENTER	Move to cell below
Press SHIFT + ENTER	Move to cell above it

If you intend to enter data in a cell on a new line, while pressing ENTER press and hold down the ALT key, then at the top of the cell will appear Page Break line. This means that these cells will be on a new page on the sheet.