In Google Sheets, if the text length is longer than the size of the cell, it will spill over the adjacent cells. Wrap text allows you to fit more text without spilling over, making your data more readable.
In the above image, the addresses are longer than the cell’s width; hence, it spilled outside of it. We will use this example to show you how to wrap text in Google Sheets.
The Format menu holds the built-in wrap feature:
- Select the cell or cells you want to wrap.
Select the cell or cell ranges. - From the Format menu, hover over the Wrapping option. Then, from the sub-menu, choose Wrap.
Click on Format > Text Wrapping > Wrap. Your text will now wrap within the cell.
Text wrapped within the cells.
Method #2: Wrap text using the Toolbar
- Select the cell or cells you want to wrap.
Select the cell or cell ranges. - From the Toolbar, click on the Text Wrapping icon. Then, select the Wrap icon.
Select the Wrap icon from the toolbar. Your text will wrap within their cells.
Text wrapped within the cells.
Method #3: Wrap text manually
You can add line breaks manually if you want more control over where the text wraps. For example, you may want to display each part of the address (Street Address, City, State, and Country) each on its own line. Follow the steps below:
- Double-click on the cell you want to text wrap. It will activate the edit mode to make changes in the cell content.
Double-click on the cell. - Within the cell, bring the cursor to where you want the text to wrap.
Put the cursor where you want to add a line break. - Press Alt + Enter at all the locations where you want to insert the line break. The text should now wrap at the location of the line break. Follow the same steps for other cells.
Press Alt + Enter.
