• Skip to main content
  • Skip to primary sidebar

Technipages

Smart phone, gadget and computer tutorials

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • 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

Posted on April 1, 2020 by Mel Hawthorne 4 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…
  • 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. Lacie says

    March 4, 2021 at 7:33 pm

    OMG! This saved my lifeeee.

  2. Ethan says

    December 8, 2020 at 10:58 am

    How to do this on mobile?

  3. Rob says

    October 26, 2020 at 7:20 am

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

  4. Rob says

    October 26, 2020 at 7:18 am

    NO, this doesn’t work!

Did this help? Let us know! Cancel reply

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

  • How to Increase the Size of Text on Any Website on iPad
  • Chrome: How to Fix Can’t Scroll Using Scrollbars
  • Samsung Galaxy S 21 Plus: How to Check How Much Memory Is Left
  • Google Photos: How to Export Your Albums
  • Bitwarden: How to Deauthorize All Sessions
  • Bitwarden: How to Clone an Entry
  • Bitwarden: How to View Your API Key
  • How to Fix Microsoft Teams Error 0xcaa80000

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.

Follow me on Twitter, or visit my personal blog.

You May Also Like

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

© Copyright 2021 Technipages · All Rights Reserved · Privacy