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

• 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.

Keyboard Shortcuts

Double click on the cell where you want multiple lines.

If the cell contains text, move the cursor to the position where you want the break and press Alt+↵ Enter.

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

Using a Function

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.

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.