Autofit Column Width in Excel Not Working? How to Fix

If AutoFit Column Width is not working in Excel, select the affected columns and choose Home > Format > AutoFit Column Width, or double-click the boundary on the right side of a selected column heading. If the result is still wrong, check for merged cells, wrapped text, hidden or protected columns, and unusually long cell contents; these are common reasons AutoFit does not produce the width you expect.

What AutoFit does—and what it does not do

AutoFit adjusts a column to accommodate the widest content Excel considers in the selected column, using the workbook’s font and the displayed cell contents. It is a sizing command, not a general repair for every display problem. A column can be AutoFit correctly and still show a result that looks wrong if the content is a long sentence, the cell uses a merged range, or the value itself cannot be displayed in the selected format.

For example, if A2:A20 contains short product codes but A21 contains a long description, AutoFit on column A can make the entire column very wide to fit that one description. That is expected behavior. If the goal is a compact table, it may be better to wrap the description, move it to another column, or set a practical width manually rather than letting one outlier determine the width for every row.

AutoFit also has a maximum column width. Excel column widths are limited to 255 characters in the standard width measurement, so an extremely long unbroken string may not fit even after AutoFit. Excel may display part of the content or use other visual cues rather than making the column unlimited.

Run AutoFit on the right selection

First confirm that you selected the actual column or columns containing the content. Clicking a cell and running AutoFit affects its column; selecting several column headings adjusts all of those columns. To select the whole worksheet, click the small triangle at the intersection of the row numbers and column letters, then run AutoFit. This is more reliable than pressing Ctrl+A in a worksheet with data, because Ctrl+A can select the current data region first and may require another press to select the entire sheet.

Select one or more column headings. Drag across adjacent headings, or hold Ctrl while clicking nonadjacent headings on Windows.
On the ribbon, choose Home > Format > AutoFit Column Width.
Alternatively, point to the right boundary of a selected column heading and double-click when the pointer changes to the column-resize indicator.
Check the result at the worksheet’s current zoom level and confirm that the relevant cells, rather than unrelated columns, were selected.

If you double-click the divider between column A and B, Excel sizes column A. The divider belongs to the column on its left. A frequent near-miss is dragging the divider slightly, which changes the width manually, instead of double-clicking it to AutoFit.

Why AutoFit may appear to do nothing

Several different situations can make a successful AutoFit look like a failure. Check these before changing workbook settings:

The column is already as wide as the content needs. The command may run without an obvious visible change, particularly if the contents are similar in length.
The wrong columns are selected. AutoFit does not resize a neighboring column just because it contains the text that looks cut off.
The column is hidden. A hidden column has zero width, so the result may not be apparent. Unhide it first, then AutoFit.
The worksheet is protected. Protection settings can prevent formatting columns. Review the protection permissions or ask the workbook owner to allow column formatting.
The column is part of an outline or grouped range. A collapsed group may conceal the columns you expect to see. Expand the group and check the individual columns.
The content is longer than Excel’s maximum width. AutoFit cannot create an unlimited column, so long text may remain difficult to read.

Also make sure you are not confusing column width with row height. AutoFit Column Width changes horizontal space; it does not increase the height of a row to reveal several lines. For that, use Home > Format > AutoFit Row Height, or adjust the row height manually.

Merged cells and wrapped text need special attention

Merged cells are one of the most common causes of confusing AutoFit results. When a cell spans multiple columns, Excel does not reliably AutoFit those columns based on the merged cell’s full text. For instance, a heading merged across A1:C1 may appear clipped even after you AutoFit columns A through C. The text belongs to a combined area, so Excel cannot simply assign its full width to one individual column in the usual way.

If you can change the layout, unmerge the cells and use Home > Alignment > Merge & Center only where needed, or use Center Across Selection in the Format Cells alignment options. Center Across Selection keeps the cells separate, which is generally easier to sort and work with. If the merge must remain, set the participating column widths manually or use a text box for a decorative heading.

Wrapped text creates a different issue. With Wrap Text enabled, Excel displays content on multiple lines within a cell. AutoFit Column Width may not give the result you expect because the text is intended to use the current column width and flow vertically. Keep the column at a useful width, then use Home > Format > AutoFit Row Height so the row can show the wrapped lines. If a row was manually assigned a fixed height, it may need to be reset or adjusted as well.

Check the displayed value, formatting, and unusual characters

Excel sizes a column according to what it displays, not necessarily the underlying value in the way you might expect. A cell containing a date, a percentage, or a number with a custom format can take more space than its raw value suggests. Changing the number format can therefore change the width needed. For example, a date displayed as 11/2/2026 needs more room than a short number displayed in the same cell.

