Excel Alt+H+O+I Not Working? Fix AutoFit Column Width

If Excel’s Alt+H+O+I shortcut is not working, press the keys in sequence rather than holding them all down: press and release Alt, then press H, O, and I. This runs AutoFit Column Width in Excel for Microsoft 365 on Windows; you can also select the column and choose Home > Format > AutoFit Column Width.

What Alt+H+O+I does

This is a ribbon KeyTip sequence, not a conventional keyboard chord. In Windows desktop Excel, Alt activates ribbon KeyTips, H opens the Home tab’s commands, O opens the Format menu, and I selects AutoFit Column Width. Excel adjusts the selected column or columns to fit their contents.

AutoFit is useful when a heading, date, number, or other cell value is cut off because the column is too narrow. For example, if a heading in column B reads Quarterly revenue but only part of it is visible, AutoFit can widen column B to display the entry. It changes column width; it does not change the font size, rewrite the value, or resize the row.

The width is based on the contents and formatting in the selected columns, including displayed formula results. Excel uses its column-width units, which are related to the width of characters in the workbook’s default font, rather than a simple fixed number of pixels. As a result, the fitted width may not look identical across workbooks with different fonts or display settings.

Run the shortcut one key at a time

Click a cell in the column you want to fit. To fit several columns, select their column headers by dragging across them, or select a range of columns with the keyboard.
Press and release Alt. Look for the KeyTips that appear over the ribbon.
Press H to open the Home tab’s KeyTips.
Press O to open the Format menu, then press I for AutoFit Column Width.

Do not press Alt, H, O, and I simultaneously. The plus signs in shortcut notation often imply a combination, but this particular command is a sequence of KeyTips. If the letters shown on your ribbon differ, follow the displayed KeyTips: they can vary with the Excel interface language or ribbon configuration.

If pressing a letter types it into a cell, Excel may be in cell-editing mode. Press Esc to cancel the edit, or Enter to finish it, then try the sequence again. Make sure the worksheet itself is active and that you are not typing in the formula bar or a dialog box.

Use the ribbon or mouse instead

The ribbon command is the clearest alternative when the KeyTip sequence is unfamiliar or unavailable. Select the columns, then choose Home > Format > AutoFit Column Width. The Format control is in the Cells group on the Home tab. If you only need to adjust one column, move the pointer to the right edge of its heading and double-click when the resize pointer appears. Excel will fit the column to its contents.

To fit every column on a worksheet, select the whole sheet using the triangle at the top-left corner between the row numbers and column letters, then choose the AutoFit command. You can also select the sheet and double-click the boundary between any two column headings. This is convenient for a quick cleanup, but be aware that a single unusually long entry can make its column much wider than the others.

For multiple specific columns, select their headers before using AutoFit. If the columns are not next to each other, hold Ctrl while selecting additional column headers on Windows. On a Mac, use Command for nonadjacent selections. The ribbon command then applies to the selected columns rather than requiring you to repeat the operation one column at a time.

Why the shortcut may appear to do nothing

Start by checking that the sequence reached the intended command. Press Alt and watch for KeyTips. If they do not appear, the Excel window may not have focus, a dialog may be open, or a different application may be receiving the keystrokes. Click back into the worksheet and try again. If KeyTips appear but a letter does not match, use the on-screen letters rather than assuming they are the same in every language or layout.

Next, check the selection. If a cell is selected, Excel applies AutoFit to that cell’s column. If you meant to fit several columns, select all of their column headers first. If a column is hidden, AutoFit may not make it visible in the way you expect; first select the surrounding columns and use Home > Format > Hide & Unhide > Unhide Columns, then apply AutoFit.

A protected worksheet can also block changes to column width. If Excel reports that the sheet is protected or the width does not change, check the sheet’s protection settings. A worksheet’s protection options can restrict formatting columns. If you are authorized to change the sheet, use Review > Unprotect Sheet and provide a password if Excel requests one. Do not try to bypass protection on a workbook you are not permitted to edit.

