How To Wrap Text In Google Sheets

We look at how to wrap text in google sheets. We go through each step with added screenshots and then tell you how to unwrap the text if needed.

How To Wrap Text In Google Sheets

PC Guide is reader-supported. When you buy through links on our site, we may earn an affiliate commission. Prices subject to change. Read More

Last Updated on

How would you like to create a Google Sheet that automatically wraps text into columns? This tutorial shows you how to do it using formulas.

Google Sheets is a spreadsheet application that allows you to store data and organize information. It has become very popular because it is free and simple to use.

You can easily create a column that contains text or numbers, but sometimes you want to add a little bit of flair to your document without hiding any of the text. In this case, you can use the Wrap Text function.

This tutorial will show you how to wrap text in Google Sheets and go through each step in a step-by-step guide, including screenshots to help you along the way.

1

How to Wrap Text In Google Sheets

This tutorial will show you how to wrap text in Google Sheets:

How To Wrap Text In Google Sheets

Step

1

Create A New Spreadsheet

Before we start creating our new spreadsheet, let’s make sure we have all the tools available on our computers. We need to download and install Google Drive.

If you don’t already have it installed, search for it online for more details.

After installing Google Drive, open it up from the Start menu.

You should see a screen similar to this one:

Now click on the + icon in the top-right corner of the window.

Give your new document a name and then select where you want to save it before saving.

Create A New Spreadsheet

Step

2

Select The Cell With The Text That You Want To Wrap

In the screenshot below, you can see that cell A1 includes a sentence that does not fit in the cell.

Select The Cell With The Text That You Want To Wrap.

Step

3

Open Up The ‘Text Wrapping’ Menu

You can do this in a variety of ways. First, you can click on the symbol found in the toolbar which looks similar to a curved arrow.

Open Up The 'Text Wrapping' Menu

Alternatively, you can click “format” in the toolbar and then go to “text wrapping”.

wrap text

You will then click ‘wrap’ to wrap your text.

Step

4

Adjusting The Column Width

This step is optional, but you can adjust the column width containing the cell that you wrapped the text for.

If you do decide to do this, the height of the wrapped cell rows will adjust to fit the text and it should look something like this.

Adjusting The Column Width

After doing so, the sentence fits inside of a single cell and column A has been expanded to give more horizontal space for the text in the cell.

If your column is too thin when you wrap a chunk of text, your row height can become very tall.

This means that when you have a lot of text in one cell, it can be helpful to give the cell more space by adjusting the column before applying the “wrap” function.

2

How To Unwrap Text In Google Sheets

This tutorial will show you how to unwrap text in Google Sheet:

Step

1

Unwrap Text

If you decide you don’t like how the text looks when it is wrapped, especially if you are inputting a lot of data you would rather be all in one line, you should click on the cells that have the text that you need to unwrap.

Then open up the “text wrapping” option from the toolbar again, or find the “format” menu, and click on “overflow”.

unwrap text

unwrap text

The text will then overflow into the cell to the right and will have returned to its default setting.

Final Thoughts

We hope after reading this article you have learned how to successfully wrap and unwrap text in a Google Sheet. Although Google Sheets takes a bit of practice to navigate and use, this is one of the simpler tricks you will learn along the way.