• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About Technipages
Google Sheets: Add Multiple Lines of Text in Single Cell

Google Sheets: Add Multiple Lines of Text in Single Cell

By Mel Hawthorne 16 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 Slides: How to Delete Single Slide
    Google Slides: How to Delete Single Slide
  • How to Convert Google Sheets to PDF
    How to Convert Google Sheets to PDF
  • Google Sheets: How to Shade Every Other Row
    Google Sheets: How to Shade Every Other Row
  • Troubleshooting Google Sheets Goes Blank
    Troubleshooting Google Sheets Goes Blank

Filed Under: Software Tagged With: Google Sheets

Reader Interactions

Comments

  1. 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

  2. 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,.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

  8. 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.

  9. 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 )

  10. 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!)

  11. 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*

  12. Naomi Paul says

    June 16, 2021 at 8:03 am

    LIFE SAVER!!! THANK YOU!!

  13. Lacie says

    March 4, 2021 at 7:33 pm

    OMG! This saved my lifeeee.

  14. Ethan says

    December 8, 2020 at 10:58 am

    How to do this on mobile?

  15. Rob says

    October 26, 2020 at 7:20 am

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

  16. 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

  • Windows 11: How to Fix Windows 11 Won’t Connect to a Network
  • What to Do When Firefox Won’t Load a Page
  • Chrome: How to Refresh Various Tabs Simultaneously
  • The Latest Foldable Phones – A Look At The Huawei Mate X2
  • Everything Announced at Google I/O 2022 That You Should Care About
  • How to Build the Best High-Spec PC for Your Budget
  • Google Shows Off Pixel 7 and Pixel Watch Ahead of Fall Launch
  • Windows 11: How to View Saved Passwords

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 2022 Technipages · All Rights Reserved · Privacy