• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Google / Sheets / How to Adjust Column Width in Google Sheets

How to Adjust Column Width in Google Sheets

October 14, 2020 By Matt Jacobs

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

  • 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

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.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Show Contact Photos in Messages on an iPhone 11
  • How to Sign Out of Spotify on an iPhone
  • How to Flip a Picture in a Microsoft Word Document
  • How to Announce Messages with Siri on an iPhone 11
  • How to Clear Spotify Cache on an iPhone

Featured Posts

how to add page numbers in Google Sheets

How to Add Page Numbers in Google Sheets

How to Switch to Legal Page Size in Excel for Office 365

How to Change Hotspot Name on iPhone 11

How to Remove All Hyperlinks in Microsoft Word for Office 365

excel 2013 how to remove formula bar

How to Hide the Formula Bar in Excel 2013

how to change background color in Microsoft Word

How to Change Background Color in Microsoft Word for Office 365

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

SupportYourTech.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Copyright © 2021 SupportYourTech.com