Add Line Break in Cell or Formula

Add a line break when typing in a cell Select the cell In the formula bar, click where you want the line break On the keyboard, press Alt + Enter, to add a line break Press Enter, to complete the formula
The cell will automatically be formatted with Wrap Text, and you might need to widen the column.
Add a line break in a formula Select the cell In the formula bar, click in the formula, where you want the line break To add a line break use this character, with the & operator: CHAR(10) Press Enter, to complete the formula
For example, change this formula: ="Total amount is: " & SUM(C1:C6) to this: ="Total amount is: " & CHAR(10) & SUM(C1:C6)
Turn on Wrap Text When you add a line break to a formula, the cell is NOT automatically formatted with Wrap Text, so you might need to turn that feature on. Otherwise, you will see a small box where the line break should be.
To turn on Wrap Text: Select the cell On the Excel Ribbon, click the Home tab In the Alignment group, click Wrap Text.