In this tutorial, you will learn how to autofit in Google Sheets.
Appropriate column width is important for professional and readable spreadsheets, especially when large amounts of text are included in the spreadsheet. Manually setting each column in a spreadsheet to an appropriate size is a time consuming process that may need to be repeated whenever spreadsheet data changes, but fortunately Google Sheets has a handy feature to autofit columns to the data they contain in just a few clicks. Here’s how:
Select the column or columns you wish to autofit
Double click on the line to the right of column letter for any of the selected columns
The selected columns will resize to fit the contents they contain. For example, if you select one column with narrow text and one with wide text, the first column will become narrower and the second wider
Note that if text is wrapped in a cell, resizing in this way will resize to the smallest size possible with the current line breaks. Manually resize the cell to change the line breaks
Repeat this process as needed when cell content changes or new columns are added. You can even select the entire sheet and resize all columns at once in this way
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to autofit in Google Sheets. Want more? Check out all the Google Sheets Tutorials.