In this article we will show you how to autofit column width in Google Sheets in just a few simple clicks. Just follow the steps below.
How to Autofit Column Width in Google Sheets
For the purpose of this demonstration a sample sheet was created, click here to access this and follow along.
Autofit a Single Column
The simplest method to auto fit a single column is to use the double click method as seen below.
1. Hover the mouse over the right side of a column letter
At the top of the screen move the mouse cursor to the edge of the column letter. Notice the mouse cursor turns into the ↔ symbol.
In our example we need to autofit column D, this means we need to hover the mouse at the end of the letter D just before the letter E.
2. Double click to autofit
With the mouse cursor displaying the ↔ symbol, double click on the left mouse button. The width of the column will be adjusted.
3. Your column has now been adjusted
The column width has now been adjusted to fit the longest value contained in the column.
In our example Column D has now expanded to fit the longest value.
Autofit Multiple Columns
We can also autofit multiple columns at the same time.
1. Select the columns to autofit
Click on the column letters to select them. If the cells are next to each other you can click and drag to select them all.
If the columns to autofit are separate, press and hold down the Ctrl (Cmd ⌘ on Mac) key and click on the individual column letters.
In our example we will select Column C and Column E as the values in each column are longer than the column width.
2. Hover the mouse to the right of any selected column
Move the mouse cursor to the right hand edge of any highlighted column letter. The cursor will turn into the ↔ symbol.
In our example we will move the cursor to the edge of Column E.
3. Double click the column edge to autofit
With the cursor displaying the double arrow symbol ↔ double press the left hand mouse button. The columns will autofit.
4. Your columns have now been adjusted
The column widths are now auto adjusted to fit the longest content value.
As we can see in our example columns C and E now display every value including the longest entries.