Finally, check whether the width actually changed but the result still looks wrong. A column can be widened while its contents remain visually obscured by merged cells, wrapping, unusual number formats, or a very long value. AutoFit is not a general layout repair tool: it only calculates a suitable width for the selected columns under the current conditions.

Merged cells, wrapped text, and long values

Merged cells are a frequent source of confusion. If a heading spans multiple merged columns, Excel may not AutoFit those columns to the full text as you expect. The text occupies the merged area rather than a single ordinary column, so the normal column-width calculation may not account for it. A practical option is to adjust the column widths manually, or, if the layout allows, unmerge the cells and use a different alignment approach.

For wrapped text, column width and row height are separate. AutoFit Column Width may make the column wider, while the row remains at its previous height. To fit row height to wrapped content, select the row and choose Home > Format > AutoFit Row Height. You can also double-click the boundary below a row number. If a fixed row height is needed for a report, adjust it manually after setting the column width.

AutoFit can also produce an impractically wide column when one cell contains a long sentence, an identifier, or imported text. Consider whether that value should wrap, be shortened for display, or remain in a wider column. You can turn on Home > Wrap Text for selected cells, then use AutoFit Row Height if needed. For a worksheet intended for printing, review the page layout as well: fitting a column to its contents does not guarantee that the whole sheet will fit on one printed page.

Windows, Mac, and Excel for the web

The Alt+H+O+I KeyTip sequence applies to Excel for Microsoft 365 on Windows. Excel for Mac does not use the same Windows ribbon KeyTip sequence. On a Mac, use Home > Format > AutoFit Column Width or double-click the right boundary of a column heading. Some keyboard behavior can depend on the Mac keyboard and Excel settings, so the ribbon and mouse methods are dependable alternatives when the Windows sequence does not apply.

Excel for the web also has a different environment from the Windows desktop app, and browser keyboard shortcuts can affect which keys reach Excel. Use the Home tab’s Format menu and choose AutoFit Column Width, or resize by double-clicking a column boundary if available in your browser. If a keyboard sequence is intercepted by the browser or does not show the expected KeyTips, the ribbon command avoids relying on that sequence.

Another useful distinction: AutoFit is not the same as manually setting a width. AutoFit calculates a width from the current contents; a manual width remains the size you choose even if the values later change. If a workbook must keep a consistent report layout, a fixed width may be preferable. If it is a working data sheet where visibility matters most, AutoFit is often the quicker choice.

A quick troubleshooting checklist

Confirm you are using Windows desktop Excel if you are following the Alt+H+O+I sequence.
Press and release each key in order; do not hold the four keys together.
Exit cell editing or close any open dialog, then click a worksheet cell.
Select the intended column headers, especially when fitting more than one column.
Check for sheet protection, hidden columns, merged cells, and wrapped text.
Use Home > Format > AutoFit Column Width if the KeyTips are unavailable or confusing.

If none of these steps changes the width, test the command on a normal, unmerged column in an unprotected worksheet. If it works there, the shortcut itself is functioning and the issue is more likely tied to the original sheet’s selection, protection, or layout. If it does not work anywhere, verify that the active application is Excel and that your keyboard is sending the expected keys.

Frequently Asked Questions

Do I hold Alt, H, O, and I at the same time?

No. Press and release Alt, then press H, O, and I in order. It is a ribbon KeyTip sequence, not a four-key chord.

What does Alt+H+O+A do?

In Windows desktop Excel, the sequence Alt, H, O, A runs AutoFit Row Height. It adjusts selected rows to fit their contents; it does not change column width.

Can I AutoFit every column at once?

Yes. Select the entire worksheet using the top-left sheet selector, then choose Home > Format > AutoFit Column Width. This may create very wide columns if any cells contain long entries.

Why does AutoFit not work on merged cells?

AutoFit is designed to calculate widths from ordinary column contents, and merged text spans multiple columns. Excel may not size the merged area as expected, so adjust the column widths manually or change the layout if possible.

Is Alt+H+O+I the same in Excel for Mac?

No. That is the Windows desktop KeyTip sequence. On Mac, use Home > Format > AutoFit Column Width or double-click the column-heading boundary.

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.