On this page, you’ll find a comprehensive list of more than 300 Excel shortcuts for both Windows and Mac versions of the program, which can help you boost your efficiency and productivity.
Types of Excel Shortcuts
Managing Excel formulas on the fly can be effortless when you use shortcuts. By learning the most essential shortcuts, you can simplify tasks related to rows and columns. Discover how to use these shortcuts and make working with Excel formulas a breeze!
File
Ribbon
General
Tables and Filters
Drag and Drop
| Shortcut | Windows | Mac |
|---|---|---|
| Drag and cut | drag | drag |
| Drag and copy | Ctrl drag | ⌥ drag |
| Drag and insert | Shift drag | ⇧ drag |
| Drag and insert copy | Ctrl Shift drag | ⌥ ⇧ drag |
| Drag to worksheet | Alt drag | ⌘ drag |
| Drag to duplicate worksheet | Ctrl drag | ⌥ drag |
Navigation
Selection
Active Cell
Extend Selection
Select Special
Cell edit mode
Entering data
Formatting
Conditional Formatting
| Shortcut | Windows | Mac |
|---|---|---|
| Open Conditional Formatting Dialogue Box | Alt O D | |
| Clear Conditional from Selected Cells | Alt H L C S | |
| Clear Conditional from the Entire Worksheet | Alt H L C E |
Number Formatting
Borders
Formulas
Grid Operations
Pivot Tables
| Shortcut | Windows | Mac |
|---|---|---|
| Select entire pivot table | Ctrl A | ⌘ A |
| Toggle pivot table field checkbox | Space | Space |
| Group pivot table items | Alt Shift → | ⌘ ⇧ K |
| Ungroup pivot table items | Alt Shift ← | ⌘ ⇧ J |
| Hide pivot table item | Ctrl – | Ctrl – |
| Unhide pivot table item | Alt H S C | |
| Create pivot chart on same worksheet | Alt F1 | |
| Create pivot chart on new worksheet | F11 | Fn F11 |
| Insert pivot chart | Alt N S Z C | |
| Show or Hide All Field Buttons on PivotChart | Alt J T D A | |
| Open pivot table wizard | Alt D P | ⌘ ⌥ P |
Workbook
Dialog boxes
Other
Why Learn Shortcuts?
Learning shortcuts in Excel is essential for improving your productivity and efficiency when working with the program. Here are some reasons why.
Saves time, Increases accuracy, Improves workflow and Enhances versatility.
Overall, mastering Excel shortcuts can help you become a more proficient and productive user of the program.
Best Way to Learn Excel Shortcuts
The best way to learn Excel shortcuts is through a combination of practice, repetition, and visualization. Here are some steps you can follow:
- Identify the most useful shortcuts: Focus on the shortcuts that you use frequently or those that can help you improve your workflow and productivity.
- Create a cheat sheet: Create a cheat sheet or reference guide that you can keep handy while you work. The cheat sheet should include a list of shortcuts, their functions, and any necessary keystrokes.
- Practice, practice, practice: Start using the shortcuts in your everyday work. Even if it feels slower at first, keep practicing until the shortcuts become second nature to you.
- Visualize the keystrokes: Visualize the keystrokes in your mind as you work. This will help you memorize the shortcuts and use them more efficiently.
- Seek out additional resources: There are many resources available online that can help you learn Excel shortcuts, such as video tutorials, articles, and interactive quizzes.
By following these steps and making a conscious effort to use shortcuts in your everyday work, you can quickly become proficient at using shortcuts in Excel and significantly improve your productivity.