Download Article
Add line breaks to a cell using easy keyboard shortcuts and formulas
Download Article
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.
Steps
-
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 .Advertisement
-
If the cell doesn't contain any text, double click the cell. Press Alt + ↵ Enter key and repeat it for multiple lines.
Advertisement
-
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.
- Go to the cell and type the formula
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
- If you type
=rept(D5&char(10),6)
, this will insert 6 lines in same cell, but not blank; it will repeat text or number in cell D5.Thanks
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
Advertisement
About This Article
Thanks to all authors for creating a page that has been read 171,793 times.
Advertisement