How to Wrap Text in Google Sheets

Fix your clipped text.
Michael Michael (174)
0

If you find that your text is getting clipped within a cell or is extending the cell horizontally, you can set the text to wrap in Google Sheets. We'll show you how to set the text to wrap, as well as the other options you have for your text within a cell in Google Sheets.

What is text wrapping in a spreadsheet?

When you set the text to wrap in a spreadsheet like Google Sheets, text that is longer than a cell will automatically extend the cell vertically, as it does in a word processing program.

Google WorkspaceGoogle Workspace ×1

Howchoo is reader-supported. When you buy through links on our site, we may earn a small affiliate commission at no cost to you.

Selected cell Google Sheets

You can select individual cells, all the cells of particular rows or columns, or all the cells in the entire spreadsheet.

How to select individual cells in Google Sheets

Simply click on the cell to select. Hold shift and click other cells to select more than one.

How to select a row or column in Google Sheets

Click on the corresponding letter (if selecting verticle column) or number (if selecting horizontal row).

How to select the entire spreadsheet in Google Sheets

select all cells google sheets

Click on the gray box at the top-left of the spreadsheet—where the numbers and letters begin.

Text wrap button google sheets

Once you've selected the cells you want text wrap, you click the text wrap button (see image above) and then wrap. You can also:

  • Go to Format.
  • Select Text wrapping.
  • Select Wrap.

What's the difference between "wrap" and "clip"?

When you "clip" text in Google Sheets, the text will appear to stop at the end of the cell. When you click on the cell, however, you can still see the entire text it contains.

To create a drop-down list, you "group" the rows.
Michael Michael (174)
0

In Google Sheets, you create a drop-down list by "grouping" the rows of your spreadsheet.