Excel is a powerful tool, and with that power comes a lot of shortcuts. In this article, we'll go over the top 100 Excel shortcuts that you need to know in order to work more efficiently in Excel.
1. Ctrl + A: Selects the entire worksheet.
2. Ctrl + B: Applies or removes bold formatting.
3. Ctrl + C: Copies the selected cells.
4. Ctrl + D: Fills the selected cells down with the contents of the cell above.
5. Ctrl + F: Opens the Find and Replace dialog box.
6. Ctrl + G: Opens the Go To dialog box.
7. Ctrl + H: Opens the Replace dialog box.
8. Ctrl + I: Applies or removes italic formatting.
9. Ctrl + K: Inserts a hyperlink.
10. Ctrl + N: Creates a new workbook.
11. Ctrl + O: Opens an existing workbook.
12. Ctrl + P: Opens the Print dialog box.
13. Ctrl + R: Fills the selected cells to the right with the contents of the cell to the left.
14. Ctrl + S: Saves the active workbook.
15. Ctrl + U: Applies or removes underline formatting.
16. Ctrl + V: Pastes the contents of the clipboard into the selected cells.
17. Ctrl + W: Closes the active workbook.
18. Ctrl + X: Cuts the selected cells.
19. Ctrl + Y: Repeats the last command or action.
20. Ctrl + Z: Undoes the last command or action.
21. Ctrl + Shift + A: Inserts the sum of the selected cells.
22. Ctrl + Shift + B: Applies or removes bold formatting to the selected cells.
23. Ctrl + Shift + C: Copies the selected cells.
24. Ctrl + Shift + D: Fills the selected cells down with the contents of the cell above.
25. Ctrl + Shift + F: Opens the Find and Replace dialog box.
26. Ctrl + Shift + G: Opens the Go To dialog box.
27. Ctrl + Shift + H: Opens the Replace dialog box.
28. Ctrl + Shift + I: Applies or removes italic formatting to the selected cells.
29. Ctrl + Shift + K: Inserts a hyperlink.
30. Ctrl + Shift + N: Creates a new workbook.
31. Ctrl + Shift + O: Opens an existing workbook.
32. Ctrl + Shift + P: Opens the Print dialog box.
33. Ctrl + Shift + R: Fills the selected cells to the right with the contents of the cell to the left.
34. Ctrl + Shift + S: Saves the active workbook.
35. Ctrl + Shift + U: Applies or removes underline formatting to the selected cells.
36. Ctrl + Shift + V: Pastes the contents of the clipboard into the selected cells.
37. Ctrl + Shift + W: Closes the active workbook.
38. Ctrl + Shift + X: Cuts the selected cells.
39. Ctrl + Shift + Y: Repeats the last command or action.
40. Ctrl + Shift + Z: Undoes the last command or action.
41. Ctrl + Alt + A: Inserts the sum of the selected cells.
42. Ctrl + Alt + B: Applies or removes bold formatting to the selected cells.
43. Ctrl + Alt + C: Copies the selected cells.
44. Ctrl + Alt + D: Fills the selected cells down with the contents of the cell above.
45. Ctrl + Alt + F: Opens the Find and Replace dialog box.
46. Ctrl + Alt + G: Opens the Go To dialog box.
47. Ctrl + Alt + H: Opens the Replace dialog box.
48. Ctrl + Alt + I: Applies or removes italic formatting to the selected cells.
49. Ctrl + Alt + K: Inserts a hyperlink.
50. Ctrl + Alt + N: Creates a new workbook.
51. Ctrl + Alt + O: Opens an existing workbook.
52. Ctrl + Alt + P: Opens the Print dialog box.
53. Ctrl + Alt + R: Fills the selected cells to the right with the contents of the cell to the left.
54. Ctrl + Alt + S: Saves the active workbook.
55. Ctrl + Alt + U: Applies or removes underline formatting to the selected cells.
56. Ctrl + Alt + V: Pastes the contents of the clipboard into the selected cells.
57. Ctrl + Alt + W: Closes the active workbook.
58. Ctrl + Alt + X: Cuts the selected cells.
59. Ctrl + Alt + Y: Repeats the last command or action.
60. Ctrl + Alt + Z: Undoes the last command or action.
61. Ctrl + F1: Hides or unhides the Ribbon.
62. Ctrl + F2: Prints the active worksheet.
63. Ctrl + F3: Opens the Name Manager.
64. Ctrl + F4: Closes the active workbook.
65. Ctrl + F5: Refreshes the active worksheet.
66. Ctrl + F6: Switches to the next workbook.
67. Ctrl + F7: Performs a move or resize operation on the active workbook.
68. Ctrl + F8: Performs a size operation on the active workbook.
69. Ctrl + F9: Minimizes the active workbook.
70. Ctrl + F10: Maximizes the active workbook.
71. Ctrl + F11: Inserts a new worksheet.
72. Ctrl + F12: Opens the Open dialog box.
73. Ctrl + Shift + F1: Hides or unhides the Ribbon.
74. Ctrl + Shift + F2: Prints the active worksheet.
75. Ctrl + Shift + F3: Opens the Name Manager.
76. Ctrl + Shift + F4: Closes the active workbook.
77. Ctrl + Shift + F5: Refreshes the active worksheet.
78. Ctrl + Shift + F6: Switches to the next workbook.
79.