Top 100 Excel Shortcut Keys You Must Know (2025 Updated Guide)

 

✅ 🔹 Basic Excel Shortcuts

1. Ctrl + N – New Workbook

2. Ctrl + O – Open Workbook

3. Ctrl + S – Save Workbook

4. F12 – Save As

5. Ctrl + P – Print

6. Ctrl + C – Copy

7. Ctrl + X – Cut

8. Ctrl + V – Paste

9. Ctrl + Z – Undo

10. Ctrl + Y – Redo

---

✅ 🔹 Navigation Shortcuts

11. Arrow Keys – Move cells

12. Ctrl + Arrow Keys – Jump to data end

13. Ctrl + Home – Go to A1

14. Ctrl + End – Go to last used cell

15. Page Up / Page Down – Move screen

16. Alt + Page Up – Move left screen

17. Alt + Page Down – Move right screen

18. Tab – Move to next cell

19. Shift + Tab – Move to previous cell

20. Ctrl + G / F5 – Go to any cell

---

✅ 🔹 Row & Column Shortcuts

21. Ctrl + Space – Select column

22. Shift + Space – Select row

23. Ctrl + Shift + "+" – Insert row/column

24. Ctrl + "-" – Delete row/column

25. Ctrl + Shift + ( ) – Unhide rows

26. Ctrl + 0 – Hide column

27. Ctrl + 9 – Hide row

28. Ctrl + Shift + 0 – Unhide column

29. Ctrl + D – Fill down

30. Ctrl + R – Fill right

---

✅ 🔹 Formatting Shortcuts

31. Ctrl + B – Bold

32. Ctrl + I – Italic

33. Ctrl + U – Underline

34. Alt + H + H – Fill color

35. Alt + H + F + C – Font color

36. Ctrl + 1 – Format cells

37. Ctrl + Shift + $ – Currency format

38. Ctrl + Shift + % – Percentage format

39. Ctrl + Shift + # – Date format

40. Ctrl + Shift + @ – Time format

---

✅ 🔹 Selection Shortcuts

41. Ctrl + A – Select all

42. Ctrl + Shift + Arrow Keys – Select continuous data

43. Shift + Arrow Keys – Select cells

44. Ctrl + Shift + Space – Select entire worksheet

45. **Ctrl + Shift + * ** – Select data region

---

✅ 🔹 Editing Shortcuts

46. F2 – Edit active cell

47. Ctrl + Enter – Fill selected cells with same value

48. Shift + Enter – Move up after entry

49. Alt + Enter – New line inside cell

50. Ctrl + Shift + L – Add/Remove filters

---

✅ 🔹 Formula Shortcuts

51. Alt + = – AutoSum

52. Shift + F9 – Calculate active sheet

53. F4 – Absolute/relative reference ($A$1)

54. Ctrl + ` – Show formulas

55. Ctrl + Shift + U – Expand formula bar

56. Ctrl + Shift + Enter – Array formula (older Excel)

57. Ctrl + Shift + A – Insert function arguments

58. Shift + F3 – Insert function

59. Ctrl + Shift + K – Convert formula to text

60. Ctrl + Shift + J – List formulas

---

✅ 🔹 Workbook & Worksheet Shortcuts

61. Ctrl + Page Up – Previous sheet

62. Ctrl + Page Down – Next sheet

63. Shift + F11 – New sheet

64. Ctrl + Shift + F – Search in sheet

65. Alt + O + H + R – Rename sheet

66. Ctrl + F4 – Close workbook

67. Ctrl + W – Close window

68. Ctrl + Tab – Switch between files

69. Ctrl + K – Insert hyperlink

70. Ctrl + F2 – Print preview

---

✅ 🔹 Data & Table Shortcuts

71. Ctrl + T – Create table

72. Alt + A + M – Remove duplicates

73. Alt + A + E – Text to Columns

74. Ctrl + Q – Quick Analysis

75. Alt + A + S + S – Sort

76. Alt + A + F + S – Filter

77. Ctrl + Shift + U – Expand formula bar

78. Ctrl + Shift + P – Open PivotTable options

79. Alt + N + V – Insert PivotTable

80. Ctrl + Shift + L – Add filter

---

✅ 🔹 Special Excel Shortcuts

81. Ctrl + Shift + ; – Insert current time

82. Ctrl + ; – Insert current date

83. Ctrl + Shift + “ – Copy value from above

84. Ctrl + ‘ – Copy formula from above

85. Alt + F1 – Create chart

86. F11 – Create chart in new sheet

87. Ctrl + Shift + F3 – Create name from selection

88. Ctrl + Shift + O – Select cells with comments

89. Alt + F8 – Macros

90. Alt + F11 – Open VBA Editor

---

✅ 🔹 File & Security Shortcuts

91. Ctrl + F1 – Hide/Show ribbon

92. Ctrl + Shift + F – Font formatting

93. Ctrl + Shift + > – Increase font size

94. Ctrl + Shift + < – Decrease font size

95. Ctrl + F – Find

96. Ctrl + H – Replace

97. Ctrl + Shift + F12 – Direct print

98. Alt + F4 – Exit Excel

99. Ctrl + Shift + S – Save new copy

100. Alt + F + T – Excel options (settings)