Excel: Expand All Columns to Fit Text With AutoFit (Every Method)

To expand all columns in Excel to fit their text, click the Select All button (the triangle where the row numbers meet the column letters, or press Ctrl+A), then double-click any boundary between two column headings. Every column with content resizes to fit its widest entry; you can also use Home > Format > AutoFit Column Width or the keyboard sequence Alt, H, O, I.

That covers most cases. Below are the details for each method, how it works on a Mac, how to automate it, and what to check when AutoFit doesn’t seem to do anything. Steps are based on Microsoft’s documentation as of October 2026; ribbon labels can shift slightly between Excel versions.

The fastest way: select all and double-click

Microsoft’s own guide to changing column width describes this as the quick way to AutoFit every column on a worksheet.

1. Click the Select All button in the top-left corner of the grid, or press Ctrl+A (you may need to press it twice if your cursor is inside a block of data).
2. Hover over the line between any two column letters, for example between A and B, until the pointer turns into a double-headed arrow.
3. Double-click.

Each column now fits its longest value. Empty columns are left alone.

If you only want certain columns resized, select those column headers first (drag across them, or Ctrl+click for non-adjacent ones) and double-click a boundary inside the selection.

Using the ribbon

If double-clicking feels fiddly, the ribbon command does the same job:

1. Select the columns, or the whole sheet with Select All.
2. Go to the Home tab.
3. In the Cells group, click Format.
4. Under Cell Size, choose AutoFit Column Width.

The same Format menu also has AutoFit Row Height, which is useful when you have wrapped text and rows look clipped.

The keyboard shortcut: Alt, H, O, I

On Windows, you can trigger the ribbon command without the mouse. Select your columns (or press Ctrl+A), then press these keys one after another, not together:

1. Alt to activate ribbon shortcuts
2. H for the Home tab
3. O for Format
4. I for AutoFit Column Width

This is a ribbon key tip sequence, so it follows the menu path described above. Multiple tutorial sites document it, including Automate Excel.

Watch what you select first

Automate Excel points out an easy mistake: if you click a single cell and run AutoFit Column Width, Excel sizes the column to the text in that cell, not to the longest entry in the column. To fit the whole column, select the entire column (click its letter) or the whole sheet before running the command.

Expanding columns in Excel for Mac

On a Mac, Microsoft’s Excel for Mac guide documents the double-click method:

1. Select the columns you want to fit, or click the Select All corner to select the whole sheet.
2. Point to the separator on the right side of any selected column heading.
3. Double-click.

You can also use the menu bar: Format > Column > AutoFit Selection (the exact wording may differ slightly by version).

Sources disagree on a built-in Mac keyboard shortcut for AutoFit, and Microsoft’s Mac page doesn’t list one, so we wouldn’t rely on any combination you see quoted online. If you want a shortcut, macOS lets you assign your own: go to System Settings > Keyboard > Keyboard Shortcuts > App Shortcuts, add Microsoft Excel, and type the menu command name exactly as it appears in Excel’s menu.

Comparing the methods

Automating it with VBA

If you rebuild a report every day and always AutoFit afterwards, a macro can do it for you. Microsoft’s Range.AutoFit reference shows the syntax. To fit every used column on the active sheet:

Sub FitAllColumns()
    ActiveSheet.UsedRange.Columns.AutoFit
End Sub

To fit specific columns, Microsoft’s example is:

Worksheets("Sheet1").Columns("A:I").AutoFit

Two details from the documentation worth knowing:

• AutoFit must act on whole rows or whole columns, otherwise you get an error. Using .Columns.AutoFit on a range handles this.
• Range("A1:E1").Columns.AutoFit sizes columns A to E based only on the contents of A1:E1, not the full columns. That’s handy when you want columns to fit a header row and ignore long values further down, but it can surprise you if you expected the full column to be measured.

Macros require a macro-enabled workbook (.xlsm) and desktop Excel, so check your organization’s macro policy before rolling this out to a team.

When AutoFit doesn’t work

Merged cells

This is the most common culprit. Microsoft’s support article KB 212010 states that you can’t use AutoFit on a column that contains a cell merged with cells in other columns (and the same applies to rows with cells merged across rows). Microsoft describes this as by design, not a bug.

Your options:

1. Unmerge the cells (Home > Merge & Center > Unmerge Cells) and run AutoFit again.
2. Set the width manually via Home > Format > Column Width if the merge must stay.

Wrapped text

When Wrap Text is on, text breaks onto new lines inside the cell instead of spilling past it, so AutoFit Column Width has less to work with and the column may not widen as you expect. If you want long text on one line, turn off Wrap Text for those cells first, then AutoFit the columns. If you want wrapping, keep the column at a sensible fixed width and use AutoFit Row Height instead.

If row height doesn’t adjust after wrapping, Microsoft’s guidance for this situation is that it can happen when a row’s height was changed manually; run AutoFit Row Height on that row again.

Hashes (###) still showing

Microsoft notes that ### appears when a column is too narrow for its data. If you still see it after AutoFit, check whether the cell is part of a merged range (see above), or whether the column was excluded from your selection.

Very long text

AutoFit sizes a column to the longest entry, so a single cell with a long sentence or URL can make one column enormous. In that case it’s often better to set a fixed width for that column and turn on Wrap Text, then AutoFit the rest.

A practical routine

For most sheets, this order gives clean results:

1. Turn off Wrap Text on cells where you want single-line values.
2. Unmerge any cells you don’t truly need merged.
3. Press Ctrl+A and double-click a column boundary (or Alt, H, O, I on Windows).
4. Set fixed widths for any columns that grew too wide, enable Wrap Text there, then AutoFit Row Height.

Remember that AutoFit is a one-time adjustment, not a live setting. When new, longer data arrives, run it again, or use the VBA approach if you do this often.