How to Get a New Line in Same Cell in Google Sheets
Go to the cell and type the formula =char(10)., When you want to insert multiple blank lines in same cell, tweak the formula above little bit.
Step-by-Step Guide
-
Step 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. , 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. -
Step 2: When you want to insert multiple blank lines in same cell
-
Step 3: tweak the formula above little bit.
Detailed Guide
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. , 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.
About the Author
Helen Anderson
Helen Anderson is an experienced writer with over 12 years of expertise in lifestyle and practical guides. Passionate about sharing practical knowledge, Helen creates easy-to-follow guides that help readers achieve their goals.
Rate This Guide
How helpful was this guide? Click to rate: