Google sheets is a very handy productivity tool that allows for the seamless sharing of spreadsheets with colleagues and friends. It makes it very easy to collaborate on projects both big and small, but it can be a bit tricky at times. Not only do you often find yourself dealing with large sets of numbers, but also text. The way that it is set up by default can make it difficult to work with larger text blocks, so here’s a handy guide to teach you how to wrap text in Google Sheets.
What does wrapping text do?
By default, text aligns to the left of the cells. It is also set to overflow into the next cell, which usually means you will not be able to read everything in each cell without clicking on it. This can be a pain, especially when you are working with a lot of text. That is where text wrapping comes in, as it allows you to control the way that the cells display extended amounts of data within each cell.
There are a few different options to choose from. If you select the wrap option as we will show you below, all of the cells will expand vertically to show all of the text (or numbers) within them. There are also some other handy formatting tools to be aware of, but first, let’s go through how to wrap text in Google Sheets.
How to wrap text in Google Sheets on a desktop
- Select the cell(s) that you want to wrap the text within
- Click on the Format tab
- Hover over the Text Wrapping options to reveal three choices — Overflow, Wrap, and Clip
- Click Wrap
How to wrap text in Google Sheets on mobile
- Select the cell(s) you want to format
- Tap the format button (the A with lines next to it up the top right)
- Turn the Wrap text option on
Other formatting options
On mobile, you will notice that there is only one option, which is to turn text wrapping on or off. However, on a desktop, you are able to select overflow or clip as well. These options are very similar, but the main difference is that if you select overflow, any cells with extensive text that do not have filled cells next to them will simply overflow into them. When you select clip, the text will simply be cut off by the next cell. You can see the difference in the two screenshots below.
Clip – notice that the furthest right text blocks are clipped by the adjacent cells.
Overflow – here, the text flows into the empty cells on the right.
Wrapping all of the text at once
Another thing to note is that you can also apply the wrapping option to the entire spreadsheet very easily. The method is the same on both mobile and desktop versions, and you simply just need to click the blank cell in the top left-hand corner. Once again, hit the Format button and wrap the text as you did before.
There you go, everything you could want to know about wrapping text in Google Sheets. As you slowly become more comfortable with Google’s program, you’ll be able to dive into some more advanced features. Be sure to keep practicing as much as possible!