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.
For the purpose of this demonstration a sample sheet was created, click here to access this and follow along.
The simplest method to auto fit a single column is to use the double click method as seen below.
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.
With the mouse cursor displaying the ↔ symbol, double click on the left mouse button. The width of the column will be 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.
We can also autofit multiple columns at the same time.
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.
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.
With the cursor displaying the double arrow symbol ↔ double press the left hand mouse button. The columns will autofit.
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.
If you enjoyed this article, you might also like our article on how to make columns the same width in Google Sheets or our article on how to rename columns in Google Sheets.
If you want to learn how to automatically send an email from Google Sheets, check out this guide!
Use our contract renewal reminder software to easily automate contract reminders from your spreadsheet in just a few clicks.
