Add a Line Break in a Cell in Google Sheets

In Google Sheets, you can add a line break in a single cell by using two methods with a keyboard shortcut and by writing a formula using TEXTJOIN and CHAR.

Keyboard Shortcut to Add a Line Break

1. Select a cell where you want to add a line-break the first value (Text or a Number).
   
2. Press and Hold the Alt key and press the Enter key to enter the line break.
   
3. Enter the second value (text or a number) in the second line you are.
   
4. In the end, hit enter to close, entering data into the cell.
   

When you hit enter, it also changes the height of the entire row to get the values vertically. And once you delete the values from the cell, the row’s height will return to normal.

This manual method requires you to enter the line break each time you want to add it to the cell by using the shortcut keys again.

Add Line Break with a Formula

If you have multiple values to add a line break in between, this formula is the best way to use it.

1. First, in a cell, enter the TEXTJOIN.
2. After that, in the first argument, enter CHAR(10) to have the line break character as a delimiter.
3. Next, enter TRUE in the ignore_empty.
4. And in the third argument, refer to the range where you have values to combine with the line break.
5. In the end, close the function and hit enter to get the result.

=TEXTJOIN(CHAR(10),TRUE,A1:A3)

CHAR: When you specify the number, a function returns a character in the result. And 10 is the number of the line break character that we want to get in the formula.

Copy and Paste Data with Line Break

If you have data in a notepad or somewhere else, you can enter it in a single just by copying and pasting.

You need to copy the values from the notepad. After that, returns to the Google Sheets and paste it into the cell where you want it.

⮞ Get the Sample Sheet