AutoFit Column Width Shortcut in Excel on Mac (Alt + O C A)

💡
Quick Answer

The Excel 2003 AutoFit column width shortcut is Alt + O C A (Format > Column > AutoFit Selection). On a Mac, install Accelerator Keys, select the columns, then press Option, then O, then C, then A. Each column fits its widest selected cell.

Download Accelerator Keys for Free Now

If you are looking for the AutoFit column width shortcut in Excel on Mac, Alt + O C A is the one many Windows users know from Excel 2003. Windows Excel still accepts it. With Accelerator Keys, it works on your Mac too.

What Does Alt + O C A Do?

Alt + O + C + A is the legacy shortcut for Format > Column > AutoFit Selection. It sets each selected column to the width of its widest selected cell. The name in Excel 2003 is AutoFit Selection, because Excel uses only the cells you select.

Legacy vs. Modern Shortcut Comparison

Shortcut Era Menu Path
Alt + O + C + A Legacy (Excel 2003) Format > Column > AutoFit Selection
Alt + H + O + I Modern (Ribbon) Home > Format > AutoFit Column Width

Both shortcuts work with Accelerator Keys.

How It Works on Mac

On your Mac, Accelerator Keys runs Format > Column > AutoFit Selection in the Excel menu bar. It works on any ribbon tab and at any window width.

Step-by-Step: How to do Alt + O C A on Mac Excel

  1. Install the Fix: Download Accelerator Keys (14-day free trial, no credit card required).
  2. Select the columns: Select full columns to fit all their content. Select the full sheet with Cmd + A to fit all columns.
  3. Press Option: Press the Option key. It works like Alt on Windows.
  4. Press the letters one at a time: Press O, then C, then A.
  5. Result: Excel fits each column to its content.

Frequently asked questions

Does Alt + O C A work natively on Mac Excel?

No. Excel for Mac’s own KeyTips do not support the legacy Alt + E, Alt + I, Alt + O, and Alt + D menu keys. Accelerator Keys adds them. Press Option, then O, then C, then A.

Why did Alt + O C A not fit the full column?

AutoFit Selection uses only the selected cells. If you select one cell, Excel fits the column to that cell. Select the full column first.

What is the modern equivalent of Alt + O C A?

The modern ribbon shortcut is Alt + H + O + I (Home > Format > AutoFit Column Width). Both work on Mac with Accelerator Keys.

Related Links