In this article:

How to Autofit Column Width in Google Sheets (The Easy Way!)

May 9, 2024

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.

How to auto fit column width in Google Sheets: Mouse hover

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.

Blue line highlighted

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.

Google Sheets autofit column width: Results

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. 

Auto fit column width Google Sheets: Select multiple columns‍

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.

Google Sheets autofit column width shortcut: Mouse hover

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.

How to autofit column width in Google Sheets: Double click

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.

Google Sheets auto fit column width: Results

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. 

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->