How to Autofit a Column in Excel to Fit Its Contents

To AutoFit a column in Excel for Microsoft 365 on Windows, point to the right edge of its lettered header and double-click when the pointer becomes a double-headed arrow. Excel adjusts the width to fit the longest visible entry in that column. You can also select the column and choose Home > Format > AutoFit Column Width, or press Alt, H, O, I in sequence.

What You’ll Need

An Excel workbook containing the column you want to resize. AutoFit works on text, numbers, dates, and displayed formula results.
Access to the worksheet, with the column visible and not protected against formatting changes. You do not need to select or edit the cells themselves.

It helps to know whether you want to resize one column or several. You can AutoFit a single column, a group of adjacent columns, or every column in a worksheet. If the worksheet has merged cells, very long text, or hidden columns, read the notes below: those situations can affect what AutoFit does or whether it works as expected.

Step-by-Step

Open the worksheet and find the column. Look at the lettered headers across the top of the grid, such as A, B, or C. If the content is on another worksheet, select that sheet first. AutoFit changes column width on the current worksheet; it does not resize that column on every sheet in the workbook.
Select the column or columns. For one column, click its lettered header. To select adjacent columns, click the first header and drag across the others, or click the first header, hold Shift, and click the last. To select nonadjacent columns on Windows, hold Ctrl while clicking their headers. On a Mac, hold Command instead. Selecting the headers makes it clear which columns will be affected.
Find the boundary on the right side of a selected header. For example, to resize column B, move the pointer to the line between the B and C headers. Pause until the pointer changes to a horizontal, double-headed arrow. Make sure you are over the boundary, not the center of the header; clicking the center selects the column but does not resize it.
Double-click the boundary. Excel calculates a width based on the contents and formatting of the selected column or columns, then resizes them. A column with short values will remain relatively narrow, while one containing a longer entry will become wider. If you selected several columns, Excel fits each one to its own contents rather than making them all the same width.
Check the result in the worksheet. Look at the longest entries and confirm they are readable. AutoFit chooses a width based on what is in the cells; it does not guarantee that the column will fit on your screen without horizontal scrolling. If the result is too wide for your layout, undo the change with Ctrl+Z on Windows or Command+Z on Mac, then choose a suitable manual width or use text wrapping.

Use the ribbon instead: Select the column header or headers, open Home > Format in the Cells group, and choose AutoFit Column Width. This is useful if the header boundary is hard to target, the worksheet is zoomed in, or you prefer using menus. The command applies to the columns in your selection.

Use the Windows keyboard sequence: Select the column or columns, then press Alt, H, O, I one key at a time. This is a sequence of ribbon Key Tips, not four keys pressed together: Alt opens the Key Tips, H opens Home, O opens Format, and I runs AutoFit Column Width. The Key Tips shown by Excel can vary with the ribbon configuration, so follow the on-screen letters if they differ.

On Mac or Excel for the web: In Excel for Mac, select the column and use Home > Format > AutoFit Column Width if that command appears in the ribbon; you can also use the macOS menu bar option Format > Column > AutoFit Selection. The menu-bar route avoids relying on a Windows-only shortcut. In Excel for the web, select the column, then use Home > Format > AutoFit Column Width when available. You can also double-click the header boundary in either version. Ribbon layouts can vary slightly by screen size.

AutoFit all columns: To fit the entire worksheet, click the Select All button at the top-left corner of the grid, where the row and column headers meet. Then double-click the boundary between any two column headers, or use Home > Format > AutoFit Column Width. This changes every column in the selected sheet, so consider whether blank or unusually long columns will make the worksheet difficult to navigate.

Common Mistakes

Dragging instead of double-clicking. Dragging the header boundary changes the width manually. That is useful for choosing a specific size, but it does not tell Excel to calculate the best fit. For AutoFit, double-click the boundary or use the ribbon command.
Selecting a cell when you mean to select a column. Clicking inside a cell and choosing AutoFit can resize the column containing that cell, but it is easy to select the wrong area or overlook which columns are included. Selecting the lettered headers first makes the target more obvious.
Expecting every column to become the same width. AutoFit sizes each column according to its own contents. If you want several columns to share one uniform width, select them and drag a boundary to set a common width instead.
Assuming hidden columns will become visible. AutoFit changes width; it does not unhide columns. If a column is hidden, unhide it first by selecting the headers on either side, right-clicking, and choosing Unhide. Then AutoFit it if needed.
Forgetting that formatting affects the fit. Bold text, font size, and some number formats can make displayed values wider. AutoFit responds to the rendered cell content and formatting, not just the number of characters typed into a cell.

