How to AutoFit Columns in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on August 25, 2023

AutoFit Column Width Shortcut

ALT > H > O > I

See all Excel shortcuts

This tutorial demonstrates how to autofit columns in Excel and Google Sheets.

autofit intro

When you create a new worksheet in Excel, columns have a uniform default size. When you type more information into a cell in a column, the text spills over to the adjacent cell if that adjacent cell is blank. If the cell is not blank, then the text looks like it has been cut off as the only visible text is what fits into the actual column size.

There are several ways you can make the size of your columns autofit to show all the text that is contained in each cell.

Where Is AutoFit?

The first place you can find AutoFit is in the Excel Ribbon.

  1. Highlight the column you want to resize.
  2. In the Ribbon, go to Home > Cells > Format > AutoFit Column Width.

autofit ribbon

Note: if you click in a single cell in the column, then the column width is sized to the length of the text in that cell, and not the longest text in a cell in the column itself.

Double-Click the Column Header

  1. To autofit a column using the column header, position your mouse at the right side of the column you wish to size.
  2. Once the cursor has changed to the one illustrated below, double-click the mouse.

autofit column header


AutoFit Column Keyboard Shortcut

There is not a dedicated keyboard shortcut for adjusting column width, but you can use the ALT key to do so if you prefer using the keyboard to the mouse.

  1. Click in the column you wish to size.
  2. Press ALT > H to activate the Home tab on the Ribbon.

autofit column alt h

  1. Press O to activate the Format command in the Cells group.

autofit column alt o

  1. Press I to AutoFit Column Width.

autofit column alt i

The column is sized to the length of the text for the selected cell.

autofit column auto width

How to AutoFit Columns in Google Sheets

You can autofit your columns in Google Sheets by double-clicking on the column header.

  1. As with Excel, position your mouse at the right side of the column you wish to size.

autofit column gs double-click

  1. Double-click to autofit the column width to the widest contents of the column.

AI Formula Generator

Try for Free

See all How-To Articles