The Reject Guide on how to wrap text in Google Sheets

Wrap texts in cells in Google Sheets.

How to Wrap Text in Google Sheets

Looking for information on how to wrap text in Google Sheets? Our complete how-to guide will help you through it step-by-step.

Wrapping text in Google Sheets is a fairly easy process. But before we get into that, here’s a bit of housekeeping…

What does wrapping text do?

To “wrap” text means resizing your cell’s height to fit your text. You’d want to wrap text if you have long stretches of text in one single cell. It saves height space and ultimately improves workflow.

For this guide, we’re looking to fix this mess of a table:

How to Wrap Text in Google Docs

How to wrap text in Google Sheets

Wrapping text in Google Sheets is a fairly straightforward process. Here’s how you can do it.

1.) Go to the Google Sheets homepage and fire up your spreadsheet document.

2.) Highlight the cells whose text you wish to wrap inside. Personally, I find it easier to select the entire document by hitting Ctrl + A.

How to Wrap Text in Google Docs

3.) Go to Format > Text Wrapping. Select Wrap. This will effectively wrap the text in your selection within their respective cells.

How to Wrap Text in Google Docs

You can also use the above shortcut in the toolbar.

4.) That’s it! You have wrapped your text.

How to Wrap Text in Google Docs

The above screenshot shows what your text should look like now.

How to unwrap (overflow) text in Google Sheets

If you want to revert a wrapped text in Google Sheets, you need to apply an “overflow” text wrapping. To overflow text means to spill the excess text to the next cell, like in the first image we’ve shared.

Here’s how to overflow text in Google Sheets:

1.) Go to the Google Sheets homepage and fire up your spreadsheet document.

2.) Highlight the cells whose text you wish to overflow.

How to Wrap Text in Google Docs

3.) Go to Format > Text Wrapping. Select Overflow. This will effectively wrap the text in your selection within their respective cells. Selecting Cut will achieve a similar effect, except it won’t spill out the excess text.

How to Wrap Text in Google Docs

You can also use the above shortcut in the toolbar.

4.) That’s it! You have unwrapped your text.