How to Insert Line Breaks in Google Sheets Using Keyboard Shortcuts
1
Double-click the cell to activate it and place the cursor at the point where you want the line break
2
For Mac, press [[Command]] + [[Enter]]
For Windows, press [[Alt]] + [[Enter]]
How to Insert Line Breaks in Google Sheets Using the CHAR Function
Understanding the Formula:
The **CHAR(10)** function inserts a line break in a formula\
**Example**: `=A1 & CHAR(10) & B1` combines the text in cells A1 and B1, separated by a line break
3
Select the cell where you want the line breaks
4
To combine text from two cells with a line break in between, type in the cell you want the result to appear, the char formula "**=Cell 1 & CHAR(10) & Cell 2**"
For this specific example, the formula is **=C3 & CHAR(10) & D3**