On the worksheet click the cell in which you want to enter the formula. Type Shift8 on the top row of the keyboard. For our example type.
Equation of a line.
Excel displays the calculated answer in cell C2 and the formula A2B2 in the Formula bar. Select the C2 cell. When you enter a formula in a cell Excel calculates the result of that formula and displays the result of that calculation to you. Then click the place where you want to insert a line break.