How to Wrap Text in Google Sheets

Learning how to wrap text in Google Sheets is beneficial when you have a lot of text to display in a single cell that you need to be visible.

When you type a lot of data into a cell in your Google Sheets spreadsheet, one of several things can happen. The text can overflow into the next cell if it’s empty, it can be forced to another line within the cell, or it can be clipped so that only the text that fits in the cell is visible.

Depending on your preferences, it’s possible that your spreadsheet cells are behaving differently than you would like in this regard. Fortunately this is something that you can adjust so that your text wrapping behaves how you want. Our article below will show you how to make that adjustment.

How to Wrap Text in Google Sheets

  1. Open the Google Sheets file.
  2. Select the cell(s) for which to adjust the text wrapping settings.
  3. Click the Text wrapping button in the toolbar.
  4. Choose the desired text wrapping option.

Our tutorial continues below with additional information on how to wrap text in Google Sheets, including pictures for the steps shown above. If you want to wrap text in Google Sheets mobile, click here to jump to that section of this article.

Click on any of the links below to jump to that section in the article, or continue scrolling down to read everything.

How to Change Text Wrapping Setting in Google Sheets (Guide with Pictures)

The steps in this guide were performed in the desktop version of the Google Chrome web browser, but will work in other desktop browsers like Safari or Edge as well.

Step 1: Sign into your Google Drive at https://drive.google.com and open the spreadsheet that you wish to modify.

Step 2: Click on the cell(s) whose text wrapping setting you wish to change.

select the cell with data to change

Step 3: Select the Text wrapping icon in the toolbar above the spreadsheet.

click the text wrapping button

Step 4: Click the text wrapping option that you would like to use.

how to change text wrapping setting in google sheets

The next section explains more about the different text wrapping settings, including examples of each option.

Examples of Google Sheets Text Wrapping Options

The text-wrapping settings in Google Sheets are:

  • Overflow – text will display in the current cell and the next cell if it’s empty
  • Wrap – text will be forced to additional lines within the current boundaries of the cell. This can adjust the height of the row automatically.
  • Clip – only shows the text that is visible within the current boundaries of the cell. Note that the text is still in the cell, it’s just not visible.
Google Sheets text wrapping examples

You can select more than one cell in Google Sheets by clicking a row number to select the entire row, clicking a column letter to select the entire column, holding down the Ctrl key to click multiple cells, or clicking the gray cell above the row 1 heading.

Another Way to Wrap Text in Google Sheets

There is another method that you can use if you find the Text wrapping button to be difficult to identify, or if you prefer to use the top menu.

Step 1: Select the cells that you wish to modify.

Step 2: Click the Format tab at the top of the window.

open the Format menu

Step 3: Choose the Text wrapping option, then select the style of text wrapping to apply to the selected cells.

another way to wrap text in Google Sheets

How to Wrap Text in Google Sheets Mobile

A final way that you can wrap the text in Google Sheets cells involves the mobile app.

Step 1: Open the Sheets app, then open the file containing the cells to modify.

Step 2: Tap on the cell to adjust, then tap on the Format button.

open Format on Google Sheets mobile

Step 3: Choose the Cell tab at the top of the menu.

select the Cell tab

Step 4: Tap the button to the right of Wrap text to turn it on.

how to wrap text in Google Sheets mobile

If you are adjusting the text wrapping settings for your cells, then you may also want to consider adjusting the cell alignment. We continue below with information on that as well.

How to Change Vertical Alignment in Google Sheets

The vertical alignment of your cell data affects where in the cell the data is displayed. By default, cell data is aligned to the bottom of the cell in Google Sheets.

You have the option of aligning your data to the top, middle, or bottom of the cell. There is a Vertical align button in the toolbar above the spreadsheet where you can set the vertical alignment for your selected cell(s.) You can also access vertical alignment options by going to Format > Align > and choosing an option there.

Examples of these vertical alignment options are shown below.

Google Sheets vertical alignment examples

You can also elect to change the horizontal alignment by following the steps in the next section.

How to Change Horizontal Alignment in Google Sheets

While the options in the section above concern the vertical alignment of your cell data, you can also choose how you data is aligned horizontally in your cells. By default cell data is aligned to the left in Google Sheets.

The available horizontal alignment options include left, middle, and right. There is a Horizontal align button in the toolbar above the spreadsheet where you can select the desired horizontal alignment for your selected cell or cells. You can also find horizontal alignment options by clicking Format > Align > and choosing on option from the menu there.

Examples of Google Sheets horizontal alignment are shown below.

Google Sheets horizontal alignment examples

The text wrapping setting that you apply to your cell(s) won’t affect the actual data contained within those cells. This only changes the way that the text is shown in the cells.

If you were to copy data from a cell with text wrapping, for example, then any visual line break wouldn’t be included when pasting that data into another cell or application.

Is there a lot of formatting in your spreadsheet that’s difficult to fix by looking for each individual setting? Find out how to clear formatting in Google Sheets and expedite that process.

See also

solveyourtech.com newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.