If you press option (1) Enter, the cell accepts your typing as its contents. In Excel, when you finish typing in a cell, pressing the Enter key confirms the input and moves the active cell selection down to the cell below if you're in a vertical direction or to the cell on the right if you're in a horizontal direction. The cell you were editing will display the entered content as its contents.
Discusssion
Login to discuss.