How to Get a New Line in Same Cell in Google Sheets

Add line breaks to a cell using easy keyboard shortcuts and formulas

|

Using a Function

|

Tips

When using Google Sheets, you may sometimes want to start a new line within one cell instead of going to different cells. This is doable with a shortcut or a formula.

Things You Should Know

Press the Alt and Tab keys at the same time in a cell to insert a line break.
You can also use the CHAR function to insert a line break in a cell.
When using the CHAR function, you can add a specific number of line breaks by nesting it within the REPT function.

Method 1

Method 1 of 2:

Keyboard Shortcuts

1
Double click on the cell where you want multiple lines.
2
If the cell contains text, move the cursor to the position where you want the break and press Alt+↵ Enter.

Advertisement
3
If the cell doesn't contain any text, double click the cell. Press Alt+↵ Enter key and repeat it for multiple lines.

Method 2

Method 2 of 2:

Using a Function

1
Go to the cell and type the formula =char(10). It will insert a new line in same cell. But you can't see it.
- If you want to see it, then copy the formula and right click on the same cell and apply Paste Special > Value Only.
2
When you want to insert multiple blank lines in same cell, tweak the formula above little bit.
- Go to the cell and type the formula =rept(chart(10),5). It will insert five blank lines in same cell.
- Apply the paste special as above to see the result. Change the number from 5 to any digit to get additional number of lines.