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
Locate the column you want to auto fit
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
Without moving your mouse, double-click on the boundary. The column will automatically resize to fit its contents
Note that if the text is wrapped in the cell, the column will be resized to fit the current width of the wrapped text
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:
Select the columns you want to auto fit by dragging across the column letters
Double-click on any of the column boundaries in the selection, just as you did to auto fit a single column
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.