In this article, we’ll show you how to effortlessly adjust the column width in Google Sheets with just a few clicks. Follow the simple steps below to learn how.
Adjusting Column Width Automatically in Google Sheets
To demonstrate this process, we’ve created a sample sheet that you can access and practice with – click here to check it out.
Automatically Adjusting a Single Column
The easiest method to automatically adjust a single column is by using the double-click method, as shown below.
-
Place your mouse cursor on the right side of the column letter.
At the top of the screen, move your mouse cursor towards the edge of the column letter. Notice that the cursor transforms into the ↔ symbol.
In our example, we need to adjust the width of column D, which means we should place the mouse cursor at the end of the letter D, just before the letter E.
-
Double-click to automatically adjust.
With the mouse cursor displaying the ↔ symbol, double-click the left mouse button. The column width will be adjusted.
-
Your column has now been adjusted.
The column width has now been adjusted to fit the longest value contained within the column.
In our example, column D has expanded to accommodate the longest value.
Automatically Adjusting Multiple Columns
You can also automatically adjust multiple columns at once.
-
Select the columns to be adjusted automatically.
Click on the column letters to select them. If the cells are adjacent, you can click and drag to select them all. If the columns to be adjusted are separate, hold down the Ctrl (Cmd ⌘ on Mac) key and click on the individual column letters.
In our example, we will select columns C and E because the values in each column are longer than the column width.
-
Place your mouse cursor to the right of any selected column.
Move your mouse cursor towards the right edge of the highlighted column letter. The cursor will transform into the ↔ symbol.
In our example, we will move the cursor to the edge of column E.
-
Double-click the column edge to automatically adjust.
With the cursor displaying the double arrow ↔ symbol, double-click the left mouse button. The columns will automatically adjust.
-
Your columns have now been adjusted.
The column widths are now automatically adjusted to fit the longest value.
As we can see in our example, columns C and E now display each value, including the longest entries.
If you enjoyed this article, you might also like our articles on how to make columns the same width in Google Sheets or how to rename columns in Google Sheets.
Additionally, if you’re interested in learning how to automatically send an email from Google Sheets, we suggest checking out our detailed guide.
Use our contract renewal reminder software to easily automate contract reminders from your spreadsheet with just a few clicks.
Remember, if you want to explore more Google Sheets tips and tricks, be sure to visit Crawlan.com. Happy exploring!
