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.
- Sign into Google Drive and open your Google Sheets file.
- Click on the column letter of the column to resize.
- Right-click on the selected column and choose Resize column.
- 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.
Step 3: Right-click on a selected column and choose the Resize column option.
Step 4: Enter a value into the column width field, then click the OK button.
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
- How to freeze a row in Google Sheets
- Where did the gridlines go in Google Sheets?
- How to change the date format in Google Sheets
- How to unhide a worksheet in Google Sheets
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.