If a cell shows ####, the value is often too wide for the column’s current width, especially for dates or numbers. Select the column and AutoFit it. If the hashes remain, inspect the value and format: negative date or time results can display as hashes in Excel’s date system, and AutoFit cannot make an unsupported display meaningful. For a long text value, check whether it contains a line break or a long sequence with no spaces. A line break can make the content occupy multiple lines, while an unbroken string may force an impractically wide column.

Text copied from websites or other systems can include nonbreaking spaces and other unusual characters. They may make text wrap or compare differently from ordinary spaces. If one cell seems to be the outlier, inspect it in the formula bar and consider cleaning or replacing the unwanted characters. Do not widen every column until you have checked whether a single stray value is responsible.

Fixes for a specific column that stays too narrow

Use this sequence when one column refuses to reach a useful width:

Unhide the column if necessary. Select the headings on either side, right-click, and choose Unhide, or use the relevant column-formatting command.
Check whether the sheet is protected. If Excel will not change the width, protection may be blocking formatting rather than AutoFit malfunctioning.
Unmerge any cells in the column temporarily and try AutoFit again. Restore a suitable layout afterward if the merge is required.
Turn off Wrap Text temporarily if you want the column to size to a single line, then decide whether wrapping is preferable for the finished sheet.
Look for a very long entry elsewhere in the column. If that value is an outlier, consider a manual width, wrapping, or a separate notes column.
Set a width directly by dragging the heading boundary, or choose Home > Format > Column Width and enter a value.

Manual sizing is not a workaround to avoid at all costs. It is often the better choice for a report with consistent layout requirements, such as a printed schedule or a dashboard. AutoFit is most useful when the goal is to reveal ordinary content quickly; a fixed width is useful when consistency matters more than showing every character on one line.

Keyboard shortcuts and Excel on other platforms

In Excel for Microsoft 365 on Windows, select the target columns and press Alt, H, O, I in sequence. This invokes AutoFit Column Width through the ribbon key tips; it is not a single simultaneous key combination. To AutoFit row height, use Alt, H, O, A. You can also reach the command through the ribbon, which is easier to remember and works when key tips are unfamiliar.

In Excel for Mac, select the columns and use the ribbon’s Home > Format > AutoFit Column Width command when available in the current ribbon layout. Mac keyboard shortcuts can differ by keyboard and Excel release, so the menu or ribbon command is the dependable route if a Windows shortcut does not work. In Excel for the web, select the column headings and use Home > Format > AutoFit Column Width; some desktop-only features or interactions may be more limited in a browser, so open the workbook in the desktop app if the command is unavailable or the layout depends on merged cells.

AutoFit versus manual width and other layout choices

Choose the method that suits the sheet’s purpose rather than applying AutoFit repeatedly. AutoFit is quick for ordinary lists, but can create unwieldy columns when cells contain long notes. Manual width keeps a report aligned, while wrapping makes long text readable without expanding the column. Shrink to Fit, found in the Format Cells alignment options, reduces displayed text to fit the existing width; it can become hard to read when the reduction is substantial.

Use AutoFit for a quick first pass on a list with relatively short entries.
Use a fixed width for forms, dashboards, or reports that need consistent alignment.
Use Wrap Text for descriptions that should remain readable in a narrow column, and adjust row height as needed.
Use Shrink to Fit sparingly when preserving a compact row is more important than maintaining a uniform font size.
Move long notes to a separate column or a cell comment if a single exceptional entry makes the main table too wide.

For a polished worksheet, it is common to AutoFit the short identifier and date columns, set a deliberate width for names or descriptions, and wrap only the columns that need multiple lines. That hybrid approach avoids both clipped values and a worksheet stretched across the screen.

Frequently Asked Questions

Why does AutoFit not work on merged cells in Excel?

Excel does not reliably size individual columns from text in a cell merged across several columns. Unmerge the cells and AutoFit, or set the participating widths manually. For headings, Center Across Selection can provide a similar centered appearance without merging cells.

Why does Excel show #### after I AutoFit a column?

The column may still be too narrow, or the value may not be displayable in its current format. Widen it and check the cell’s number format and value. Negative date or time results can also appear as hashes; making the column wider does not fix that underlying display limitation.

How do I AutoFit every column in a worksheet?

Click the Select All triangle above row 1 and to the left of column A, then choose Home > Format > AutoFit Column Width. This sizes all columns on the active worksheet, including empty ones, so it can change the overall layout substantially.

Why does AutoFit make one column extremely wide?

Excel is accounting for a long entry somewhere in that column. Find the outlier and decide whether to wrap it, move it, or use a fixed width. AutoFit applies one width to the whole column, not a different width for each row.

Can I AutoFit a column in Excel for the web or on a Mac?

Yes. Select the column and look for Home > Format > AutoFit Column Width in the ribbon. The Windows Alt key sequence is not the same on Mac, so use the visible command if a shortcut differs or is unavailable.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.