How to Change Column Width in Google Sheets (The Easy Way!)
In this article we will show you how to change column width in google sheets in just a few simple clicks. Just follow the steps below.
How to Adjust Column Width in Google Sheets
1. Hover the cursor to the right border of the column header until the blue bar appears
Choose which column to adjust, then move the cursor to the right border of its header. The header is the row with A, B, C, etc.
2. Click and drag the blue bar until the desired width is reached
Hold the left click of your mouse until you reach the desired width. If you drag it to the right, it will make the columns bigger; if you drag it to the left, it will make the columns smaller.
3. Release the blue bar
The column now has a new width.
How to Resize Column Width with Specific Value in Google Sheets
1. Right-click the header of the column you want to resize
Choose which column to adjust, then right-click its header. The header is the row with A, B, C, etc.
2. Select Resize column
The drop-down list contains several actions. The Resizecolumn is near the middle of the list.
3. Input the specific width to the textbox
There are two options to set column width via this option: enter the width in pixels or fit to existing data. By default, Enter new column width in pixels is selected, and a textbox appears for input. You can enter the specific width in pixels in it. For this example we increased its width from 120 pixels (the default value) to 200 pixels. You can also make the column width shorter by inputting a value smaller than the default size (120 pixels).
4. Click OK
The column has now adjusted to the new specified width:
Can I Make The Width of More Than One Column Bigger At The Same Time?
Yes! To do so, hold Ctrl while selecting the column headers. They can be adjacent or non adjacent columns.
After selecting them, just follow any of the two procedures we highlighted above.