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

PDF download Download Article
Add line breaks to a cell using easy keyboard shortcuts and formulas
PDF download 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.
Method 1
Method 1 of 2:

Keyboard Shortcuts

PDF download Download Article
  1. {"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>"}
  2. {"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
  3. {"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.
    4. Advertisement
Method 2
Method 2 of 2:

Using a Function

PDF download Download Article
  1. {"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>"}
    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. {"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>"}
    • 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.
    3. 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
        Helpful 0 Not Helpful 0


      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      How to
      Delete Google Photos and Keep Them on Your iPhone
      How to
      Sign Up for a New Google Voice Phone Number
      How to
      Disable Google Safe Search
      2 Simple Ways to Unsync Google Photos
      How to
      Restore Google Authenticator if You Lost or Reset Your Phone
      Dark Mode in Google Docs: Easy Steps for Desktop & Mobile
      How to
      Sign Out of Your Google Account on All Devices at Once
      2 Easy Ways to Permanently Delete (or, Hide) Your YouTube Channel
      Google Docs: 4 Ways to Delete Extra Pages in Your Document
      How to
      Use Google Translate: Complete Beginner's Guide
      How to
      Step Seeing Google Ads on PC or Mobile Devices
      How to
      Fix the "Google Play Store Has Stopped" Error
      Reverse Image Search in Google Lens: Android, iPhone, & Desktop
      5 Ways to Customize & Fix the Google Toolbar on Google Chrome
      Advertisement

      About This Article

      Thanks to all authors for creating a page that has been read 170,291 times.

      Is this article up to date?

      Advertisement