Google Sheets Formatting Shortcuts for Excel Users: The Complete Guide

Formatting was the first thing that made me feel slow in Google Sheets. In Excel, Alt+H,H and Alt+H,B,A were so automatic that I could format a whole tab without really looking at the screen. None of that worked in Sheets out of the box, and suddenly I was reaching for the mouse every 30 seconds just to fill a cell.

This post is basically the full list of formatting shortcuts I missed most when I moved off Excel — fill color, borders, autofit, freeze panes, number formats, alignment — and how to get them all back in Sheets. If you used Macabacus or just had years of muscle memory built up, this should cover almost everything you’re trying to recreate.

Number Formats

Number formatting is probably the highest-frequency thing I do in a spreadsheet, so it’s the first thing worth fixing.

• Ctrl+Shift+1: cycle through general number formats. I use this constantly.
• Ctrl+Shift+4: currency.
• Ctrl+Shift+5: percentage.
• Ctrl+Shift+3: date.
• Alt+H,9: fewer decimals.
• Alt+H,0: more decimals.

Sheets does Ctrl+Shift+5 for percentage natively, but the number format cycle and the quick decimal controls aren’t there until you add XLKeys. On Mac, swap Ctrl for Cmd on the hold-style ones.

Fill Color (Alt+H,H)

Alt+H,H is one of those shortcuts that just becomes part of you in Excel. You stop thinking about it — you just hit it whenever you want to shade a cell. The first time it didn’t work in Sheets I genuinely felt personally betrayed.

There’s a fill color button in the Sheets toolbar, but the Excel ribbon sequence doesn’t map to it. XLKeys adds Alt+H,H back on Windows (Option+H,H on Mac) and it just opens the same fill color picker Google ships with.

I actually use Ctrl+Shift+K (Cmd+Shift+K on Mac) more often — it cycles through a saved palette of fill colors that you can customize in settings, so I can shade a whole section without ever opening the picker. For font color it’s Alt+H,F,C, or Ctrl+’ to cycle through a saved font color palette the same way.

Borders (Alt+H,B)

Borders are how a model goes from "a wall of numbers" to something someone else can actually read. Bottom border under every subtotal, outside border on output boxes, no borders inside working sections — that kind of thing. In Excel, Alt+H,B,A blasts all borders on a selection without leaving the keyboard, and XLKeys gives you the full family:

• Alt+H,B,A: all borders.
• Alt+H,B,N: remove borders.
• Alt+H,B,P: top border.
• Alt+H,B,O: bottom border.
• Alt+H,B,S: outside border.
• Alt+H,B,T: thick outside border.
• Alt+H,B,B: double bottom border (subtotals).

Under the hood these are just the same Sheets border commands you’d get from the toolbar, so the formatting is regular Sheets formatting and copies/exports the way you’d expect.

Autofit Columns and Rows (Alt+H,O)

Autofitting columns is one of those tiny actions you do all day without noticing. Paste in data, rename a header, build an output view — suddenly column widths are wrong.

In Excel, Alt+H,O,I handles it and you’re done. In Sheets natively you can double-click between column headers or right-click → resize → fit to data — both work, neither is as fast as the keyboard. XLKeys adds:

• Alt+H,O,I: autofit column width.
• Alt+H,O,A: autofit row height.
• Alt+H,O,W: set a specific column width.
• Alt+H,O,H: set a specific row height.

Freeze Panes (Alt+W,F)

Freeze panes keep your headers visible while you scroll. Sheets has this under View → Freeze, and Excel users will know Alt+W,F,F.

• Alt+W,F,F: freeze rows and columns at the current selection.
• Alt+W,F,U: unfreeze everything.
• Alt+F,R: freeze rows up to the current selection.
• Alt+F,C: freeze columns up to the current selection.

Same logic as Excel — click the cell just below and to the right of what you want frozen, then hit the shortcut. On Mac, swap Alt for Option.

Alignment, Merge, Paste Special, and the Rest

A grab bag of the other formatting shortcuts that round out the daily workflow:

• Alt+H,A,C / A,L / A,R: center, left, right align.
• Alt+H,A,T / A,M / A,B: top, middle, bottom vertical align.
• Alt+H,6: cycle indent (one, two, three, none).
• Alt+H,M,A: merge all.
• Alt+H,M,U: unmerge.
• Alt+H,E,A: clear all (content + formatting).
• Alt+H,E,F: clear formatting only.
• Alt+W,V,G: toggle gridlines.
• Alt+E,S,V: paste values only.
• Alt+E,S,F: paste formulas only.
• Alt+E,S,T: paste formatting only.

Where to Start

If you’re staring at this list thinking you’ll never remember it all — don’t. Pick the five or six you used the most in Excel and let the rest come naturally over a few weeks.

• Day one: fill color (Alt+H,H), font color (Alt+H,F,C), borders (Alt+H,B,A), number cycle (Ctrl+Shift+1).
• Week one: autofit (Alt+H,O,I) and freeze panes (Alt+W,F,F).
• After that: paste special and alignment as they come up.
• Eventually: formula auditing and Goal Seek / Sensitivity Tables once formatting isn’t costing you time anymore.

Honestly, the easiest way to learn all this is to not try to memorize any of it. Print one out and stick it next to your monitor — you’ll have them all down in a couple weeks without trying.

→ Download a full shortcut cheat sheet here