Tips

Use a sensible selection. When you select a whole column, Excel considers its populated cells, including entries far down the worksheet. A stray long value near the bottom can make the entire column much wider than the visible top rows suggest. If you only want to fit a particular group of data, select the relevant columns or inspect the unusual entry before applying AutoFit.
Keep headings readable without making the sheet unwieldy. A long heading can cause AutoFit to make a column wider than its data needs. Consider shortening the heading, wrapping its text, or manually setting a more balanced width. With Wrap Text enabled, a heading can take up multiple lines rather than stretching across the screen.
Choose between width and wrapping. AutoFit is useful when keeping entries on one line is the priority. Wrap Text is often better for notes, descriptions, or headings that should stay within a limited width. Find it at Home > Wrap Text. Wrapping changes how text displays, but it does not make the underlying entry shorter.
AutoFit after changing content or formatting. If you add a longer entry, change a font, or apply a number format after sizing the column, the existing width may no longer be suitable. Run AutoFit again, or adjust the width manually if you need a consistent layout.
Remember that AutoFit is a one-time adjustment. Excel does not continuously resize a column every time a cell changes. If an entry later becomes longer, repeat AutoFit. For a frequently changing report, leave some extra width or use wrapping to reduce the chance of clipped text.

Troubleshooting

The column did not change width. Confirm that you double-clicked the boundary between the correct pair of headers and that the pointer showed the double-headed arrow. You can select the column and try Home > Format > AutoFit Column Width instead. If the worksheet is protected, Excel may prevent column formatting; check the Review tab or ask the workbook owner whether formatting is allowed.

Text still appears cut off. Check whether the text is actually in the cell you expect, whether the column is hidden, and whether a neighboring cell contains data. Text in an unwrapped cell can visually spill into an empty cell to its right, but it will not spill over a neighboring cell that already contains content. AutoFit should normally expand the column for the longer entry; if it does not, try the ribbon command and check for merged cells or unusual formatting.

The column becomes much too wide. Look for an unusually long note, URL, identifier, or other value anywhere in the column. AutoFit uses the longest applicable displayed entry, not an average. If you want a compact layout, shorten or wrap that entry, set a manual width by dragging the boundary, or use Home > Format > Column Width to enter a specific size.

Merged cells do not AutoFit properly. Excel does not reliably calculate AutoFit width for a cell merged across multiple columns. If practical, unmerge the cells, AutoFit the relevant columns, and then decide whether merging is still necessary. Otherwise, set the column width manually or wrap the merged text and adjust the row height. Take care when unmerging, since the value is retained in only one cell of the merged range.

AutoFit seems to ignore a long entry. Check whether the cell is merged, whether the column is hidden, and whether the entry contains line breaks or wrapping. Also confirm that the text is not clipped by a fixed width you restored afterward. For very long text, Excel’s maximum column width can be reached; AutoFit cannot make a column wider than that limit. Use wrapping or keep the text in a wider layout instead.

Frequently Asked Questions

What is the fastest way to AutoFit a column in Excel?
For most Windows users, select the column and double-click the boundary to the right of its header. The keyboard sequence Alt, H, O, I is another quick option; press those keys in order, not simultaneously.

Can I AutoFit more than one column at a time?
Yes. Select multiple column headers, then double-click a boundary or choose Home > Format > AutoFit Column Width. Excel calculates a separate best-fit width for each selected column. Use Ctrl-click on Windows or Command-click on Mac to select nonadjacent headers.

Can I AutoFit row height as well?
Yes. Select the row or rows, then choose Home > Format > AutoFit Row Height. This is useful for wrapped text that occupies multiple lines. AutoFit row height is a separate command from AutoFit Column Width.

Does AutoFit resize a column automatically when I edit a cell?
No. AutoFit sets the width at the time you run the command. If you later enter longer text or change formatting, run AutoFit again or adjust the width yourself.

Why does AutoFit make a column so wide?
Usually, one entry in the column is much longer than the rest, or formatting makes a displayed value wider. Find the outlier, then shorten it, wrap it, or set a manual width if a wide column is not useful for your worksheet.

Is there a maximum AutoFit column width?
Yes. Excel columns have a maximum width, so exceptionally long content may still not display on one line after AutoFit. Wrap the text, increase row height, or use a layout that allows the content to span more space.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.