NorthStar Analytics

HiDocs High-Quality Ghost Documentation Theme

How to wrap text in Google Sheets?

How to wrap text in Google Sheets?

Sometimes text doesn't fit inline and overflows in Google Spreadsheets. In such cases, we can fit the text into the cell, or display only the part we want. The text is shaped depending on the size of the cell.  If the cell is narrow and the text is long, the cell will grow downwards.

How to Wrap Text Using Menu?

  1. Select cell/s (which you want to wrap text)
  2. Format->Wrapping->Wrap

When we choose Wrap, it fits the text inside the cell like this.

How to Wrap Text Using Toolbar?

We can do text wrapping from the menu as well as from the toolbar. First, make a selection and click text wrapping in the toolbar.

What are other Text Wrap Types?

When we select the cells and come to the wrap text icon, there are three options:

  1. Overflow
  2. Wrap
  3. Clip

We have just analyzed what wrapping does above, that is, fitting texts into the cell. Now let's look at the others.

Overflow; distributes the texts that fit inside the cell back into the cell. Overflows other cells.

Clip; cuts the text at the end of the cell. It looks like deleted, but when double-clicked on the cell, invisible parts can be seen. The example below -> Text Clip ( a part of the cell is visible, the invisible part is not deleted)

How to Remove ‘Wrap Text’?

Let's remove the wrapping process to restore the cells we selected. Allow text inside cells to overflow into other cells:

  1. Select cell
  2. Format->Wrapping->Overflow

That's it! I hope it was helpful.

Make your business data transparent!
  • Subscribe to a package

    Subscribe and explore the limits of your business with data or thinking to expand your agency value proposition with Google Data Studio dashboards?

  • Request unlimited dashboards

    You can request as many dashbaords you might have and as many revisions as you might need. We create a queue of your tasks, the first tasks that come in are the tasks that we’ll deliver first.

  • Your Data Studio Department

    Optimise your business with complete transparency through dashboards or provide value-added Google Data Studio service to your agency clients.

Make your business transparent

The fastest easy-to-use Google Data Studio dashboards without any recurring cost.