Excel Keyboard Shortcuts Cheatsheet (2026)
Learning ten shortcuts saves an hour a week. Learning fifty changes how you think about Excel. This cheatsheet organizes 130+ shortcuts by category, with Windows and Mac keys side by side, plus a "top 20 to memorize first" section if you don't know where to start.
What's in this cheatsheet
Top 20 to memorize first
If you learn nothing else from this guide, these twenty will change how you work.
| Shortcut (Win) | Shortcut (Mac) | Does what |
|---|---|---|
| Ctrl+C | Cmd+C | Copy |
| Ctrl+V | Cmd+V | Paste |
| Ctrl+Z | Cmd+Z | Undo |
| Ctrl+Y | Cmd+Y | Redo |
| Ctrl+S | Cmd+S | Save |
| Ctrl+F | Cmd+F | Find |
| Ctrl+H | Cmd+H | Replace |
| Ctrl+Arrow | Cmd+Arrow | Jump to edge of data |
| Ctrl+Shift+Arrow | Cmd+Shift+Arrow | Select from cursor to edge of data |
| Ctrl+Home | Cmd+Home / Fn+Ctrl+Left | Go to A1 |
| Ctrl+End | Cmd+End / Fn+Ctrl+Right | Go to last used cell |
| F2 | Ctrl+U | Edit the active cell |
| F4 | Cmd+T (in formulas) / Cmd+Y (repeat) | Toggle $ in formula / repeat last action |
| Alt+= | Cmd+Shift+T | AutoSum |
| Ctrl+; | Ctrl+; | Insert today's date |
| Ctrl+Shift+; | Cmd+Shift+; | Insert current time |
| Ctrl+B | Cmd+B | Bold |
| Ctrl+1 | Cmd+1 | Format Cells dialog |
| Ctrl+PageUp / PageDown | Fn+Ctrl+Up / Down | Previous / next sheet tab |
| Ctrl+Shift+L | Cmd+Shift+F | Toggle AutoFilter |
Pick five from the top 20 and use only those for a week. Deliberately catch yourself reaching for the mouse and use the shortcut instead. Next week, add five more. In a month, all twenty are muscle memory.
Navigation
| Windows | Mac | Action |
|---|---|---|
| Arrow keys | Arrow keys | Move one cell in that direction |
| Ctrl+Arrow | Cmd+Arrow | Jump to edge of current data region |
| Ctrl+Home | Cmd+Home | Go to A1 |
| Ctrl+End | Cmd+End | Go to last used cell |
| Home | Home / Fn+Left | Go to start of row (column A) |
| Page Up / Page Down | Fn+Up / Fn+Down | Scroll one screen up/down |
| Alt+Page Up / Down | Option+Fn+Up / Down | Scroll one screen left/right |
| Ctrl+Page Up / Down | Option+Left / Right | Previous / next sheet |
| Ctrl+G | F5 | Go To dialog |
| Ctrl+F | Cmd+F | Find dialog |
| Tab | Tab | Move one cell right |
| Shift+Tab | Shift+Tab | Move one cell left |
| Enter | Return | Move down (or as set in Options) |
| Shift+Enter | Shift+Return | Move up |
| F5 then type a reference | F5 | Jump to any cell/range/name |
Selection
| Windows | Mac | Action |
|---|---|---|
| Shift+Arrow | Shift+Arrow | Extend selection one cell |
| Ctrl+Shift+Arrow | Cmd+Shift+Arrow | Extend selection to edge of data |
| Ctrl+Shift+End | Cmd+Shift+End | Extend selection to last used cell |
| Ctrl+Shift+Home | Cmd+Shift+Home | Extend selection back to A1 |
| Shift+Space | Shift+Space | Select entire row |
| Ctrl+Space | Ctrl+Space | Select entire column |
| Ctrl+A | Cmd+A | Select current region (press twice for entire sheet) |
| Ctrl+Shift+Space | Cmd+Shift+Space | Same as Ctrl+A |
| Ctrl+. | Cmd+. | Move active cell around corners of selection |
| F8 | F8 | Enable Extend Selection mode |
| Shift+F8 | Shift+F8 | Add non-adjacent cells to selection |
| Ctrl+Backspace | Cmd+Delete | Scroll back to active cell |
Editing
| Windows | Mac | Action |
|---|---|---|
| F2 | Ctrl+U | Edit active cell (cursor at end) |
| Delete | Fn+Delete | Clear cell contents |
| Backspace | Delete | Delete character left / clear when editing |
| Esc | Esc | Cancel edit |
| Ctrl+D | Cmd+D | Fill down from cell above |
| Ctrl+R | Cmd+R | Fill right from cell to the left |
| Ctrl+Enter | Ctrl+Return | Fill selection with the same value |
| Alt+Enter | Option+Return | Insert line break within a cell |
| Ctrl+; | Ctrl+; | Insert today's date |
| Ctrl+Shift+; | Cmd+Shift+; | Insert current time |
| Ctrl+' | Ctrl+' | Copy formula from cell above |
| Ctrl+Shift+" | Ctrl+Shift+" | Copy value from cell above |
| Ctrl+K | Cmd+K | Insert hyperlink |
| F4 | Cmd+Y | Repeat last action |
Formatting
| Windows | Mac | Action |
|---|---|---|
| Ctrl+1 | Cmd+1 | Format Cells dialog |
| Ctrl+B | Cmd+B | Bold |
| Ctrl+I | Cmd+I | Italic |
| Ctrl+U | Cmd+U | Underline |
| Ctrl+5 | Cmd+Shift+X | Strikethrough |
| Ctrl+Shift+~ | Ctrl+Shift+~ | Apply General format |
| Ctrl+Shift+$ | Ctrl+Shift+$ | Currency format |
| Ctrl+Shift+% | Ctrl+Shift+% | Percentage format |
| Ctrl+Shift+# | Ctrl+Shift+# | Date format |
| Ctrl+Shift+@ | Ctrl+Shift+@ | Time format |
| Ctrl+Shift+! | Ctrl+Shift+! | Number format with commas |
| Ctrl+Shift+^ | Ctrl+Shift+^ | Scientific notation |
| Ctrl+Shift+& | Cmd+Option+0 | Apply border around selection |
| Ctrl+Shift+_ | Cmd+Option+_ | Remove all borders |
| Alt+H, H | — | Fill color (opens picker) |
| Alt+H, F, C | — | Font color |
| Alt+H, A, C | — | Center align |
| Alt+H, W | — | Wrap text |
| Alt+H, M, M | — | Merge cells |
Formulas
| Windows | Mac | Action |
|---|---|---|
| = | = | Start a formula |
| Alt+= | Cmd+Shift+T | AutoSum |
| F2 | Ctrl+U | Edit active cell / formula |
| F4 (in formula) | Cmd+T | Toggle absolute/relative reference |
| F9 | Fn+F9 | Calculate all workbooks |
| Shift+F9 | Fn+Shift+F9 | Calculate active sheet only |
| Ctrl+Alt+F9 | Cmd+Option+F9 | Force full recalculation |
| F9 (in formula, on selection) | Fn+F9 | Evaluate selected portion of formula |
| Ctrl+` | Ctrl+` | Toggle formula display (show formulas instead of values) |
| Ctrl+[ | Ctrl+[ | Select cells that this formula references (precedents) |
| Ctrl+] | Ctrl+] | Select cells that reference this cell (dependents) |
| Ctrl+Shift+Enter | Ctrl+Shift+Return | Enter as legacy array formula (rare in modern Excel) |
| Shift+F3 | Fn+Shift+F3 | Insert function dialog |
| Ctrl+A (after typing function name) | Ctrl+A | Open Function Arguments dialog |
| Ctrl+Shift+U | Ctrl+Shift+U | Expand / collapse formula bar |
In a formula, select a cell reference like A1. Press F4: becomes $A$1. Press again: A$1. Again: $A1. Again: back to A1. Cycles through all four absolute/relative combinations without typing $ signs.
Rows & columns
| Windows | Mac | Action |
|---|---|---|
| Ctrl+Plus (+) | Cmd+Shift+Plus | Insert row/column (based on what's selected) |
| Ctrl+Minus (-) | Cmd+Minus | Delete row/column |
| Shift+Space | Shift+Space | Select entire row |
| Ctrl+Space | Ctrl+Space | Select entire column |
| Ctrl+9 | Cmd+9 | Hide selected rows |
| Ctrl+Shift+9 | Cmd+Shift+9 | Unhide rows |
| Ctrl+0 | Cmd+0 | Hide selected columns |
| Ctrl+Shift+0 | Cmd+Shift+0 | Unhide columns (may need to enable in Windows keyboard settings) |
| Alt+H, O, R | — | Rename column |
| Alt+H, O, I | — | Auto-fit column width |
| Alt+H, O, A | — | Auto-fit row height |
Sheets & workbooks
| Windows | Mac | Action |
|---|---|---|
| Ctrl+N | Cmd+N | New workbook |
| Ctrl+O | Cmd+O | Open file |
| Ctrl+S | Cmd+S | Save |
| F12 | Cmd+Shift+S | Save As |
| Ctrl+W | Cmd+W | Close workbook |
| Ctrl+P | Cmd+P | |
| Ctrl+F4 | Cmd+F4 | Close current window |
| Alt+F4 | Cmd+Q | Quit Excel |
| Ctrl+Page Up | Option+Left | Previous sheet |
| Ctrl+Page Down | Option+Right | Next sheet |
| Shift+F11 | Fn+Shift+F11 | Insert new sheet |
| Alt+H, D, S | — | Delete sheet |
| Alt+O, H, R | — | Rename sheet |
| Ctrl+Tab | Cmd+~ | Switch between open workbooks |
View
| Windows | Mac | Action |
|---|---|---|
| Ctrl+F1 | Cmd+Option+R | Show/hide ribbon |
| Ctrl+Shift+F1 | — | Toggle full screen |
| Alt+W, F, F | — | Freeze panes |
| Alt+W, F, R | — | Freeze top row |
| Alt+W, F, C | — | Freeze first column |
| Ctrl+Scroll wheel | Cmd+Scroll | Zoom in/out |
| Alt+V, N | — | Normal view |
| Alt+V, P | — | Page layout view |
| Alt+V, I | — | Page break preview |
Data & filters
| Windows | Mac | Action |
|---|---|---|
| Ctrl+Shift+L | Cmd+Shift+F | Toggle AutoFilter |
| Alt+Down (in filtered header) | Option+Down | Open filter dropdown |
| Ctrl+T | Cmd+T | Create Table from selection |
| Alt+A, S, A | — | Sort A→Z |
| Alt+A, S, D | — | Sort Z→A |
| Alt+A, S, S | — | Open custom Sort dialog |
| Alt+D, P | — | Open PivotTable Wizard (classic) |
| Alt+A, R, A | Cmd+Option+F5 | Refresh all data |
| Alt+A, T | — | Text to Columns |
| Alt+A, V, V | — | Data Validation |
| Ctrl+E | Cmd+E | Flash Fill |
Pivot tables
| Windows | Mac | Action |
|---|---|---|
| Alt+N, V | — | Insert PivotTable |
| Alt+F5 | Cmd+Option+F5 | Refresh the pivot table |
| Alt+Shift+Right (in pivot) | — | Group items |
| Alt+Shift+Left (in pivot) | — | Ungroup items |
| Ctrl+- (on selected pivot items) | Cmd+- | Hide selected items |
| Alt+D, P | — | Classic PivotTable Wizard |
Ribbon shortcuts (Alt keys)
Press Alt and Excel shows letter overlays on every ribbon tab. Press the letter to open that tab, then more letters for individual buttons. Once you learn a sequence, you can execute it fast even without seeing the overlays.
Tab-level shortcuts
| Shortcut | Opens |
|---|---|
| Alt+F | File menu (Backstage view) |
| Alt+H | Home tab |
| Alt+N | Insert tab |
| Alt+P | Page Layout tab |
| Alt+M | Formulas tab |
| Alt+A | Data tab |
| Alt+R | Review tab |
| Alt+W | View tab |
| Alt+L | Developer tab (if enabled) |
| Alt+Q | Search / Tell Me |
Common Alt sequences worth memorizing
| Sequence | Does |
|---|---|
| Alt+H, H | Fill color picker |
| Alt+H, F, C | Font color picker |
| Alt+H, B, A | All borders |
| Alt+H, A, C | Center horizontally |
| Alt+H, A, M | Middle align vertically |
| Alt+H, D, S | Delete sheet |
| Alt+H, I, R | Insert rows |
| Alt+H, I, C | Insert columns |
| Alt+H, O, W | Column width |
| Alt+H, V, V | Paste values only |
| Alt+H, V, S | Paste Special dialog |
| Alt+H, V, T | Paste formats only |
Alt+H, V, V is the single most useful Alt sequence to memorize. It pastes values only — strips formulas, keeps just the results. Essential when copying formula outputs to somewhere else without breaking references. Muscle memory this and never think about "how do I paste values" again.
Special characters & F-keys reference
F-keys at a glance
| Key | Does |
|---|---|
| F1 | Help |
| F2 | Edit active cell |
| F3 | Paste name dialog |
| F4 | Toggle absolute/relative reference / repeat last action |
| F5 | Go To dialog |
| F6 | Switch between worksheet, ribbon, task pane |
| F7 | Spell check |
| F8 | Extend Selection mode |
| F9 | Calculate all workbooks |
| F10 | Activate menu bar (same as Alt) |
| F11 | Create chart on new sheet from selected data |
| F12 | Save As |
Special content shortcuts
| Windows | Mac | Inserts |
|---|---|---|
| Ctrl+; | Ctrl+; | Today's date (static) |
| Ctrl+Shift+; | Cmd+Shift+; | Current time (static) |
| =TODAY() | =TODAY() | Today's date (updates every day) |
| =NOW() | =NOW() | Current date-time (updates on recalc) |
| Alt+Enter | Option+Return | Line break within a cell |
| Alt+numeric keypad codes | Option+letter | Special characters (© ± √ etc.) |
How to actually learn them
Learn in themes, not alphabetically
Pick a category — say, navigation. Learn all six or seven shortcuts. Use only those for a week. Next week, another category. Learning in themed batches beats trying to memorize a random list of 50.
Print the cheatsheet and stick it near your monitor
The friction of alt-tabbing to a cheat sheet is why you forget shortcuts. A printed reference next to your screen catches your eye at the moment you need it.
Cover the mouse button
Literally. Put a sticky note over your trackpad's right-click button, or unplug your mouse for an hour. Forces you to reach for the keyboard for everything.
Watch someone who's fast
YouTube demos of Excel power users are gold. Watch how they navigate — you'll see combinations you didn't know existed. ExcelIsFun and MyOnlineTrainingHub are two channels worth an hour of your time.
Customize with the Quick Access Toolbar
Some things you'll do constantly don't have great shortcuts. Add them to the Quick Access Toolbar (top-left area) and Excel assigns Alt+1, Alt+2, Alt+3 shortcuts to whatever's up there. Custom shortcuts for the actions you actually use.
Enable Excel's built-in shortcut display
Press Alt in modern Excel and letter overlays appear on every ribbon element. Learn common Alt sequences by using this — you don't even need a cheat sheet, Excel tells you the next key to press.
Twenty shortcuts get used in 80% of Excel work. Nail the top 20 above. The other 100+ shortcuts in this guide save time in specific situations — learn them as you encounter the need, not all at once.
Windows/Mac differences summary
Most Windows Ctrl shortcuts translate to Cmd on Mac. The exceptions:
- Function keys often require the Fn modifier on Mac (F5 becomes Fn+F5 on many Mac keyboards)
- Alt on Windows becomes Option on Mac
- Some Ctrl-based shortcuts stay Ctrl on Mac (Ctrl+; for today's date)
- Ribbon Alt sequences don't work on Mac — Mac Excel doesn't have the same ribbon-navigation model
- Right-click menu shortcut: Menu key on Windows, Ctrl+F10 on Mac (or two-finger click on trackpads)
Automate the things you can't shortcut
Shortcuts save seconds; automation saves hours. When a workflow is more than "select, format, save" — reshaping data, building a report, applying rules to hundreds of rows — Excel Wizard generates a one-click macro or Power Query from your plain-English intent.
Install Excel Wizard →Frequently asked questions
What are the most useful Excel keyboard shortcuts?
Top 10 to memorize first: Ctrl+C copy, Ctrl+V paste, Ctrl+Z undo, Ctrl+S save, Ctrl+Arrow to jump to edge of data, Ctrl+Shift+Arrow to select to edge, Ctrl+Home to A1, F2 to edit, Alt+= for AutoSum, Ctrl+; for today's date.
What is the F4 key in Excel?
Two things. In a formula, toggles absolute/relative references (=A1 → =$A$1 → =A$1 → =$A1). Outside a formula, repeats the last action — apply a fill color once, then F4 to reapply on any other cell.
How do I add a row in Excel with a keyboard shortcut?
Shift+Space to select the whole row, then Ctrl+Plus to insert. Ctrl+Minus deletes. Same pattern with Ctrl+Space for columns.
What is the Ctrl+Shift+L shortcut in Excel?
Toggles AutoFilter on/off for the current range. Instant filter dropdowns on any header row.
Are Excel shortcuts the same on Mac?
Mostly — Ctrl becomes Cmd, Alt becomes Option. Some differ (Ctrl+Shift+L on Windows is Cmd+Shift+F on Mac). Ribbon Alt sequences don't work on Mac.