How to Expand All Columns in Excel

Squeezed columns in a shared spreadsheet are one of Excel’s most common annoyances — text gets truncated, numbers turn into ##### symbols, and everyone ends up manually dragging borders one column at a time. Expanding all columns at once takes seconds once you know the right shortcut, and it works the same way whether you’re on Excel for Windows, Mac, or the web version in Microsoft 365. This guide covers every method, from a single double-click to keyboard shortcuts and VBA automation for people who do this constantly.

Why Columns Get Squeezed in the First Place

Excel doesn’t automatically resize columns as you type. A column stays at whatever width it was set to — either the default 8.43 characters (about 64 pixels in the default font) or whatever a previous user dragged it to.

This becomes a problem in a few predictable scenarios:

• Someone imports a CSV or database export with dozens of columns, all set to the same narrow default width
• A template built by a colleague uses tight columns for a dashboard layout, but you’ve since added longer text
• Numbers formatted as currency or with decimal places suddenly display as `#####` because the column is too narrow to show the full value
• You paste data from another source that carries over its original column widths, ignoring your sheet’s formatting

Understanding this matters because it explains why “select all and drag” isn’t actually the best fix — dragging manually sets one uniform width, while AutoFit calculates the ideal width for each column independently based on its own content.

The Fastest Method: Select All + Double-Click

This is the method most Excel power users default to because it requires no menu navigation at all.

1. Click the small gray triangle in the upper-left corner of the worksheet, where the row numbers and column letters meet — this is the Select All button
2. Alternatively, press Ctrl+A while a cell is active (press it twice if you’re inside a formatted table)
3. Hover your cursor over the boundary line between any two column headers until it turns into a double-headed arrow with a line through it
4. Double-click that boundary

Every column with data will instantly resize to fit its longest entry, with a small buffer of padding. Empty columns to the right won’t change, since there’s nothing to auto-fit against.

Early spreadsheet trainers often call this the “one move, whole sheet” trick — it’s the single fastest way to clean up a messy import before you do anything else with the data.

Using the Ribbon: Format > AutoFit Column Width

If you prefer a method that doesn’t rely on cursor precision (dragging to exactly the right pixel can be fiddly on a trackpad), the ribbon gives you the same result with a menu click.

Here’s the full path:

1. Select all cells (Ctrl+A, or click the corner triangle)
2. Go to the Home tab
3. In the Cells group, click Format
4. Under Cell Size, choose AutoFit Column Width

The ribbon method is worth learning even if you rarely use it, because it’s the same location where you’ll find AutoFit Row Height — useful right after expanding columns if wrapped text is now displaying oddly. If you’re also dealing with rows that were previously collapsed or grouped, it’s worth pairing this with the technique in our guide on how to collapse rows in Excel, since expanded columns and collapsed rows often need adjusting together on messy imported sheets.

Setting a Specific Width Instead of AutoFit

AutoFit is great for readability, but it’s not always what you want. If you’re building a report meant to print cleanly, or a dashboard where every column needs to look uniform, AutoFit’s “fit to content” approach can produce wildly inconsistent widths — one column at 6 characters, the next at 40.

For a uniform, fixed width across every column, use this instead:

1. Select all columns (click the corner triangle, or select specific column letters while holding Ctrl for non-adjacent ones)
2. Right-click any column header
3. Choose Column Width from the context menu
4. Type your desired number (Excel measures width in characters of the default font, not pixels) and click OK

A few practical width benchmarks worth knowing:

• 8.43 – Excel’s factory default width
• 10–12 – comfortable for short labels like dates or single words
• 15–20 – good for names or short phrases
• 25+ – needed for full sentences, email addresses, or wrapped notes

This manual-width approach also matters when you’re preparing a sheet that references other cells with formulas, since consistent formatting reduces confusion when troubleshooting. If your formulas aren’t returning the values you expect after a resize, that’s usually unrelated to column width — check our piece on Excel formula not calculating for the actual causes.

