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

Download Article

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

Author Info

Last Updated: October 25, 2022

Download Article

Keyboard Shortcuts

|

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

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8b\/Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-1.jpg\/v4-460px-Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-1.jpg","bigUrl":"\/images\/thumb\/8\/8b\/Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-1.jpg\/aid8840268-v4-728px-Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-1.jpg","smallWidth":460,"smallHeight":288,"bigWidth":728,"bigHeight":455,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6d\/Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-2.jpg\/v4-460px-Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-2.jpg","bigUrl":"\/images\/thumb\/6\/6d\/Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-2.jpg\/aid8840268-v4-728px-Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-2.jpg","smallWidth":460,"smallHeight":288,"bigWidth":728,"bigHeight":455,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

Advertisement
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/77\/Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-3.jpg\/v4-460px-Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-3.jpg","bigUrl":"\/images\/thumb\/7\/77\/Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-3.jpg\/aid8840268-v4-728px-Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-3.jpg","smallWidth":460,"smallHeight":288,"bigWidth":728,"bigHeight":455,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

Press Alt + ↵ Enter key and repeat it for multiple lines.

Method 2

Method 2 of 2:

Using a Function

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/ba\/Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-4.jpg\/v4-460px-Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-4.jpg","bigUrl":"\/images\/thumb\/b\/ba\/Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-4.jpg\/aid8840268-v4-728px-Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-4.jpg","smallWidth":460,"smallHeight":288,"bigWidth":728,"bigHeight":455,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

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.
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d9\/Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-5.jpg\/v4-460px-Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-5.jpg","bigUrl":"\/images\/thumb\/d\/d9\/Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-5.jpg\/aid8840268-v4-728px-Get-a-New-Line-in-Same-Cell-in-Google-Sheets-Step-5.jpg","smallWidth":460,"smallHeight":288,"bigWidth":728,"bigHeight":455,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

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.

Expert Q&A

Search

Add New Question

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

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
Helpful 0 Not Helpful 0

Submit a Tip

All tip submissions are carefully reviewed before being published

Submit

Thanks for submitting a tip for review!

Log in

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

Things You Should Know

Steps

Keyboard Shortcuts

Using a Function

Expert Q&A

Tips

You Might Also Like

About This Article

Is this article up to date?

About This Article

Quizzes

You Might Also Like

Featured Articles

Trending Articles

Featured Articles

Featured Articles

Watch Articles

Trending Articles

Explore Categories