Is your text not fitting in the cells in Google Sheets?
If so, you can change the width of each column.
Increasing the width of a column will allow more text to fit in its cells.
That way, your text will not overflow to the next column(s).
Google Sheets has a feature where you can resize columns.
The feature can be accessed by right-clicking the column(s) that you want to resize.
In this guide, you’ll learn how to adjust, resize, or change the column width in Google Sheets.
How to change column width in Google Sheets
How to change column width in Google Sheets
- Select the column(s) that you want to resize.
- Right-click the column(s).
- Select “Resize column(s)”.
- Select “Enter a new column width in pixels”.
- Enter the column width (in pixels) that you want to change (e.g. 200).
- Select “OK”.
After you’ve selected “OK”, the width(s) of the column(s) will be resized to the pixels that you’ve entered.
The default column width in pixels is 100.
You can increase or decrease it by entering the pixels into the text field.
You can select more than one column by pressing “Shift” on your keyboard.
If you’ve selected more than one column (e.g. columns A to D), you’ll see the “Resize columns A – D” option.
By entering the pixels into the text field, all of the columns that you’ve selected will be resized when you click on “OK”.
If you just want the text to fit into the cells, you can double click the border next to the alphabet of the column.
In other words, the width of the column will be resized to fit the text.
Further reading
How to Center Text in The Middle in Google Docs
