The top 100 Microsoft Excel shortcuts that will speed up and improve your productivity
List of top 100 Microsoft Excel shortcuts that will help you work efficiently and quickly:
Basic abbreviations:
1. Ctrl + N → Create a new Excel file
3. Ctrl + S → Save file
4. Ctrl + P → Print file
5. Ctrl + Z → Undo last action
6. Ctrl + Y → Redo the undone action
7. Ctrl + C → Copy
8. Ctrl + X → قص
9. Ctrl + V → Paste
10. Ctrl + A → Select all data in the sheet
---
Navigate within the sheet:
11. Arrow Keys (↑↓←→) → Move between cells
12. Ctrl + ↑ / ↓ / ← / → → Move to the last data in the specified direction
13. Home: Go to the beginning of the row
14. Ctrl + Home → Go to A1
15. Ctrl + End → Move to the last cell containing data
16. Page Up / Page Down → Move between vertical pages
17. Alt + Page Up / Page Down → Move between horizontal pages
---
Working with rows and columns:
18. Ctrl + Space → Select entire column
19. Shift + Space → Select entire row
20. Ctrl + Shift + "+" → Insert new row or column
21. Ctrl + "-" → Delete row or column
22. Ctrl + 9 → Hide selected row
23. Ctrl + 0 → Hide selected column
24. Ctrl + Shift + 9 → Show hidden rows
25. Ctrl + Shift + 0 → Show hidden columns
---
Working with cells and data:
26. F2 → Edit Cell Contents
27. Ctrl + Enter → Enter the same data in all selected cells
28. Alt + Enter → Move to a new line within the same cell
29. Ctrl + D → Copy the content of the top cell to the selected cell
30. Ctrl + R → Copy the content of the left cell to the selected cell
31. Ctrl + Shift + L → Enable or disable filtering
32. Ctrl + Shift + "*" → Select the area containing data
33. Ctrl + T → Create Table
34. Ctrl + 1 → Open the Format Cells window
35. Ctrl + Shift + "$" → Format Currency
36. Ctrl + Shift + "%" → Percent Format
37. Ctrl + Shift + "#" → Date Format
38. Ctrl + Shift + "@" → Time Format
39. Ctrl + Shift + "!" → Format the number with commas
40. Ctrl + Shift + "&" → Add borders to selected cells
41. Ctrl + Shift + "_" → Remove Borders
---
Working with formulas and functions:
42. = → Start writing an equation
43. Alt + "=" → Automatically enter SUM function
44. F4: Hold cell reference in formula ($A$1)
45. Shift + F3 → Open Insert Function window
46. Ctrl + [ → Show all formulas in the sheet
47. **Ctrl + '** → Copy the formula from the top cell
48. Ctrl + Shift + Enter → Enter matrix equation
49. F9: Calculate all worksheets
50. Shift + F9 → Calculate active sheet only
---
Dealing with worksheets:
51. Ctrl + Page Up / Page Down → Move between worksheets
52. Shift + F11 → Insert New Sheet
53. Alt + H + O + R → Rename sheet
54. Ctrl + Shift + K → Duplicate current sheet
55. Alt + E + L → Delete current sheet
---
Handling search and replace:
56. Ctrl + F → Open search window
57. Ctrl + H → Open Find and Replace window
58. Shift + F4 → Find next item
59. Ctrl + Shift + F → Find text in all sheets
---
Working with windows and workbooks:
60. Ctrl + Tab → Switch between open Excel files
61. Ctrl + W → Close current file
62. Ctrl + Shift + W → Close all open files
63. Alt + Tab → Switch between open programs
---
Advanced and professional shortcuts:
64. Ctrl + Alt + V → Open Paste Special window
65. Alt + H + V + V → Paste values only
66. Alt + H + V + S → Paste formatting only
67. Alt + H + V + T → Paste text only
68. Alt + D + P → Open Pivot Table Wizard
69. Ctrl + Shift + "$" → Format currency to dollars
70. Ctrl + Alt + Shift + H → Open the multi-version history (in modern versions of Windows)
71. Ctrl + Shift + : → Enter current time
72. Ctrl + ; → Enter current date
---
Additional useful shortcuts:
73. Ctrl + E → Flash Fill (automatically insert repeating patterns)
74. Ctrl + Shift + "^" → Scientific number format
75. Ctrl + Shift + "+" → Insert new cells
76. Ctrl + Shift + "-" → Delete selected cells
77. Alt + M + U + D → Update all formulas in the workbook
78. Ctrl + Shift + K → Duplicate sheet
79. Alt + A + M → Remove duplicates
80. Alt + H + O + I → Automatically adjust column width
---
Excel shortcuts for Mac:
81. Cmd + Shift + K → Insert New Sheet
82. Cmd + T → Create spreadsheet
83. Cmd + Shift + Z → Undo
84. Cmd + Option + V → Open Paste Special window
85. Cmd + Option + R → Refresh Pivot Table