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:

Spreadsheet Expert at Productivity Spot | Website | + posts

Google Sheets and Microsoft Excel Expert.