The spreadsheet has the default length and width of the cells. So, when you enter the lengthy text in the cell, it overflows to the adjacent cells.
To fit the lengthy text within the cells only, Google Sheets has the wrap text feature, which splits the cell value into multiple lines and fits into that cell.
Due to the split of text into multiple lines, the height of the cell gets increased to fit those lines into it.
Wrap Text Using Format Menu
- First, select the cells where you want to wrap the text.
- After that, go to the “Format” tab and hover the mouse on the “Text Wrapping” option and click on “Wrap”.
- At this point, the text in the selected cells has been wrapped and fit into the cells.
In the above image, you can see the text got split into multiple lines and the height of the cells got auto-increased to fit those split lines.
Wrap Text Using Toolbar Text Wrapping Icon
This is another quick and easy way to wrap text in Google Sheets.
- First, select the cells where you want to wrap the text.
- After that, click on the Toolbar “Wrap Text” icon and then click on the “Wrap” option.
- The moment you click on the “Wrap” option, the text in the selected cells will get wrapped, and the height of the cells will get expanded to adjust the text.
Wrap Text in Google Sheets Mobile App (IOS & Android)
In the Google Sheets mobile app for both IOS and Android, users can easily wrap and unwrap text by following the below steps:
- Select the cells where you want to wrap the text and then tap on the “Text formatting” icon.
- Now, click on the “Cell” header and then toggle the “Wrap text” button and the text in the selected cells will get wrapped.
Note: To unwrap the text, just simply toggle the “Wrap text” button again to disable it and the wrapped text will get unwrapped.
Wrap Text Manually
Sometimes users want to split the text into lines as they want and for that, they have to do it manually and one by one for each cell.
For example, you have some users’ names and addresses in the cells and you want them to be split only into two lines, one for the names and the other with the address.
- First, double-click on a cell where you want to wrap the text to get the cell in edit mode.
- After that, move the cursor to the left of the character from where you want to split the text into the next line.
- Now, just press the “Ctrl + Enter” keys, and the text after the cursor will get shifted to the next line in the current cell.
Note: If you do not want to split the text more and make it fully visible, just expand the column (A in our case) width to adjust the warped text into two lines only.
Wrapping Text Settings
You may have noticed, in Google Sheets, there are three types of wrapping text options available. Users can choose and apply any of them as per their own choice.
- Overflow – This is the default wrap text setting that does not change the size of the cell and always lets the text-overflow to the adjacent cells.
- Wrap – This wrap text splits the text into new lines within the cell and increases its height to fit those split lines into it. Thus, the text does not overflow out of the cell.
- Clip – The clip option hides the overflowed text. Users can use this clip-wrapping text setting when they have lengthy text in the cells and do not want to change the cell size or show the overflowed text.
