Press Alt once and Excel displays key labels on every ribbon tab. From there, pressing the displayed keys in sequence takes you to any ribbon function — no mouse required.
Shortcuts you will master in this article
Alt + H + H / Alt + A + V + V / Alt + H + F + C / Alt + H + B
Fill color, font color, borders — these formatting operations involve small icons on the ribbon, and repeatedly clicking precisely on them disrupts your working rhythm. Each click takes only seconds, but done dozens of times a day, the friction accumulates.
Excel's ribbon has a built-in keyboard navigation system called access keys. Press Alt to display letter labels on every ribbon tab, then press those letters in sequence to reach any function without touching the mouse.
Start by learning how to display access key labels with Alt, then work through the most common sequences.
AltPress Alt once to show letter labels above each tab. Press the corresponding letter to open that tab, which reveals another layer of labels for the functions within it. Press Esc to dismiss.
Tip: Moving the mouse after pressing Alt doesn't close the ribbon overlay. While learning, you can watch the labels appear and choose at your own pace.
Alt → H → HAlt activates the ribbon → H opens the Home tab → H opens the Fill Color palette. Three keystrokes total. Use the arrow keys to select a color and press Enter to confirm.
Tip: Recently used colors appear at the top of the palette, so repeatedly applying the same color becomes faster over time.
Alt → H → F → CH opens the Home tab → F opens the Font group submenu → C opens the font color palette. Select a color with the arrow keys and confirm with Enter.
Tip: Font color changes pair well with bold (Ctrl+B) for formatting header cells.
Alt → H → BH opens the Home tab → B opens the borders submenu. Use the arrow keys to choose options like 'Outline', 'All Borders', or 'Bottom Double Border'.
Tip: In common practice, double bottom border (U) is used for totals rows and outline (S) is used for header rows.
Alt → A → V → VA opens the Data tab → V opens the data validation submenu → V opens the 'Data Validation...' dialog. Set dropdown lists or input restrictions here.
Tip: For detailed setup instructions, see the article 'Setting Up Dropdown Lists with Alt+A+V+V'.
Excel Shortcut Practice
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + 1 | Format Cells Dialog |
Ctrl + Shift + L | Toggle AutoFilter |
Ctrl + B | Bold |
Ctrl + I | Italic |
A. The ribbon access key system (sequential Alt key presses) is generally not available in Mac Excel. Mac Excel uses different shortcuts assigned to Cmd and Option keys.
A. Press Esc to exit ribbon navigation mode and start over from Alt.
A. This can happen in full-screen mode or with certain keyboard configurations. Make sure the ribbon isn't collapsed and try reopening Excel in a normal window.
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →