Master the Latest Microsoft Excel Shortcut Keys for Enhanced Productivity

Microsoft Excel is a powerful tool for organizing, analyzing, and presenting data. One way to increase your productivity and efficiency when working with Excel is to use keyboard shortcuts. These shortcuts can help you perform common tasks more quickly and easily, saving you time and reducing the risk of errors. In this article, we will provide you with a comprehensive list of 199 latest Microsoft Excel shortcut keys.

1. Ctrl + A – Selects all cells in the current worksheet.
2. Ctrl + B – Applies or removes bold formatting.
3. Ctrl + C – Copies the selected cells.
4. Ctrl + D – Fills the selected cell with the contents of the cell above.
5. Ctrl + E – Flash Fill, automatically fills in values based on pattern.
6. Ctrl + F – Opens the Find and Replace dialog box.
7. Ctrl + G – Opens the Go To dialog box.
8. Ctrl + H – Opens the Find and Replace dialog box.
9. Ctrl + I – Applies or removes italic formatting.
10. Ctrl + J – Copies the formula from the cell above into the selected cell.
11. Ctrl + K – Inserts a hyperlink.
12. Ctrl + L – Displays the Create Table dialog box with the Table tab selected.
13. Ctrl + M – Adds a new row to the current worksheet.
14. Ctrl + N – Creates a new workbook.
15. Ctrl + O – Opens an existing workbook.
16. Ctrl + P – Opens the Print dialog box.
17. Ctrl + Q – Displays the Quick Analysis options for the selected cells.
18. Ctrl + R – Fills the selected cell with the contents of the cell to the left.
19. Ctrl + S – Saves the current workbook.
20. Ctrl + T – Displays the Create Table dialog box with the Range tab selected.
21. Ctrl + U – Applies or removes underline formatting.
22. Ctrl + V – Pastes the copied cells.
23. Ctrl + W – Closes the current workbook.
24. Ctrl + X – Cuts the selected cells.
25. Ctrl + Y – Redo the last action.
26. Ctrl + Z – Undo the last action.
27. Ctrl + 1 – Opens the Format Cells dialog box.
28. Ctrl + 2 – Applies or removes bold formatting.
29. Ctrl + 3 – Applies or removes italic formatting.
30. Ctrl + 4 – Applies or removes underline formatting.
31. Ctrl + 5 – Applies or removes strikethrough formatting.
32. Ctrl + 6 – Hides or shows objects in the current worksheet.
33. Ctrl + 7 – Hides or shows the ribbon.
34. Ctrl + 8 – Toggles the display of the outline symbols.
35. Ctrl + 9 – Hides the selected rows.
36. Ctrl + 0 – Hides the selected columns.
37. Ctrl + – – Deletes the selected cells.
38. Ctrl + Shift + = – Inserts a new column to the left of the selected column.
39. Ctrl + Shift + ; – Enters the current date.
40. Ctrl + Shift + : – Enters the current time.
41. Ctrl + Shift + C – Copies the selected cells with their formatting.
42. Ctrl + Shift + D – Opens the Duplicate Values dialog box.
43. Ctrl + Shift + F – Opens the Format Cells dialog box with the Font tab selected.
44. Ctrl + Shift + G – Displays the Go To Special dialog box.
45. Ctrl + Shift + H – Replaces the selected cells with a blank value.
46. Ctrl + Shift + L – Applies or removes the filter.
47. Ctrl + Shift + M – Adds or removes a comment.
48. Ctrl + Shift + N – Inserts a new worksheet.
49. Ctrl + Shift + O – Selects all cells with comments in the current worksheet.
50. Ctrl + Shift + P – Opens the Format Cells dialog box with the Font tab selected.
51. Ctrl + Shift + Q – Toggles the display of the formula bar.
52. Ctrl + Shift + R – Fills the selected cell with the contents of the cell to the right.
53. Ctrl + Shift + S – Opens the Save As dialog box.
54. Ctrl + Shift + T – Inserts a new row above the selected row.
55. Ctrl + Shift + U – Converts the selected text to uppercase.
56. Ctrl + Shift + V – Pastes the copied cells with their formatting.
57. Ctrl + Shift + W – Closes all open workbooks.
58. Ctrl + Shift + X – Inserts a new worksheet.
59. Ctrl + Shift + Y – Repeats the last action.
60. Ctrl + Shift + Z – Redo the last action.
61. Ctrl + Shift + ~ – Applies the General number format.
62. Ctrl + Alt + 1 – Applies the Number format with two decimal places.
63. Ctrl + Alt + 2 – Applies the Time format with the hour and minute.
64. Ctrl + Alt + 3 – Applies the Date format with the day, month, and year.
65. Ctrl + Alt + 4 – Applies the Currency format with two decimal places.
66. Ctrl + Alt + 5 – Applies the Percentage format with no decimal places.
67. Ctrl + Alt + 6 – Applies the Scientific format with two decimal places.
68. Ctrl + Alt + 7 – Applies the Accounting format with two decimal places and a currency symbol.
69. Ctrl + Alt + 8 – Applies the Fraction format with two decimal places.
70. Ctrl + Alt + 9 – Hides the selected rows.
71. Ctrl + Alt + 0 – Hides the selected columns.
72. Ctrl + Alt + – – Inserts a new row above the selected row.
73. Ctrl + Alt + = – Inserts a new column to the left of the selected column.
74. Ctrl + Alt + A – Inserts the argument names and parentheses when editing a formula.
75. Ctrl + Alt + B – Inserts a new blank worksheet.
76. Ctrl + Alt + C – Copies the value from the cell above.
77. Ctrl + Alt + D – Opens the Data Validation dialog box.
78. Ctrl + Alt + E – Opens the Edit Formatting Rule dialog box.
79. Ctrl + Alt + F – Displays the Format Cells dialog box.
80. Ctrl + Alt + Shift + F11 – Opens the Visual Basic Editor.
81. Ctrl + Alt + Shift + F12 – Saves the current workbook.
82. Ctrl + Alt + Shift + F2 – Saves a copy of the current workbook.
83. Ctrl + Alt + Shift + F3 – Opens the Define Name dialog box.
84. Ctrl + Alt + Shift + F4 – Closes the Excel program.
85. Ctrl + Alt + Shift + F5 – Opens the Go To dialog box.
86. Ctrl + Alt + Shift + F6 – Switches to the next workbook.
87. Ctrl + Alt + Shift + F9 – Calculates all formulas in the current workbook.
88. Ctrl + Alt + Shift + F10 – Opens the Options dialog box.
89. Ctrl + Alt + Shift + F11 – Opens the Macro dialog box.
90. Ctrl + Alt + Shift + F12 – Opens the Save As dialog box.
91. Ctrl + Alt + Shift + F1 – Opens the Excel Help window.
92. Ctrl + Alt + Shift + F2 – Saves a copy of
93. Ctrl + Alt + Shift + F3 – Opens the Create Names dialog box.
94. Ctrl + Alt + Shift + F4 – Opens the AutoFilter dialog box.
95. Ctrl + Alt + Shift + F5 – Opens the Find and Replace dialog box with the Go To tab selected.
96. Ctrl + Alt + Shift + F6 – Switches to the previous workbook.
97. Ctrl + Alt + Shift + F7 – Opens the Thesaurus.
98. Ctrl + Alt + Shift + F8 – Adds a Watch to a formula.
99. Ctrl + Alt + Shift + F9 – Rechecks dependent formulas, and then calculates all formulas in the current worksheet.
100. Ctrl + Alt + Shift + F10 – Opens the Options dialog box.
101. Ctrl + Alt + Shift + F11 – Opens the Macro dialog box.
102. Ctrl + Alt + Shift + F12 – Opens the Save As dialog box.
103. Ctrl + Alt + Shift + Home – Selects all cells from the current cell to the beginning of the worksheet.
104. Ctrl + Alt + Shift + End – Selects all cells from the current cell to the last cell of the worksheet.
105. Ctrl + Spacebar – Selects the entire column.
106. Shift + Spacebar – Selects the entire row.
107. Ctrl + Shift + Spacebar – Selects the entire worksheet.
108. Alt + ; – Selects only the visible cells in the current selection.
109. Ctrl + ‘ – Copies the formula from the cell above into the selected cell.
110. Ctrl + Shift + ~ – Applies the General number format with two decimal places.
111. Ctrl + Shift + $ – Applies the Currency format with two decimal places.
112. Ctrl + Shift + % – Applies the Percentage format with no decimal places.
113. Ctrl + Shift + ^ – Applies the Exponential number format with two decimal places.
114. Ctrl + Shift + # – Applies the Date format with the day, month, and year.
115. Ctrl + Shift + @ – Applies the Time format with the hour and minute.
116. Ctrl + Shift + & – Applies the Border format to the selected cells.
117. Ctrl + Shift + _ – Removes the border from the selected cells.
118. Ctrl + Alt + 5 – Applies the Strikethrough format.
119. Ctrl + Alt + – – Opens the Delete dialog box.
120. Ctrl + Alt + + – Opens the Insert dialog box.
121. Ctrl + Alt + T – Displays the Create Table dialog box.
122. Ctrl + Alt + P – Opens the Page Setup dialog box.
123. Ctrl + Alt + H – Displays the Replace tab in the Find and Replace dialog box.
124. Ctrl + Alt + Shift + F – Opens the Format Cells dialog box with the Font tab selected.
125. Ctrl + Alt + Shift + P – Displays the Format tab in the PivotTable Field dialog box.
126. Ctrl + Alt + Shift + S – Displays the Options tab in the Solver Parameters dialog box.
127. Ctrl + Alt + Shift + T – Displays the Insert Timeline dialog box.
128. Ctrl + Alt + Shift + V – Displays the Paste Special dialog box.
129. Ctrl + Alt + Shift + W – Displays the Design tab in the PivotTable Tools Ribbon.
130. Ctrl + Alt + Shift + X – Displays the Delete tab in the PivotTable Field dialog box.
131. Ctrl + Alt + Shift + Y – Displays the Create Relationship dialog box.
132. Ctrl + Alt + Shift + Z – Displays the Analyze tab in the PivotTable Tools Ribbon.
133. Ctrl + Alt + 1 – Applies the Number format with no decimal places.
134. Ctrl + Alt + 2 – Applies the Time format with the hour, minute, and second.
135. Ctrl + Alt + 3 – Applies the Date format with the month and year.
136. Ctrl + Alt + 4 – Applies the Currency format with no decimal places.
137. Ctrl + Alt + 5 – Applies the Percentage format with two decimal places.
138. Ctrl + Alt + 6 – Applies the Scientific format with no decimal places.
139. Ctrl + Alt + 7 – Applies the Accounting format with no decimal places and a currency symbol.
140. Ctrl + Alt + 8 – Applies the Fraction format with no decimal places.
141. Ctrl + Alt + 9 – Unhides any hidden rows in the selected range.
142. Ctrl + Alt + 0 – Unhides any hidden columns in the selected range.
143. Ctrl + Alt + Shift + F6 – Opens the Previous Window menu.
144. Ctrl + Alt + Shift + F7 – Opens the Dictionary.
145. Ctrl + Alt + Shift + F8 – Displays the Add Watch dialog box.
146. Ctrl + Alt + Shift + F9 – Calculates the active worksheet.
147. Ctrl + Alt + Shift + F10 – Opens the Excel Options dialog box.
148. Ctrl + Alt + Shift + F11 – Displays the VBA Code window.
149. Ctrl + Alt + Shift + F12 – Displays the Save As dialog box.
150. Ctrl + Alt + Shift + Arrow keys – Selects the entire region containing the active cell.
151. Ctrl + Shift + F3 – Opens the Create Names dialog box.
152. Ctrl + Shift + F6 – Switches to the previous workbook window.
153. Ctrl + Shift + F9 – Calculates the active worksheet.
154. Ctrl + Shift + F10 – Displays the shortcut menu.
155. Ctrl + Shift + F11 – Inserts a new worksheet.
156. Ctrl + Shift + F12 – Displays the Open dialog box.
157. Ctrl + Shift + Arrow keys – Selects the current region around the active cell.
158. Ctrl + Shift + End – Selects all cells from the active cell to the last cell of the worksheet.
159. Ctrl + Shift + Home – Selects all cells from the active cell to the first cell of the worksheet.
160. Ctrl + Shift + Page Down – Selects the current and next sheet in a workbook.
161. Ctrl + Shift + Page Up – Selects the current and previous sheet in a workbook.
162. Ctrl + Shift + Tab – Switches to the previous workbook window.
163. Ctrl + Shift + \ – Selects cells that contain formulas that directly reference the active cell.
164. Ctrl + Shift + 7 – Applies the Outline border to the selected cells.
165. Ctrl + Shift + 8 – Toggles the display of the outline symbols.
166. Ctrl + Shift + = – Inserts a new row below the selected row.
167. Ctrl + Shift + + – Inserts a new column to the right of the selected column.
168. Ctrl + Shift + ~ – Applies the General number format.
169. Ctrl + Shift + $ – Applies the Currency format with two decimal places.
170. Ctrl + Shift + % – Applies the Percentage format with no decimal places.
171. Ctrl + Shift + ^ – Applies the Exponential number format with two decimal places.
172. Ctrl + Shift + # – Applies the Date format with the day, month, and year.
173. Ctrl + Shift + @ – Applies the Time format with the hour and minute.
174. Ctrl + Shift + & – Applies the Border format to the selected cells.
175. Ctrl + Shift + _ – Removes the border from the selected cells.
176. Ctrl + Shift + * – Selects the current region around the active cell.
177. Ctrl + Alt + V – Opens the Paste Special dialog box.
178. Ctrl + Alt + D – Inserts the current date in the active cell.
179. Ctrl + Alt + T – Inserts the current time in the active cell.
180. Ctrl + Alt + K – Opens the Insert Hyperlink dialog box.
181. Ctrl + Alt + N – Inserts a new worksheet.
182. Ctrl + Alt + V – Displays the Paste Special dialog box.
183. Ctrl + Alt + F1 – Displays the Excel Help task pane.
184. Ctrl + Alt + F2 – Displays the Save As dialog box.
185. Ctrl + Alt + F3 – Displays the Name Manager.
186. Ctrl + Alt + F4 – Closes the current workbook.
187. Ctrl + Alt + F5 – Displays the Go To dialog box.
188. Ctrl + Alt + F6 – Switches to the next workbook window.
189. Ctrl + Alt + F7 – Opens the Spelling dialog box.
190. Ctrl + Alt + F8 – Displays the Macro dialog box.
191. Ctrl + Alt + F9 – Calculates all worksheets in all open workbooks.
192. Ctrl + Alt + F10 – Maximizes or restores the active workbook window.
193. Ctrl + Alt + F11 – Displays the Visual Basic Editor.
194. Ctrl + Alt + F12 – Displays the Open dialog box.
195. Ctrl + Alt + Arrow keys – Moves to the next section of a workbook.
196. Ctrl + Alt + 1 – Applies the Number format with two decimal places.
197. Ctrl + Alt + 2 – Applies the Time format with the hour, minute, and AM/PM.
198. Ctrl + Alt + 3 – Applies the Date format with the day, month, and year.
199. Ctrl + Alt + 4 – Applies the Currency format with two decimal places.

These shortcut keys can save a lot of time when working with Microsoft Excel, especially when dealing with large and complex workbooks. It is essential to familiarize yourself with these shortcut keys to increase productivity and efficiency when using Excel.