How to Wrap Text in Google Sheets

Google Sheets can be used to store various types of data. It could be Names, Address, long form text, links, etc. In most of the cases, when the text in the cell is long and goes out to the cell, there is a need to wrap it within the cell.

Wrap Text in Google Sheets

In this tutorial, you’ll learn how to wrap text in Google Sheets.

Below I have names of some of my favorite fictional characters and their address:

How to Wrap Text in Google Sheets - Address

Note that since the address is longer than the width of the cell, it overflow and extends out of the cell. You may want to keep it within the cell if you have more text in adjacent cells (or simply for aesthetic purposes).

Here is how to get this done:

  • Select all the cells for which you want to wrap text.How to Wrap Text in Google Sheets - select cells
  • Go to Format –> Text Wrapping –> Wrap.How to Wrap Text in Google Sheets - wrap text

This would wrap the text and make it fit within the cell.

How to Wrap Text in Google Sheets - wrapped text

Note that this will auto fit the row height to adjust the content in the cell.

There is another option to clip the text. You may want to use it when you want to maintain data but don’t want to read it. For example, URLs can be a great example where you may want to use the clip option. Note that this wouldn’t clip the URL or any text in the cell, it will simply display you a clipped version.

You May Also Like the Following Google Sheets Tutorials:


10 Google Sheets Tips that will save you hours every week

Bar Sparkline in Google Sheets - rtl
Google Sheets

Sparkline in Google Sheets – The Only Guide You Need

Sparklines are miniature charts that you can create within a cell. These are quite useful when you’re creating a dashboard and want to quickly show a trend, seasonal increase or decrease, or outliers (maximum/minimum) visually. According

Google Sheets

How to Insert Timestamp in Google Sheets

Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work in the sheet simultaneously. In this tutorial, you’ll learn various to insert timestamp in Google

Google Sheets Keyboard Shortcuts - Spreadsheets
Google Sheets

101 Google Sheets Keyboard Shortcuts

Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following and I see a lot of people migrating from other spreadsheets applications to Google Sheets.