How to Autofit Column Width in Google Sheets (Without Double-Clicking)

Quick answer: Google Sheets has no keyboard shortcut for autofit column width. Every native option is mouse-based — double-click the column border, or right-click the column header and pick Resize column → Fit to data. If you want Excel’s Alt H O I keystroke to work in Sheets, you need a Chrome extension. This post covers all of it: the native methods (including the ones that handle many columns at once), the gotchas, and the keyboard option.

Method 1: Double-Click the Column Border

The classic. Hover over the right edge of the column header — the letter at the top — until the cursor turns into a double arrow, then double-click. The column snaps to fit its widest content.

It works, but it gets old fast: you’re aiming at a target a few pixels wide, and it only resizes one column at a time unless you pre-select more. Doing this on a laptop trackpad across eight columns of a model is genuinely annoying.

Method 2: Right-Click → Resize Column → Fit to Data

• Right-click the column header (the letter, not a cell).
• Choose “Resize column.”
• Pick “Fit to data” and click OK.

Same result as the double-click, three clicks instead of one. The one reason to use it: the same dialog lets you type an exact pixel width, which is what you want when you’d rather have uniform columns than autofit ones.

If you’re coming from Excel and went hunting through the Format menu first — that’s not where it lives. Excel puts autofit under Home → Format → AutoFit Column Width; in Sheets, column resizing only exists in the right-click menu on the column header.

Method 3: Autofit Several Columns at Once

This is the one most people miss. Select multiple column headers first — click column B, hold Shift, click column H — then double-click any selected column’s border. Every selected column autofits to its own content. The right-click route works too: with the columns selected, choose “Resize columns B – H” → “Fit to data.”

To autofit the entire sheet, click the blank corner box above row 1 and left of column A (or press Ctrl + A twice) to select everything, then double-click any column border. Two actions and the whole grid is readable.

There’s No Native Keyboard Shortcut (Yes, Really)

If you came from Excel, your hands already know Alt → H → O → I: Home ribbon, Format, AutoFit Column Width. Google Sheets has no equivalent. Nothing on the official shortcut list, nothing in the Format menu, and the “Enable compatible spreadsheet shortcuts” toggle (Help → Keyboard shortcuts) doesn’t add one either. Column resizing in Sheets is mouse-only, full stop.

Getting Alt H O I Back

This bugged me enough that it’s one of the first shortcuts I built XLKeys around. It’s a free Chrome extension that makes Excel’s Alt-key sequences work in Google Sheets, and Alt H O I does exactly what your hands expect:

• Select a cell in each column you want to resize — or whole columns, or the entire sheet.
• Press Alt, release it, then type H, O, I (Option → H → O → I on Mac).
• Every column in the selection snaps to fit its content.

The related sequences come along too: Alt H O A autofits row height, and Alt H O W sets an exact column width. And if autofit isn’t the only shortcut you’re missing, the full Excel-to-Sheets conversion table covers what Sheets has natively and what the extension adds.

Which Method Should You Use?

If you autofit columns more than a couple times a day, install XLKeys and let your hands do it — Alt H O I, same as Excel.