Excel Shortcuts Cheat Sheet (Windows & Mac)
A complete printable Excel keyboard shortcuts reference for faster productivity.
No shortcuts match your search. Try a different keyword.
Basic Editing
| Action | Windows | Mac |
|---|---|---|
| Copy selection | Ctrl + C | ⌘ + C |
| Paste from clipboard | Ctrl + V | ⌘ + V |
| Undo last action | Ctrl + Z | ⌘ + Z |
| Redo undone action | Ctrl + Y | ⌘ + Y |
| Cut selection | Ctrl + X | ⌘ + X |
| Fill down from cell above | Ctrl + D | ⌘ + D |
| Select entire worksheet | Ctrl + A | ⌘ + A |
Navigation
| Action | Windows | Mac |
|---|---|---|
| Move between cells | Arrow keys | Arrow keys |
| Jump to edge of data | Ctrl + Arrow | ⌘ + Arrow |
| Open Go To dialog | Ctrl + G | ⌃ + G |
| Switch to next sheet | Ctrl + Page Down | ⌃ + Page Down |
| Switch to previous sheet | Ctrl + Page Up | ⌃ + Page Up |
| Open Find panel | Ctrl + F | ⌘ + F |
Data Selection
| Action | Windows | Mac |
|---|---|---|
| Select entire row | Shift + Space | Shift + Space |
| Select entire column | Ctrl + Space | ⌃ + Space |
| Select current data region | Ctrl + Shift + * | ⌃ + Shift + * |
| Extend selection to last used cell | Ctrl + Shift + End | ⌘ + Shift + End |
Formatting
| Action | Windows | Mac |
|---|---|---|
| Apply bold | Ctrl + B | ⌘ + B |
| Apply italic | Ctrl + I | ⌘ + I |
| Apply underline | Ctrl + U | ⌘ + U |
| Open Format Cells dialog | Ctrl + 1 | ⌘ + 1 |
| Apply currency format | Ctrl + Shift + $ | ⌃ + Shift + $ |
| Apply percent format | Ctrl + Shift + % | ⌃ + Shift + % |
Formulas
| Action | Windows | Mac |
|---|---|---|
| Start or edit a formula | = or F2 | = or F2 |
| AutoSum nearby numbers | Alt + = | ⌥ + = |
| Show or hide formulas in cells | Ctrl + ` | ⌃ + ` |
| Open Insert Function dialog | Shift + F3 | Shift + F3 |
| Recalculate all worksheets | F9 | F9 |
| Toggle AutoFilter on data | Ctrl + Shift + L | ⌃ + Shift + L |
Download & Print
Free to use. No login required.
Frequently Asked Questions
QWhat are the most useful Excel shortcuts?
The highest-impact shortcuts are copy/paste (Ctrl+C / Ctrl+V), undo (Ctrl+Z), AutoSum (Alt+=), fill down (Ctrl+D), toggle filter (Ctrl+Shift+L), and row/column select (Shift+Space / Ctrl+Space). Learning these six alone saves significant time.
QIs there a printable Excel shortcuts cheat sheet?
Yes. This page lists every shortcut in a printable layout. Click Download PDF Cheat Sheet or Print Version to save as PDF or print a paper copy for your desk.
QWhat is Ctrl + Shift + L in Excel?
Ctrl + Shift + L toggles AutoFilter on the current data range (dropdown arrows in the header row). Press it again to remove filters—one of the most-used shortcuts for working with lists.
QHow do I learn Excel shortcuts fast?
Practice 3–5 shortcuts at a time in real tasks. Start with copy, undo, filter, and AutoSum, then add navigation and formatting keys. Printing this cheat sheet and keeping it nearby accelerates muscle memory.
QAre Excel shortcuts the same on Mac?
Most actions match, but modifier keys differ: Windows uses Ctrl while Mac uses ⌘ (Command). Some combos on Mac use ⌃ (Control) or ⌥ (Option). Every shortcut on this page shows both platforms side by side.