How do you make cells expand vertically to fit text automatically in Google Sheets?

1. Wrap Text on Google Sheets via Toolbar
2. Wrap Text on Google Sheets via Format tab
3. Wrap Text on Google Sheets via Mobile App
4. Manually Wrap Text on Google Sheets
5. Other Things to Keep in Mind

Suppose youre entering some data in a spreadsheet, and its time to input some addresses (or descriptions or any other long strings). Youll probably run into an issue like this:

The text is too long to fit in the cell, so it either continues past the column or cuts off (if theres another column filled next to it). Weve all been there.

This is where Google Sheets wrap text feature comes in. Wrapping text means your inputted string will automatically fit to the column width by extending cell height via new line breaks. For instance, when wrapped, my Notes text now looks like this:

There are several ways to wrap text on Google Sheets, so well go through them all and let you know which best suits certain use-cases. Lets begin!

‍

Wrap Text on Google Sheets via Toolbar

This is the quickest method and only requires a couple of clicks!

1. Open spreadsheet on Google Sheets.
2. Select the cells, columns, or rows you wish to text-wrap.
3. Locate Toolbar (row full of formatting buttons above your sheet) > Click Text wrapping button (two parallel vertical lines with a horizontal arrow through the middle). Note: If the Text wrapping button doesnt immediately appear on your Toolbar, click on the More button (three dots in a row) and it should appear in a drop-down underneath.
   

‍

1. Click the Wrap button (two parallel vertical lines with a curved arrow in the middle).
   

1. Voila! Your text should now be wrapped within the cell.

Wrap Text on Google Sheets via Format tab

This is another easy method to wrap text. You may opt for this one if youre having a hard time locating the Text wrapping button.

1. Open spreadsheet on Google Sheets.
2. Select the cells, columns, or rows you wish to text-wrap.
3. Go to Format > Text wrapping > Wrap.

Wrap Text on Google Sheets via Mobile App

If youre looking to format your spreadsheet on the go, you can even wrap text on the Sheets mobile app! Check it out below.

1. Open spreadsheet on Google Sheets.
2. Select the cells, columns, or rows you wish to text-wrap.
3. Press the Formatting button on the top right (icon of the letter A with horizontal lines) > Click the Cell tab > Toggle Wrap text button on.
   

‍

Manually Wrap Text on Google Sheets

While this isnt the most convenient option, sometimes you may want to manually format your text to choose where the line breaks occur and/or control the width of your lines independent of the cell width. Heres how you do it:

1. Open spreadsheet on Google Sheets.
2. Select cell > Move text cursor to desired line break location > Press Ctrl + Enter.
3. Repeat step 2 as necessary.
   

Note: As you can see, the columns text-wrapping setting is still overflow (aka text visually spills into the next cell if empty), but Ive manually entered line breaks at random places, which varies the width of the text in each cell.

‍

Other Things to Keep in Mind

Column Width

Once you start wrapping text, youll find out that setting an appropriate column width is crucial in nice formatting. You likely dont want a bunch of words stacked on top of each other like this:

Yikes! In this case, be sure to extend your column width so the spreadsheet is more readable. Now, this is much more appealing:

‍

Other Text Formats

Its also important to keep other text wrapping options in mind, so youre aware of all your options when formatting your spreadsheet! There are the three following styles:

• Overflow: text will visually spill into the next cell if its empty (set as default).
• Wrap: text will automatically fit to the column width by extending cell height via new line breaks.
• Clip: text will be contained to the column width and height, but any content beyond that will not be visible.