• 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 August 29, 2019 by Kat Armstrong Leave a Comment

There are many different scenarios in which you would want to add multiple lines of text within a single cell in Google Sheets. For instance, you may need to describe the calculations you are making. Perhaps you wish to detail line items on a budget. Whatever the reason, getting all of your text to fit into a single cell while still keeping your spreadsheet looking professional and appealing to others.

Thankfully, there are several different ways to easily achieve this goal – a couple of which I did not even know myself until today. Let’s take a look at the easiest and most popular methods.

Use a Keyboard Shortcut

Double-click within the cell you need to create more lines. If there are already words within the cell, place the cursor where you wish your line break to be and then press both the ”ALT” and ”Enter” keys at the same time. If the cell does not already have text in it, just double-click the cell and press the two keys several times until you achieve the number of text rows you want to have.

Using the Char Function

Click the cell you wish to add extra rows to and type the following formula: =char(10). You will not see the formula show up if you copy and paste it, but the rows will be added automagically. If you type it by hand, the formula shows up and then just press the ”Enter” button to make it disappear and the row appear.

If you wish to insert several blank lines using this method, you are going to need to mess around with this formula to suit your needs. For instance, go to the cell and type this formula: =rept(char(10),8). This inserts eight blank lines within the same cell. You can change that number eight to any number that works for you.


Suggest Google Add Row Sizing Options!

Unfortunately, at this time you cannot keep a uniform row height… not even by right-clicking on the row and changing the row height. Hopefully, Google will add this in the near future. In the meantime, you can always feel free to suggest it to them by clicking ”Help” at the top of the page and choosing ”Report a Problem.”

Many people do not realize this feature is not only used to report actual problems. It is also used by the Google team to receive feedback and ideas. Give a detailed description of what you would like to see – and why! – and include relevant screenshots, such as one showing my now-messy worksheet.

What other Google Sheets conundrums could you use tips for? I’m always happy to help.

Happy creating!

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

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 Set Up a Recurring Meeting in Teams
  • Fix: Microsoft Teams Keeps Freezing My Computer
  • Are you having problems with the Galaxy S21 Wi-Fi? Here’s how you can fix it
  • How to Migrate Skype For Business Users To Teams
  • How to Get the Most out of Google Files App
  • Fix Microsoft Teams Channel Email Not Working
  • Microsoft Teams: Cannot Create New Folder in Files
  • Fix: Microsoft Teams Guests Can’t Chat

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