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.

Screencap

‍

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 Resize column 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:

Screencap

FAQs

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.