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

Last Updated: February 26, 2019

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.

Method 1

Method 1 of 2:
Using Keyboard Shortcut

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.
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 Char() 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.