Don’t forget to share this post

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. 1. Select the cells containing the text you want to wrap.
How to Wrap Text in Google Sheets Easy Guide Select Cells
How to Wrap Text in Google Sheets (Easy Guide) - Select Cells
  1. 2. Click on the text wrapping button on the toolbar.
How to Wrap Text in Google Sheets Easy Guide Toolbar Wrap Text Button
How to Wrap Text in Google Sheets (Easy Guide) - Toolbar Wrap Text Button
  1. 3. That’s it. The text is wrapped.
How to Wrap Text in Google Sheets Easy Guide Wrapped Text
How to Wrap Text in Google Sheets (Easy Guide) - Wrapped Text

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. 1. Select the cells containing the text that needs to be wrapped.
How to Wrap Text in Google Sheets Easy Guide Select Cells 2
How to Wrap Text in Google Sheets (Easy Guide) - Select Cells
  1. 2. Go to Format > Wrapping > Wrap.
How to Wrap Text in Google Sheets Easy Guide Format Text Wrapping
How to Wrap Text in Google Sheets (Easy Guide) - Format > Text Wrapping
  1. 3. That’s it. The text is wrapped.
How to Wrap Text in Google Sheets Easy Guide Wrapped Text 2
How to Wrap Text in Google Sheets (Easy Guide) - Wrapped Text
How To Share Only One Tab in Google Sheets
How To Share Only One Tab in Google Sheets

When sharing a Google Sheets spreadsheet Google usually tries to share the entire document. Here’s how to share only one tab instead.

READ MORE

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. 1. Select the cells with the text you want to wrap.
How to Wrap Text in Google Sheets Easy Guide Select Cells 3
How to Wrap Text in Google Sheets (Easy Guide) - Select Cells
  1. 2. On the toolbar, click on the text wrap button.
How to Wrap Text in Google Sheets Easy Guide Toolbar Text Wrap Button
How to Wrap Text in Google Sheets (Easy Guide) - Toolbar Text Wrap Button
  1. 3. The text now wraps at the cell’s current width.
How to Wrap Text in Google Sheets Easy Guide Wrapped Text 3
How to Wrap Text in Google Sheets (Easy Guide) - Wrapped Text

Android Mobile App

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

  1. 1. Select the cells with the text you want to wrap.
How to Wrap Text in Google Sheets Easy Guide Select Cells 4
How to Wrap Text in Google Sheets (Easy Guide) - Select Cells
  1. 2. On the toolbar, click on the text formatting button.
How to Wrap Text in Google Sheets Easy Guide Toolbar Text Formatting Button
How to Wrap Text in Google Sheets (Easy Guide) - Toolbar Text Formatting Button
  1. 3. Click on the ‘Cell’ tab.
How to Wrap Text in Google Sheets Easy Guide Cell Formatting
How to Wrap Text in Google Sheets (Easy Guide) - Cell Formatting
  1. 4. Toggle ‘Wrap text’ on. The text now wraps at the cell’s current width.
How to Wrap Text in Google Sheets Easy Guide Text Wrapped
How to Wrap Text in Google Sheets (Easy Guide) - Text Wrapped
How to Password Protect a Google Sheet
How to Password-Protect a Google Sheet?

If you work with important data in Google Sheets, you probably want an extra layer of protection. Here's how you can password protect a Google Sheet

READ MORE

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. 1. Select the cell containing the text and double-click to edit.
How to Wrap Text in Google Sheets Easy Guide Edit Cell Containing Text
How to Wrap Text in Google Sheets (Easy Guide) - Edit Cell Containing Text
  1. 2. Place the cursor where you want to insert the line break and press Alt + Enter (Windows) or Ctrl + Enter (Mac).
How to Wrap Text in Google Sheets Easy Guide Place Cursor Alt Enter OR Ctrl Enter
How to Wrap Text in Google Sheets (Easy Guide) - Place Cursor & Alt + Enter OR Ctrl + Enter
  1. 3. The text after the line break has moved below the rest of the text.
How to Wrap Text in Google Sheets Easy Guide Text Wrapped 4
How to Wrap Text in Google Sheets (Easy Guide) - Text Wrapped

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.

Hady ElHady
Hady is Content Lead at Layer.

Hady has a passion for tech, marketing, and spreadsheets. Besides his Computer Science degree, he has vast experience in developing, launching, and scaling content marketing processes at SaaS startups.

Originally published Feb 9 2023, Updated Jun 26 2023

Layer is now Sheetgo

Automate your procesess on top of spreadsheets