When you type some text in a cell in Google Sheets, it will not automatically fit in it.
Instead, the text will go out of the cell and overflow to the next column(s).
Unfortunately, there isn’t a shortcut for fitting/keeping text into a cell.
Hence, you need to manually wrap the text to prevent it from overflowing.
To fit text in Google Sheets, you can either wrap the text or resize the columns to fit the data.
Here are two methods to fit text in Google Sheets.
Method 1: Wrap text
How to fit text in Google Sheets by wrapping them:
- Select all of the columns/rows (shift + click).
- Click “Format” on the top navigation bar.
- Select “Wrapping”.
- Select “Wrap”.
After you’ve selected “Wrap”, the text in the columns (that you’ve selected) will be wrapped.
Wrapping will fit/keep the text in a cell based on the width of the column.
Hence, the text will not overflow out of the cell.
If you’re writing in a new column, you need to wrap the text in it again.
Method 2: Fit to data
How to fit text in Google Sheets by fitting them to the data:
- Select all of the columns/rows (shift + click).
- Right-click a column/row.
- Select “Resize columns X – Y”.
- Select “Fit to data”.
- Click “OK” to save your changes.
After you’ve selected “Fit to data”, all text will fit in all cells.
Similar to wrapping, the text will fit based on the width of each column.
You can edit the size of a column by right-clicking it and clicking on “Resize columns”.
Instead of selecting “Fit to data”, select “Enter new column width in pixels” and enter the width that you want to set for the column(s).
Further reading
How to Center Text in The Middle in Google Docs
