How to Wrap Text in Google Sheets

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.

Method #1: Wrap text using the Format Menu

The Format menu holds the built-in wrap feature:

1. Select the cell or cells you want to wrap.

   

2. From the Format menu, hover over the Wrapping option. Then, from the sub-menu, choose Wrap.

   

   Your text will now wrap within the cell.

   

Method #2: Wrap text using the Toolbar

1. Select the cell or cells you want to wrap.

   

2. From the Toolbar, click on the Text Wrapping icon. Then, select the Wrap icon.

   

   Your text will wrap within their 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:

1. Double-click on the cell you want to text wrap. It will activate the edit mode to make changes in the cell content.

   

2. Within the cell, bring the cursor to where you want the text to wrap.

   

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