How to Adjust Column Width in Google Sheets

by

Google Sheets columns are 100 pixels wide by default, but can change based on the data within them. Use these steps to adjust column width in Google Sheets.

  1. Sign into Google Drive and open your Google Sheets file.
  2. Click on the column letter of the column to resize.
  3. Right-click on the selected column and choose Resize column.
  4. Enter the desired new width, then click OK.

A blank Google Sheets file will have columns that are 100 columns wide and 21 pixels high by default.

However, you may have added data that caused the columns to get wider or smaller. Or perhaps you are working on someone else’s file and need to change the column widths.

Our guide below will show you how to specify the desired number of pixels to use for your columns so that you can adjust your column width in Google Sheets.

How to Adjust Google Sheets Column Width

The steps in this article were performed in the desktop version of Google Chrome but will work in other desktop versions of Web browsers as well.

Step 1: Sign into Google Drive and open the Google Sheets file to edit.

Step 2: Click on a column letter to select the whole column. You can also hold down the Ctrl key and click on additional column letters to resize multiple columns at once.

select the column to adjust

Step 3: Right-click on a selected column and choose the Resize column option.

right-click and choose Resize column

Step 4: Enter a value into the column width field, then click the OK button.

how to adjust column width in Google Sheets

Note that you can also adjust column width in Google Sheets by positioning your mouse on the right border of a column letter, then clicking and dragging the column to the desired width.

Additional reading