How to wrap text in Google Sheets (easy guide)

There are times when cells contain long strings of text, like addresses or descriptions. If the text is longer than the width of the cell, it will spill over the empty cell to the right or be clipped if the next cell isn’t empty. This makes it uncomfortable to read the text since you have to resize the cell or click on it and scroll in the formula bar. Fortunately, there are several ways to wrap the text in your cells so that this doesn’t happen.

In this guide, you will learn to wrap text in Google Sheets using the toolbar button and the ‘Format’ menu options. You will also learn how to wrap text in the Google Sheets app on iOS and Android. Finally, you will learn how to use the line break shortcut to force the text to wrap.

How do I wrap text in Google Sheets?

There are several ways to wrap text in Google Sheets. The quickest way is to select the cells where you want to wrap the text and click the wrap text button on the toolbar. Alternatively, select the cells and go to Format > Wrapping > Wrap.

How to wrap text in Google Sheets via the toolbar?

Follow the steps below to wrap text using the toolbar button.

1. Select the cells containing the text you want to wrap.

2. Click on the text wrapping button on the toolbar.

3. That’s it. The text is wrapped.

How to wrap text in Google Sheets via the Format menu?

Follow the steps below to use the menu options to wrap the text in cells.

1. Select the cells containing the text that needs to be wrapped.

2. Go to Format > Wrapping > Wrap.

3. That’s it. The text is wrapped.

How to wrap text in Google Sheets in the mobile app?

iOS mobile app

Follow the steps below to wrap text in the Google Sheets app on iOS.

1. Select the cells with the text you want to wrap.

2. On the toolbar, click on the text wrap button.

3. The text now wraps at the cell’s current width.

Android mobile app

Follow the steps below to wrap text in the Google Sheets app on Android.

1. Select the cells with the text you want to wrap.

2. On the toolbar, click on the text formatting button.

3. Click on the ‘Cell’ tab.

4. Toggle ‘Wrap text’ on. The text now wraps at the cell’s current width.

What is the shortcut to wrap text in Google Sheets?

Double-click the cell containing the text. Place the cursor at the point in the text where you want to insert the line break. Press Alt + Enter (Mac: Ctrl + Enter) and repeat to add more breaks. This forces the text to wrap at a specific width, but you have to apply it individually to each cell.

1. Select the cell containing the text and double-click to edit.

2. Place the cursor where you want to insert the line break and press Alt + Enter (Windows) or Ctrl + Enter (Mac).

3. The text after the line break has moved below the rest of the text.

Why is my text not wrapping in Google Sheets?

If your text isn’t wrapping despite having the option selected, the most likely reason is that the cell is currently wider than the length of the text. Try resizing the column so that the width is less than the length of the text, and it should wrap automatically.

Conclusion

Wrapping text can make it easier to read the contents of your cells. Cells containing text longer than the width of the cell will either spill over or be clipped by the cell to the right. This can make it difficult to read the contents without resorting to resizing the column. However, this can distort the layout of other cells. You can avoid this problem using the text-wrapping option.

You now know how to wrap the contents of cells using the toolbar button and the menu option in Google Sheets. You also know how to wrap text in the Google Sheets mobile app. Finally, you know how to use the line break shortcut to force the text to wrap at a specific point. However, this technique needs to be applied to each cell individually. Additionally, if the column is resized to a smaller width, the effect will be lost, and the contents could end up looking very strange.

If the sheet still looks crowded after wrapping, merging cells for headers that span several columns, or freezing the header row, usually helps. For the numbers themselves, see how to format cells in Google Sheets.