The steps in this guide are going to show you how to wrap text in a Google Sheets spreadsheet. There are several text-wrapping options to choose from, so you will be able to select the one appropriate to your needs.
- Open the Google Sheets file.
- Select the cell(s) for which to adjust the text wrapping settings.
- Click the Text wrapping button in the toolbar.
- 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.
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.
How to Change 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.
Step 3: Select the Text wrapping icon in the toolbar above the spreadsheet.
Step 4: Click the text wrapping option that you would like to use.
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.
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.
Step 3: Choose the Text wrapping option, then select the style of text wrapping to apply to the selected cells.
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.
Step 3: Choose the Cell tab at the top of the menu.
Step 4: Tap the button to the right of Wrap text to turn it on.
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.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.