With Google Sheets’ ability to create new rows in the same cell, you can prevent your cell content from overflowing. The extra content of your cell is placed on a new line. Here are two ways to do this in your spreadsheets.
HOW TO COUNT CHARACTERS IN A CELL IN GOOGLE SHEETS
Using a new line in a cell in Google Sheets
To quickly create a new row in a cell, you can use a Google Sheets keyboard shortcut. This shortcut allows you to add a new line whenever you want.
To use it, first place your cursor in your cell and type the contents of the first line.
Select a cell and type the content.
When you want to add a new line, press the keyboard shortcut Ctrl+Enter (Windows, Linux, Chromebook) or Command+Enter (Mac).
Add a new line in a cell.
Your cursor moves to a new line in the same cell. You can now type the content of your second line. To add a third row, use the same keyboard shortcut again.
Enter the content of the second line.
This is how you can keep your text from overflowing and stay within the bounds of your cell width.
Placing existing cell content on new rows in Google Sheets
If your spreadsheet already contains overflowing text and you want to wrap it on new lines, use Sheets’ text wrapping feature.
First, select the cells where you want to place the overflowing content on new rows.
Select cells containing overflowing text.
With your cells selected, from the Google Sheets menu bar, select Format > Wrapping > Wrapping.
Select Format > Wrapping > Wrap from the menu bar.
The content of your overflowing cell now adapts to the cell’s default width.
Text wrapped in leaves.
There you go, you’re ready.
If you use Excel, you can also wrap text in your Excel spreadsheets.