Excel Shortcuts
Frequently used29
| Paste | ⌘V |
| Copy | ⌘C |
| Save | ⌘S |
| Undo | ⌘Z |
| Redo | ⌘Y |
| Cut | ⌘X |
| Bold | ⌘B |
| ⌘P | |
| Fill Down | ⌘D |
| Fill Right | ⌘R |
| Insert Cells | ⌃⇧= |
| Delete Cells | ⌘- |
| Calculate All Workbooks | ⌘= |
| Close Window | ⌘W |
| Go To | ⌃G |
| Format Cells | ⌘1 |
| Find and Replace | ⌃H |
| Paste Special | ⌃⌘V |
| Underline | ⌘U |
| Italic | ⌘I |
| New Workbook | ⌘N |
| Save As | ⇧⌘S |
| Select All | ⌘A |
| Add/Remove Filter | ⇧⌘F |
| Expand/Collapse Ribbon | ⌥⌘R |
| Open Workbook | ⌘O |
| Insert Hyperlink | ⌘K |
| Create Names | ⇧⌘F3 |
| Find | ⌘F |
Windows and dialog boxes3
| Full Screen | ⌃⌘F |
| Minimize Window | ⌃F9 |
| Hide Excel | ⌘H |
Move and scroll10
| Move to Edge Up | ⌘↑ |
| Move to Edge Down | ⌘↓ |
| Move to Edge Left | ⌘← |
| Move to Edge Right | ⌘→ |
| Move to Beginning | ⌃Home |
| Move to Last Cell | ⌃End |
| Scroll Screen Right | ⌥Page Down |
| Scroll Screen Left | ⌥Page Up |
| Next Sheet | ⌃Page Down |
| Previous Sheet | ⌃Page Up |
Enter data9
| Edit Cell | F2 |
| Confirm Entry | ↩ |
| New Line in Cell | ⌥↩ |
| Fill Selected Range | ⌘↩ |
| Confirm & Move Up | ⇧↩ |
| Next Cell | Tab |
| Previous Cell | ⇧Tab |
| Insert Note | ⇧F2 |
| Threaded Comment | ⇧⌘F2 |
Cells and Formula bar10
| Expand Formula Bar | ⌃⇧U |
| Array Formula | ⇧⌘↩ |
| Formula Builder | ⇧F3 |
| Define Name | ⌘F3 |
| Toggle Reference Style | ⌘T |
| AutoSum | ⇧⌘T |
| Enter Date | ⌃; |
| Enter Time | ⌘; |
| Toggle Formulas | ⌃` |
| AutoComplete List | ⌥↓ |
Format and edit18
| Create Table | ⌘T |
| Increase Font Size | ⇧⌘> |
| Decrease Font Size | ⇧⌘< |
| Align Center | ⌘E |
| Align Left | ⌘L |
| General Format | ⌃⇧~ |
| Currency Format | ⌃⇧$ |
| Percentage Format | ⌃⇧% |
| Date Format | ⌃⇧# |
| Time Format | ⌃⇧@ |
| Number Format | ⌃⇧! |
| Outline Border | ⌥⌘0 |
| Remove Borders | ⌥⌘- |
| Strikethrough | ⇧⌘X |
| Hide Column | ⌘) |
| Unhide Column | ⇧⌘) |
| Hide Row | ⌘( |
| Unhide Row | ⇧⌘( |
Select cells6
| Select Column | ⌃Space |
| Select Row | ⇧Space |
| Extend to Beginning | ⌃⇧Home |
| Extend to Last Cell | ⌃⇧End |
| Extend Selection | F8 |
| Add to Selection | ⇧F8 |
Work with selection4
| Delete Selection | ⌃- |
| Group Cells | ⇧⌘K |
| Ungroup Cells | ⇧⌘J |
| Next Corner of Selection | ⌃. |
Charts1
| Insert Chart | F11 |
Sort and filter1
| Sort Dialog | ⇧⌘R |
Outline3
| Toggle Outline Symbols | ⌃8 |
| Hide Rows (Outline) | ⌃9 |
| Hide Columns (Outline) | ⌃0 |
Drawing1
| Toggle Drawing Mode | ⌃⌘Z |
Access Excel shortcuts from your menu bar
KeyShortcut detects the active app and shows its shortcuts instantly. No memorization needed.
Paste⌘V
Copy⌘C
Save⌘S