When you have a long sentence or text string in a cell in Google Sheets, you will find that it overflows to the adjacent cells on the right (something as shown below).
This is often the case when you’re entering sentences or address in the cells.
The right way would be to wrap the text in the cells so that it doesn’t overflow to other cells (something as shown below).
Wrap Text In Google Sheets (Automatically)
Below are the steps to wrap text in Google Sheets:
- Select the cells that you want to wrap
- Click the Format option in the menu
- Hover the cursor on the Text Wrapping option.
- Click on Wrap
The above steps would instantly wrap the text in the selected cells in Google Sheets.
The Wrap Text option is also available in the toolbar (which is just below the menu options).
To wrap text from the toolbar, select the cells that you want to wrap and then click on the wrap text icon (it’s one of the three available options when you click on the Text Wrapping icon).
How Does Google Sheets Decide How Much Text to Wrap?
This is determined by the width of the columns.
When text wrap is enabled, Google Sheets try to fit the content of the cell in the same cell based on the column width. So, if your column width is enough to fit all the text in one single line, Google Sheets will do that.
But if your column width is less, it will fit the content of the cell so that the text doesn’t overflow and remains within the same cell (by splitting it into multiple lines in the same cell).
When the text is wrapped, Google Sheets will automatically adjust the height of the cell to fit the content.
There is another option you can consider using when you don’t want the text to overflow CLIP.
The ‘Clip’ option is available as one of the options under Text Wrapping and it clips the text so that it doesn’t overflow to the adjacent cells. This could be useful when you want to have the text but don’t want it to overflow and also don’t have the need to have the complete text visible. This can be the case with long URLs or even addresses.
Don’t worry, when you use the Clip option, it will not delete any text. It just hides any text that was earlier overflowing.
Adding Text Wrap Manually
In some cases, you may not want to wrap based on the column width, but instead, be able to specify where you need the text to be wrapped.
For example, in the below example, you may also want each part of the address (house/Street number, City and State, and Pin code) separately.
If you rely on Google Sheets inbuilt wrapping functionality, it will wrap based on column width. But you can also manually specify where you want the line to break.
Below are the steps to add a line break manually:
- Select the cell in which you want to insert the line break and then press F2 (or double click on the cell). This will take you to edit mode where you can change the content of the cell.
- Bring the cursor to the place where you want to insert the line break
- Hold the ALT key and then press Enter.
The above steps would insert a line break and will make sure the sentences/text before and after line break are in separate lines.
Note that when you insert a line break in a cell, it would bring the text after the line break to the next line, even if you have not applied the text wrapping.
You may also like the following Google Sheets tutorials:
- How to Delete Empty Rows in Google Sheets
- How to Transpose Data in Google Sheets
- How to Indent Text in Google Sheets
- How to Insert Bullet Points In Google Sheets
- How to Change Text Case in Google Sheets (Upper, Lower, Proper, or Sentence)
- How to Hide Gridlines in Google Sheets
- Fill Down In Google Sheets (Autofill Formulas, Numbers, Dates)