RibbonKeys Teams Download

Alt H O I on a Mac: auto-fit column width in Excel

Alt H O I on a Mac is Option, then H O I: with RibbonKeys, that auto-fits the column width in Excel for Mac, as Alt+H+O+I does on Windows. Out of the box, Excel for Mac does not take Alt+H+O+I. Without an app, double-click the right-hand border of the column heading, or choose Format › Column › Auto-fit Selection in the menu bar.

H opens the Home tab, O opens Format, and I is Auto-fit Column Width. Option is the Mac's Alt key, so Alt+H+O+I, Alt H O I and Alt HOI are all the same four keys.

The same Format menu has Auto-fit Row Height on A, so H O A fits the row. Column Width is H O W, and Row Height is H O H. The Excel 2003 menu key O C A is Format, Column, Auto-fit Selection, which is a different command from H O I.

An open Format dropdown with a letter in front of each item, such as H for Row Height and I for Auto-fit Column Width.

When you reach for Alt HOI

The keys, one letter at a time

  1. Select a cell in the column, or the columns, to fit.
  2. Tap ⌥ by itself while Excel is in front. You can also hold ⌥ down with the first letter, as Alt+H works on Windows.
  3. Type H for Home, then O for Format. The Format dropdown opens, with a letter on every item, as in the picture.
  4. Type I for Auto-fit Column Width.

Everything else in the Format menu

Since O has opened the menu, the rest of it is one letter away.

Column Width and Row Height open a small dialog with the keyboard already in its text box. What you type goes in as text, so type the number and press Return. Tap ⌥ if you want the dialog's letters instead.

On Windows, and on a Mac without RibbonKeys

On Windows the sequence is Alt+H+O+I, and the older menu keys Alt+O+C+A do a related thing, Format, Column, Auto-fit Selection. Excel for Mac has the command, in the Format dropdown of the Home tab and in the Format menu of the menu bar, but without RibbonKeys it is reached with the mouse; so is the common alternative of double-clicking the border between two column headings. Excel for Mac's own KeyTips, off by default, are explained on the KeyTips page.

What to press next

After fitting the columns, W F R freezes the top row so the headings stay in view, and H V V pastes values when the numbers should lose their formulas. The full list has every letter of the Home tab.

Questions

How do I do Alt HOI on a Mac?

With RibbonKeys, select the column, tap Option and type H O I. H opens the Home tab, O opens Format and I is Auto-fit Column Width. It is the same sequence as Alt+H+O+I on Windows.

How do I auto-fit column width in Excel for Mac without RibbonKeys?

Double-click the right-hand border of the column heading, or select the columns and choose Format › Column › Auto-fit Selection in the menu bar. Home › Format › Auto-fit Column Width on the ribbon does the same. Excel's own KeyTips, off by default, reach the Format menu, but its items are then chosen with the arrow keys.

What does Alt HOI do in Excel?

Alt HOI is Alt+H+O+I. It chooses Home, Format, Auto-fit Column Width, which sets the width of the selected columns to fit what is in them.

How do I fit the row height instead of the column width?

Tap Option and type H O A, which is Auto-fit Row Height in the same Format menu. H O H is Row Height and H O W is Column Width.

Download RibbonKeys

Free for 7 days, with no account and no card. After that €3.99 a month or €59.99 once, including VAT.
The same licence covers Word and PowerPoint.
Needs macOS 13 or later and Excel for Mac.

Windows Excel shortcuts on a Mac · Every shortcut · RibbonKeys