• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Google Sheets: Add Multiple Lines of Text in Single Cell

Google Sheets: Add Multiple Lines of Text in Single Cell

April 1, 2020 by Mel Hawthorne 22 Comments

Usually, in a spreadsheet, you’ll have one line of text, one piece of information per cell. Whatever the data may be – an amount, a date, anything really. In some instances that may not be the case though; you may find yourself wanting to keep an entire address in a field, for example, or a few sentences of a description.

Thankfully, you can – to type information into more than one line in a Google Sheets cell, click on the cell in question and type the first line of your content in.

Then, press Alt + Enter on your keyboard (or Option + Enter if you use a Mac) to get to a new line. Type your info into the second line as well and either use Alt + Enter again or click somewhere else to go to a different cell!

A cell with two lines of text

The info will expand your cell to the necessary size unless you manually set it to be smaller. If so, you can still double-click on the cell in order to see everything in it.

You Might Also Like

  • Google Sheets: Add Multiple Lines of Text in Single Cell
    Google Sheets: Add Multiple Lines of Text in Single Cell
  • How to Highlight Text in Google Sheets
    How to Highlight Text in Google Sheets
  • Android 10: Reply to Single or Multiple Messages from Notification Bar
    Android 10: Reply to Single or Multiple Messages from…
  • How to View Multiple Documents at Once in Sublime Text 3
    How to View Multiple Documents at Once in Sublime Text 3
  • iPhone 8 & X: Send Text Message to Multiple Recipients
    iPhone 8 & X: Send Text Message to Multiple Recipients
  • Google Sheets: How to Use the Google Translate Formula
    Google Sheets: How to Use the Google Translate Formula

Filed Under: Software

Reader Interactions

