How to wrap text in Google Sheets [All Devices]

Device links

• Android
• iPhone
• Chromebook
• Mac
• windows
• Device missing?

When using Google Sheets or other table editing software, you can often enter more data than the cells can properly display. When that happens, wrapping your text can be your best friend. The text wrapping function will adjust the height of the rows to show everything inside the cells.

This article will tell you how to enable text wrapping on all devices you use for Google Sheets.

How to wrap text in Google Sheets on an iPad

Google Sheets is known for its ability to transcend platforms. You can use them on your phone, tablet or PC, and have all the tables with you wherever you go. If you are using Google Sheets on your iPad, the steps are simple:

1. Select the cell for which you want to wrap the text.
2. If you want to select multiple cells in an area, drag the blue selection marker to cover all the required cells. You can click a row to select all cells in that row. The same applies to columns.
3. You can press the cell above the rows and to the left of the column markers to select each cell in the table.
4. Press the format button at the top; It looks like an A with four lines to its right.
5. Select the Cell tab from the menu. Scroll down until you see Wrap Text.
6. Activate the Wrap Text function.
7. Tap the sheet to save changes.

How to wrap text in Google Sheets on an iPhone

If you access your sheets through an iPhone, follow a similar set of steps:

1. Open the Google Sheets app and the document you need to edit.
2. Select the cell where you need to wrap the text or drag the selection area to cover all the cells you need to format. You can select rows or columns by pressing their appropriate number or letter or select the entire table by pressing the top left cell (above the row markers).
3. Press the format button in the top menu.
4. Select the Cell tab and scroll down to the Wrap Text option.
5. Turn on Wrap Text.
6. Tap the sheet to save your settings.

How to wrap text in Google Sheets on an Android device

Using Google Sheets on Android is just as simple:

1. Open the document you need to edit.
   
2. Tap the cell that needs to be formatted. You can move the selection area by dragging the blue circle. You can select an entire row or column by pressing its number or letter. You can select the entire table by pressing the cell to the left of the column marker.
   
3. Press the format button (the A with the small lines) in the top menu.
   
4. Select the Cell tab, then scroll down until you see the Wrap Text option.
   
5. Activate the Wrap Text option.
   
6. Tap the check mark to save the format settings.
   

How to wrap text in Google Sheets on a Windows PC, Mac, or Chromebook

If you’re using a PC, Google Sheets doesn’t have a dedicated app. However, it works perfectly in any browser of your choice. Once you open the document you need to work on, adjusting the text is easy:

1. Click on the cell you need to format. You can select an entire row or column or multiple cells by selecting them together. You can also click the top left cell to select the entire table and format it at once.
   
2. In the top menu, click Format.
   
3. When you hover over Wrapper, you’ll see three options.
   
4. Select the Wrap option to wrap the text and adjust the height of your cell automatically.
   
5. You can select the Overflow option to have the text flow to the next cell. It could make your table harder to read.
   
6. The Trim option will visually trim the text to fit within the current cell size. You can click the cell later to display its full contents.
   

Additional FAQs

What exactly does wrapping text do in Google Sheets?

There are three main text wrapping modes.

1. Overflow is the default mode in Google Sheets. When this mode is activated, any additional text will move to the next cell. Text overflow will typically make the table difficult to read. If the cell where the text will overflow is not empty, Google Sheets will visually clip the overflowed content. You can click on the cell to display all its contents in the top menu.

2. Wrap will adjust the height of your cell (in terms of rows) to visually fit the entire contents of the cell. That means that if a cell in the row has wrapped text, all cells in that row will be one row taller.

3. Cropping means that any content larger than the current cell size is hidden. You can click the cell to display the full text. You may not want to wrap the text if there is a cell that is abnormally large compared to all the other cells in the table, as that will make the table look crooked. You may also want to avoid wrapping the text in cells that contain links, as they may become excessively long and mess up the entire table as a result. Trimming the links will hide them in the background. Alternatively, use hyperlinks as they are more readable by default.

Before you decide to use text wrapping, try adjusting the length of your cells. Note that longer cells are less likely to need this. If your cells frequently contain lists, it’s a good idea to wrap the text to display all the listed items at once without needing to click on them one by one. Generally speaking, text adjustment is done on a case-by-case basis. Typically, your table will look more attractive if the text wraps to the end of the cell rather than cutting it off.

The recapitulation

Now you know how to wrap text in Google Sheets quickly and efficiently. Use the instructions outlined above to make your next board look much nicer to look at and easier to navigate. Charts and graphs are an essential part of any business meeting and it would be a shame if they were ruined by incomplete sentences.