Excel like a finance pro.
← The libraryPractice · 2 questions →
Rows & columns shortcut
AutoFit column width
Alt, H, O, I on Windows, Double-click the column border on Mac.
Very commonDifficulty 1050 · Capable
When to use it
AutoFits the selected columns to their widest content: a ribbon key sequence, pressed one key after another.
The shape of it
- Windows
Alt, H, O, I
- Mac
Double-click the column border
Worked examples
Fit columns
Select the columns, press Alt, then H, O, I → Each column widens or narrows to fit
Instant tidy.
Fit all columns
Ctrl + A, then Alt, H, O, I → Every column fitted
Whole sheet.
Fit rows
Alt, H, O, A → AutoFit row height
The row version.
Worth knowing
- Ribbon key sequence: press Alt, then H, O, I one after another.
- Double-clicking the border between column letters does the same for one column, or all selected.
- Long text cells make the column huge; set wrap text first.
- Set a fixed width with Alt, H, O, W.
Where it goes wrong
- AutoFit ignores merged cells.
- Hidden content still affects the width.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.