How To Auto Fit Column Width In Google Sheets

In this tutorial, you will learn how to auto fit column width in google sheets.

When you’re working in Google Sheets, it’s common to run into situations where the column widths are the wrong size to nicely display data. While you could manually adjust each column to fit the contents, this process can easily take a long time for larger spreadsheets and be tedious. Fortunately, Google Sheets has a very easy solution to this problem. Read on to learn how to auto fit column width to contents in Google Sheet

Auto Fit a Single Column

When you auto fit a column to its contents, Google Sheets looks at the width of the contents and automatically picks the column width that matches

Step 1

Locate the column you want to auto fit

Step 2

Hover your mouse over the boundary between the header of the column you want to auto fit and the next column. The boundary will highlight blue, and your cursor will change to a double-ended resize arrow

Step 3

Without moving your mouse, double-click on the boundary. The column will automatically resize to fit its contents

Step 4

Note that if the text is wrapped in the cell, the column will be resized to fit the current width of the wrapped text

Step 5

Repeat as needed, or see the next section to learn how to auto fit multiple columns simultaneously

Auto Fit Multiple Columns

Auto fit on individual columns is handy, but the true time-saving of this feature comes when you apply it to multiple columns. Here’s how:

Step 1

Select the columns you want to auto fit by dragging across the column letters

Step 2

Double-click on any of the column boundaries in the selection, just as you did to auto fit a single column

Step 3

All columns in the selection will auto resize to fit their contents


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to auto fit column width in google sheets. Want more? Check out all the Google Sheets Tutorials.