The Excel MAC Shortcuts Cheat Sheet

Hello hello everyone!

Welcome back to a resource for your Excel skills.

Today, we have the Excel MAC Shortcuts Cheat Sheet.

All you need to master Excel (almost).

Here's what you will receive:

👉 THE BASICS

 1. Command + O → Open Workbook
 2. Command + N → New Workbook
 3. Command + S → Save Workbook
 4. Command + T → Insert Table
 5. Command + U → Underline
 6. Command + A → Select All
 7. Command + I → Italicize
 8. Command + Z → Undo
 9. Command + Y → Redo
10. Command + V → Paste
11. Command + C → Copy
12. Command + P → Print
13. Command + B → Bold
14. Command + F → Find
15. Command + X → Cut

👉 THE USEFUL ONES

16. Command + Page Up or Page Down → Toggle Up or Down Tabs
17. Command + ↑ → Jump to first cell in region
18. Command + ↓ → Jump to last cell in region
19. Command + ] → Select Direct Dependents
20. Command + [ → Select Direct Precedents
21. Command + - → Delete Column or Row
22. Command + + → Insert Column or Row
23. Command + Space → Select Column
24. Command + 1 → Format Cells
   
👉 THE HIDDEN GEMS

25. Command + : → Insert Time
26. Command + ; → Insert Date
27. Command + K → Hyperlink
28. Command + E → Flash Fill
29. Command + Q → Analysis
30. Command + H → Replace
31. Command + W → Close
32. Command + G → Go To
   
👉 THE ADVANCED ONES

33. Command + Shift + F3 → Create Named Range from Selection
34. Command + Option + V → Open Paste Special Dialogue Box
35. Command + Shift + F6 → Previous Workbook Window
36. Command + Shift + ` → Convert Format to Plain Text
37. Command + Shift + O → Select Comment Cells
38. Command + Shift + U → Toggle Formula Bar
39. Command + Shift + L → Toggle Filters