Excel shortcuts
- 95 shortcuts
- 12 sections
- Microsoft Office
- Also on: Windows
- Verified against official docs
Your answer helps keep this page right.
Do these shortcuts work for you?
The Excel shortcuts that save the most time are the navigation ones: Move to Edge Down and the other "move to edge" shortcuts jump to the end of the current block of data, and holding Shift selects the cells on the way. Format Cells opens the full formatting dialog, and Fill Down copies the top cell of the selection into the cells below.
Start with these
Tips for Excel
- Add Shift to any "move to edge" shortcut to select everything between the active cell and the edge of the data. It is the fastest way to select a column for a formula or a chart.
- Paste Special ⌃⌘V pastes only what you choose: values, formats or formulas. Use it to paste the results of formulas without the formulas themselves.
- Add/Remove Filter ⇧⌘F turns the header row into filter drop-downs. Press it again to remove them.
Jump to section
Frequently used29
| Action | Shortcut |
|---|---|
| Paste | |
| Copy | |
| Save | |
| Undo | |
| Redo | |
| Cut | |
| Bold | |
| Fill Down | |
| Fill Right | |
| Insert Cells | |
| Delete Cells | |
| Calculate All Workbooks | |
| Close Window | |
| Go To | |
| Format Cells | |
| Find and Replace | |
| Paste Special | |
| Underline | |
| Italic | |
| New Workbook | |
| Save As | |
| Select All | |
| Add/Remove Filter | |
| Expand/Collapse Ribbon | |
| Open Workbook | |
| Insert Hyperlink | |
| Create Names | |
| Find |
Windows and dialog boxes3
| Action | Shortcut |
|---|---|
| Full Screen | |
| Minimize Window | |
| Hide Excel |
Move and scroll10
| Action | Shortcut |
|---|---|
| Move to Edge Up | |
| Move to Edge Down | |
| Move to Edge Left | |
| Move to Edge Right | |
| Move to Beginning | |
| Move to Last Cell | |
| Scroll Screen Right | |
| Scroll Screen Left | |
| Next Sheet | |
| Previous Sheet |
Enter data9
| Action | Shortcut |
|---|---|
| Edit Cell | |
| Confirm Entry | |
| New Line in Cell | |
| Fill Selected Range | |
| Confirm & Move Up | |
| Next Cell | |
| Previous Cell | |
| Insert Note | |
| Threaded Comment |
Cells and Formula bar10
| Action | Shortcut |
|---|---|
| Expand Formula Bar | |
| Array Formula | |
| Formula Builder | |
| Define Name | |
| Toggle Reference Style | |
| AutoSum | |
| Enter Date | |
| Enter Time | |
| Toggle Formulas | |
| AutoComplete List |
Format and edit18
| Action | Shortcut |
|---|---|
| Create Table | |
| Increase Font Size | |
| Decrease Font Size | |
| Align Center | |
| Align Left | |
| General Format | |
| Currency Format | |
| Percentage Format | |
| Date Format | |
| Time Format | |
| Number Format | |
| Outline Border | |
| Remove Borders | |
| Strikethrough | |
| Hide Column | |
| Unhide Column | |
| Hide Row | |
| Unhide Row |
Select cells6
| Action | Shortcut |
|---|---|
| Select Column | |
| Select Row | |
| Extend to Beginning | |
| Extend to Last Cell | |
| Extend Selection | |
| Add to Selection |
Work with selection4
| Action | Shortcut |
|---|---|
| Delete Selection | |
| Group Cells | |
| Ungroup Cells | |
| Next Corner of Selection |
Charts1
| Action | Shortcut |
|---|---|
| Insert Chart |
Sort and filter1
| Action | Shortcut |
|---|---|
| Sort Dialog |
Outline3
| Action | Shortcut |
|---|---|
| Toggle Outline Symbols | |
| Hide Rows (Outline) | |
| Hide Columns (Outline) |
Drawing1
| Action | Shortcut |
|---|---|
| Toggle Drawing Mode |
Report a problem
GitHub is public. Email is private.
More Microsoft Office shortcuts
Explore more macOS apps
Frequently Asked Questions
How many keyboard shortcuts does Excel have on macOS?
Excel has 95 keyboard shortcuts on macOS, organized into 12 sections: Frequently used, Windows and dialog boxes, Move and scroll, Enter data, and more. This page lists all of them with searchable, organized shortcut tables.
Which Excel shortcuts should I learn first?
Start with Fill Down (⌘D), Format Cells (⌘1), Paste Special (⌃⌘V), Add/Remove Filter (⇧⌘F), Go To (⌃G), Find and Replace (⌃H). The sections on this page list the rest.
Can I download Excel shortcuts as a PDF?
Yes. Click the download button at the top of this page to generate a printable PDF cheat sheet with all 95 Excel shortcuts. The PDF includes organized sections, keycap-style key labels, and space for your own notes.
Where is the official Excel keyboard shortcuts documentation?
The official Excel keyboard shortcuts documentation is available on their website. Every shortcut on this page is sourced from and verified against the official documentation to ensure accuracy.
Do these Excel shortcuts work on all Mac keyboards?
Yes. These shortcuts work on all Mac keyboards, including MacBook built-in keyboards and external Apple keyboards. The modifier keys are Command (⌘), Option (⌥), Control (⌃), and Shift (⇧). On keyboards without a Function row, some F-key shortcuts may require holding the Fn key.
Maintained by Vladik Didyk
Access Excel shortcuts from your menu bar
KeyShortcut detects the active app and shows its shortcuts instantly. Switch it on in Settings. No memorization needed.