How To Wrap Text In Google Sheets

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.

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

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.

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

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

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.

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.

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”.

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