Expanding Columns in Excel Online and on Mobile

The desktop shortcuts don’t map perfectly onto Excel’s other platforms, and this trips people up constantly when they switch devices mid-task.

Excel for the Web (Microsoft 365 in a browser)

The browser version supports the same double-click trick, but the ribbon path differs slightly:

• Select all cells with the corner triangle or Ctrl+A
• Right-click any selected column header and choose Column Width, or
• Double-click a column border for instant AutoFit, exactly like desktop

One limitation: Excel Online sometimes lags on very large sheets (10,000+ rows), so AutoFit can take a few extra seconds to calculate compared to the desktop app.

Excel Mobile (iOS/Android)

Mobile Excel doesn’t have a “select all” corner triangle in the same way. Instead:

1. Tap and hold a column header to select it
2. Drag the selection handles across additional columns if needed
3. Tap the Home menu (or the “…” icon depending on screen size)
4. Look for AutoFit under column options

Mobile AutoFit tends to be less precise than desktop, and many mobile users find it easier to do bulk column formatting on desktop first, then just view/edit data on mobile afterward.

Automating It With a Macro (For Repeat Users)

If you regularly receive messy imports — say, a weekly CSV export from a CRM or accounting system — manually clicking AutoFit every time gets old fast. A short VBA macro can do it automatically, either on a button click or tied to a keyboard shortcut.

Here’s a simple macro that auto-fits every column on the active sheet:

Sub ExpandAllColumns() Cells.Select Cells.EntireColumn.AutoFit End Sub

To use it:

1. Press Alt+F11 to open the VBA editor
2. Insert a new module (Insert > Module)
3. Paste the code above
4. Close the editor, then run it via Developer > Macros, or assign it to a custom keyboard shortcut

For anyone managing recurring reports — like calculating margins for a monthly sales sheet using something similar to the profit margin formula for Excel — pairing that formula work with an AutoFit macro means the sheet is always presentation-ready the moment new data lands, without a manual formatting pass.

Common Problems After Expanding Columns

Expanding columns usually goes smoothly, but a few edge cases catch people off guard:

• Merged cells resist AutoFit. Excel can’t reliably auto-fit a column that’s part of a merged cell range — you’ll need to unmerge, resize, then re-merge if the layout requires it.
• Wrapped text doesn’t shrink back down. If you previously enabled Wrap Text on a column, AutoFit will make the column wide enough to eliminate the wrap entirely, which can blow out your entire layout. Turn off Wrap Text first if you want AutoFit’s true “widest single line” result.
• Frozen panes can behave oddly. Columns on either side of a freeze line sometimes need to be auto-fit in two separate selections rather than one Ctrl+A pass.
• Special characters and symbols can throw off width estimates, particularly if a column contains something like a degree symbol for temperature data — see our guide on how to insert the degree symbol in Excel if you’re formatting scientific or weather-related datasets where this comes up often.
• Column headers with renamed labels (common after importing from Google Sheets) sometimes display fine in the header row but still clip in the data rows below — always AutoFit after any header rename, not before.

A quietly useful habit: run AutoFit after you finish editing content, not before. Any resize done mid-edit gets undone the moment you add a longer entry to that column.

Conclusion

Expanding all columns in Excel isn’t complicated, but most users default to the slowest possible method — dragging each column border individually — simply because they’ve never learned the Select All + double-click shortcut. That one move alone will save the average spreadsheet user dozens of minutes a month, especially anyone regularly handling CSV imports or client-provided data dumps. For heavier, recurring use cases, the ribbon’s AutoFit Column Width option and a simple VBA macro turn a manual chore into something that happens automatically. The real skill isn’t memorizing every method — it’s knowing when AutoFit is the right tool versus when a fixed, uniform column width will actually serve your layout better, particularly for printed reports or client-facing dashboards where consistency matters more than perfectly snug text.

FAQ