Comments

  1. Mark says

    January 16, 2023 at 3:43 am

    How can I add second line in cells on iPad Google Sheet version. Enter + option/control/command doesn’t work.

  2. Mohit Sharma says

    November 11, 2022 at 12:21 am

    Hi Everyone

    I used ALT+Enter for multiple lines in single cell it’s working perfectly but I want to bulk action “like formula” I don’t want to use ALT+Enter every time. If anyone have idea so please suggest me.

    Thanks in advance
    Mohit Sharma

  3. Bruce says

    October 10, 2022 at 5:30 pm

    Ctrl+Enter also works to add multiple lines in a single cell.

  4. Frae Guile says

    August 23, 2022 at 9:34 pm

    The Alt +Enter absolutely works on mobile devices IF YOU DO THE FOLLOWING:
    1. copy the link of the spreadsheet that you want to use.
    2. open up the mobile device browser and make sure that it’s in desktop mode/view.
    3. paste the spreadsheet link and go to the website
    4. select the cell you want to edit, position the cursor (⌶) where you want to add the additional line
    5. using a physical keyboard (via Bluetooth or wired), you can use Alt + Enter and you have your additional line.

  5. Andy says

    June 22, 2022 at 6:17 am

    Hi – is it possible to get a formula, e.g. vlookup, to display the results of the formula over different lines of the cell?

    e.g. I have an indirect & match formula that is returning 3 pieces of info from another sheet but I want the output of it to display the three separate returned pieces of info over three separates lines within the same cell. Is this possible?

  6. Krishna Kadam says

    May 25, 2022 at 10:31 pm

    In google excel sheet use Alt + Enter for Multiple line
    Shift + enter is only working for MS excel

  7. Kartik Agarwal says

    May 4, 2022 at 5:30 am

    It is not working, I am unable to add 2 lines in a single cell by pressing Alt + Enter

  8. Mike says

    February 17, 2022 at 11:22 am

    You can just use a table in a Google Doc instead of a spreadsheet. I realize this won’t work for some people in some instances but after trying way to long to get multiple lines in a spreadsheet I figured out I can accomplish what I needed to with a table,.

  9. Mark says

    January 31, 2022 at 9:28 am

    Thanks for the Alt-Enter tip. It saved me so many headaches. I’ve been using extra spaces, but then have horrible printing problems even though it looks fine on screen. Now I can make it look good and print too! Nice.

  10. Ross says

    January 25, 2022 at 8:16 am

    TIP: For those of you copy+pasting, double clicking in the cell before pasting will allow you to paste multiple lines of text into a single cell. If you don’t double click, it will try to break the text up between rows on the line breaks.

  11. Elizabeth says

    January 24, 2022 at 2:39 pm

    Mel, the suggested process of adding text in a cell, then adding more text in another cell and so on, is a very long and tedious process if you have a fairly large sheet of data. I don’t think it’s a very viable workaround. In MS excel, the cell just expands as you keep typing. Too much manual crafting in the sheets version.

  12. Elizabeth says

    January 24, 2022 at 2:34 pm

    That didn’t work for me. In MS excel, you can type text in a cell and set it to wrap. When you do that, the leading text is what shows in the visible part of the cell.

    I can’t figure out how to do that in google sheets on my macbook.

  13. Mr. LoForte says

    November 6, 2021 at 1:16 am

    There is absolutely no way to type more than one line in one cell in Google Sheets. I have tried every single possible recommendation here and all the other sites I have so many things and nothing works I have never had this problem before but today the day that I need it most on a deadline day and Google Sheets is giving me nothing. Google presently you suck and I’m going to use pen and paper to create my own sheet I’ve just wasted four hours. WHO IS GOING TO PAY FOR THAT????
    WHAT A BLOODY WASTE.

  14. Rod Welsh says

    September 23, 2021 at 9:37 pm

    Also, you can try to do it with merged cells , joining 2 or more cells together – if you’ve never done that before, it’s pretty straightforward.

  15. Rod Welsh says

    September 23, 2021 at 9:34 pm

    if that doesn’t work, and you’re wanting to get more than one line in a cell that’s taller from test-wrapping , to not split words up while text-wrapping, try adding long sections of spaces inbetween each word that you’re wanting to start at each point in the text-wrapping process ;

    like this ;

    ———-

    This is a demo of how to make a workaround if it doesn’t work

    ( can end up looking like this, inside a single cell )

    | This is a demo |
    | of how to |
    | make a workaround |
    | if it doesn’t work |

    ( not how the remaining distance before the end of each ‘line’ , and start of each line, lengthens or shortens how many spaces to put in – this is crude, since it will shrink/grow when text size changes and things like document-conversion , but it’s better than nothing sometimes, and simple to do )

  16. Merry says

    August 14, 2021 at 12:52 pm

    How can you get multiple lines when using Google Sheets on a mobile device? (No Alt/Option key on a device keyboard!)

  17. Lee says

    June 16, 2021 at 8:50 am

    Thank you! I was 10 seconds away from throwing my computer out the window. *crisis averted*

  18. Naomi Paul says

    June 16, 2021 at 8:03 am

    LIFE SAVER!!! THANK YOU!!

  19. Lacie says

    March 4, 2021 at 7:33 pm

    OMG! This saved my lifeeee.

  20. Ethan says

    December 8, 2020 at 10:58 am

    How to do this on mobile?

  21. Rob says

    October 26, 2020 at 7:20 am

    Oh wait! Yes, it does. I was pressing Shift instead of Alt. Haha!

  22. Rob says

    October 26, 2020 at 7:18 am

    NO, this doesn’t work!

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • 3 Ways to Choose All Files in a Folder – Windows 11
  • Apple TV+: How to Erase a Show From the Up Next List
  • How to Change the Profile Picture on Disney+
  • Local Security Policy: What Is It and How to Open It in Windows 11
  • How to Create and Erase an Alarm in Windows 11
  • 10 Best NAS Storage Device for Home and Professional Use
  • PS5 NVMe Requirements You Must Fulfill to Expand PS5 Storage
  • Steam Deck Won’t Turn On: 8 Possible Fixes You Can Try

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

You May Also Like

  • Relative Cell Reference
  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy