How to Change Text Wrapping Settings in Google Sheets

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 tutorial below will show you how to make that adjustment.

Text Wrapping Setting in Google Sheets

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

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.

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.

solveyourtech.com newsletter
vintage t rex t-shirt

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