200+ Excel Shortcut Keys SeekheIndia

1. Ctrl + N – New workbook
2. Ctrl + O – Open workbook
3. Ctrl + S – Save workbook
4. Ctrl + P – Print workbook
5. Ctrl + C – Copy selected cells
6. Ctrl + X – Cut selected cells
7. Ctrl + V – Paste copied/cut cells
8. Ctrl + Z – Undo last action
9. Ctrl + Y – Redo last undone action
10. Ctrl + A – Select all cells in the worksheet
11. Ctrl + F – Find
12. Ctrl + H – Replace
13. Ctrl + B – Bold
14. Ctrl + I – Italic
15. Ctrl + U – Underline
16. Ctrl + 1 – Format cells dialog
17. Ctrl + Shift + L – Toggle filters on/off
18. Ctrl + Shift + $ – Apply currency format
19. Ctrl + Shift + % – Apply percentage format
20. Ctrl + Shift + # – Apply date format (day, month, year)
21. Ctrl + Arrow Key – Navigate to the edge of data region
22. Ctrl + Shift + Arrow Key – Select to the edge of data region
23. Ctrl + Page Up – Move to the previous worksheet
24. Ctrl + Page Down – Move to the next worksheet
25. Ctrl + Tab – Switch between open workbooks
26. Ctrl + Space – Select entire column
27. Shift + Space – Select entire row
28. Alt + E, S, V – Paste special
29. Alt + E, S, T – Paste transpose
30. Alt + H, O, I – AutoFit column width
31. Alt + H, O, A – AutoFit row height
32. F2 – Edit active cell
33. F4 – Repeat last action
34. F7 – Spell check
35. F11 – Create chart with selected data
36. Ctrl + K – Insert hyperlink
37. Ctrl + ` (grave accent) – Toggle formula view
38. Alt + Enter – Start a new line within a cell
39. Ctrl + D – Fill down
40. Ctrl + R – Fill right
41. Ctrl + Shift + “+” – Insert new row or column
42. Ctrl + “-“ – Delete row or column
43. Ctrl + Shift + 7 – Add border
44. Ctrl + Shift + – – Remove border
45. Ctrl + Shift + “+” – Insert new cells
46. Alt + E, D, F – Remove duplicates
47. Ctrl + F3 – Open Name Manager
48. Ctrl + Shift + 9 – Unhide rows
49. Ctrl + 9 – Hide rows
50. Ctrl + Shift + 0 – Unhide columns
51. Ctrl + 0 – Hide columns
52. Alt + F8 – Open Macro dialog
53. Ctrl + Shift + K – Add or remove hyperlink
54. Ctrl + Shift + 2 – Apply time format
55. Ctrl + Shift + 5 – Apply percentage format
56. Ctrl + ` (grave accent) – Toggle between displaying formulas and values
57. Ctrl + Alt + V – Open Paste Special dialog
58. Ctrl + Shift + U – Expand or collapse formula bar
59. Ctrl + Shift + F – Open Format Cells dialog
60. Ctrl + Shift + C – Copy format
61. Ctrl + Shift + V – Paste format
62. Ctrl + Shift + E – Remove format
63. Ctrl + Alt + L – Create a table
64. Alt + N – Insert tab
65. Alt + P – Page Layout tab
66. Alt + G – Go To tab
67. Alt + W – View tab
68. Ctrl + Alt + F1 – Open Excel Help
69. Ctrl + Shift + 4 – Apply currency format
70. Ctrl + Shift + 6 – Apply accounting format
71. Ctrl + Shift + 8 – Display or hide outline symbols
72. Ctrl + Shift + 3 – Apply date format
73. Ctrl + Shift + 1 – Apply number format
74. Ctrl + Shift + 2 – Apply time format
75. Alt + F1 – Create chart in the current worksheet
76. Ctrl + F3 – Open Name Manager
77. Ctrl + Shift + H – Highlight cells
78. Ctrl + Shift + P – Open the Format Cells dialog box
79. Ctrl + Shift + O – Select cells with comments
80. Ctrl + Q – Quick analysis
81. Ctrl + Shift + T – Apply date format
82. Alt + D, F, F – Filter data
83. Ctrl + Alt + F – Open Filter dialog
84. Ctrl + Shift + L – Toggle AutoFilter
85. Ctrl + Shift + J – Open the Insert Function dialog
86. Ctrl + Shift + K – Add hyperlink
87. Alt + H, M, C – Center align text
88. Alt + H, M, L – Left align text
89. Alt + H, M, R – Right align text
90. Ctrl + Shift + K – Add or remove hyperlink
91. Ctrl + Shift + S – Open the Styles dialog box
92. Ctrl + F5 – Restore window size
93. Ctrl + Shift + L – Toggle filters
94. Ctrl + Shift + M – Minimize or maximize the window
95. Alt + F, T – Open the Options dialog box
96. Alt + E, T, I – AutoFit column width
97. Alt + E, T, R – AutoFit row height
98. Alt + H, W – Wrap text
99. Ctrl + Shift + P – Format cells as percentage
100. Ctrl + Shift + A – Insert argument names

101. Ctrl + Shift + D – Fill down to the last cell
102. Ctrl + Shift + E – Expand formula bar
103. Ctrl + Shift + K – Add or remove hyperlink
104. Ctrl + Shift + 4 – Apply currency format
105. Ctrl + Shift + 2 – Apply time format
106. Ctrl + Shift + 5 – Apply percentage format
107. Ctrl + Shift + 8 – Display or hide outline symbols
108. Ctrl + Shift + 1 – Apply number format
109. Ctrl + Shift + 3 – Apply date format
110. Alt + F1 – Create chart in the current worksheet
111. Ctrl + F3 – Open Name Manager
112. Ctrl + Shift + H – Highlight cells
113. Ctrl + Shift + P – Open the Format Cells dialog box
114. Ctrl + Shift + O – Select cells with comments
115. Ctrl + Q – Quick analysis
116. Ctrl + Shift + T – Apply date format
117. Alt + D, F, F – Filter data
118. Ctrl + Alt + F – Open Filter dialog
119. Ctrl + Shift + L – Toggle AutoFilter
120. Ctrl + Shift + J – Open the Insert Function dialog
121. Ctrl + Shift + K – Add hyperlink
122. Alt + H, M, C – Center align text
123. Alt + H, M, L – Left align text
124. Alt + H, M, R – Right align text
125. Ctrl + Shift + K – Add or remove hyperlink
126. Ctrl + Shift + S – Open the Styles dialog box
127. Ctrl + F5 – Restore window size
128. Ctrl + Shift + L – Toggle filters
129. Ctrl + Shift + M – Minimize or maximize the window
130. Alt + F, T – Open the Options dialog box
131. Alt + E, T, I – AutoFit column width
132. Alt + E, T, R – AutoFit row height
133. Alt + H, W – Wrap text
134. Ctrl + Shift + P – Format cells as percentage
135. Ctrl + Shift + A – Insert argument names
136. Ctrl + Alt + V – Open Paste Special dialog
137. Ctrl + Shift + U – Expand or collapse formula bar
138. Ctrl + Shift + F – Open Format Cells dialog
139. Ctrl + Shift + C – Copy format
140. Ctrl + Shift + V – Paste format
141. Ctrl + Shift + E – Remove format
142. Ctrl + Alt + L – Create a table
143. Alt + N – Insert tab
144. Alt + P – Page Layout tab
145. Alt + G – Go To tab
146. Alt + W – View tab
147. Ctrl + Alt + F1 – Open Excel Help
148. Ctrl + Shift + 4 – Apply currency format
149. Ctrl + Shift + 6 – Apply accounting format
150. Ctrl + Shift + 8 – Display or hide outline symbols
151. Ctrl + Shift + 3 – Apply date format
152. Ctrl + Shift + 1 – Apply number format
153. Ctrl + Shift + 2 – Apply time format
154. Alt + F1 – Create chart in the current worksheet
155. Ctrl + F3 – Open Name Manager
156. Ctrl + Shift + H – Highlight cells
157. Ctrl + Shift + P – Open the Format Cells dialog box
158. Ctrl + Shift + O – Select cells with comments
159. Ctrl + Q – Quick analysis
160. Ctrl + Shift + T – Apply date format
161. Alt + D, F, F – Filter data
162. Ctrl + Alt + F – Open Filter dialog
163. Ctrl + Shift + L – Toggle AutoFilter
164. Ctrl + Shift + J – Open the Insert Function dialog
165. Ctrl + Shift + K – Add hyperlink
166. Alt + H, M, C – Center align text
167. Alt + H, M, L – Left align text
168. Alt + H, M, R – Right align text
169. Ctrl + Shift + K – Add or remove hyperlink
170. Ctrl + Shift + S – Open the Styles dialog box
171. Ctrl + F5 – Restore window size
172. Ctrl + Shift + L – Toggle filters
173. Ctrl + Shift + M – Minimize or maximize the window
174. Alt + F, T – Open the Options dialog box
175. Alt + E, T, I – AutoFit column width
176. Alt + E, T, R – AutoFit row height
177. Alt + H, W – Wrap text
178. Ctrl + Shift + P – Format cells as percentage
179. Ctrl + Shift + A – Insert argument names
180. Ctrl + Alt + V – Open Paste Special dialog
181. Ctrl + Shift + U – Expand or collapse formula bar
182. Ctrl + Shift + F – Open Format Cells dialog
183. Ctrl + Shift + C – Copy format
184. Ctrl + Shift + V – Paste format
185. Ctrl + Shift + E – Remove format
186. Ctrl + Alt + L – Create a table
187. Alt + N – Insert tab
188. Alt + P – Page Layout tab
189. Alt + G – Go To tab
190. Alt + W – View tab
191. Ctrl + Alt + F1 – Open Excel Help
192. Ctrl + Shift + 4 – Apply currency format
193. Ctrl + Shift + 6 – Apply accounting format
194. Ctrl + Shift + 8 – Display or hide outline symbols
195. Ctrl + Shift + 3 – Apply date format
196. Ctrl + Shift + 1 – Apply number format
197. Ctrl + Shift + 2 – Apply time format
198. Alt + F1 – Create chart in the current worksheet
199. Ctrl + F3 – Open Name Manager
200. Ctrl + Shift + H – Highlight cells

End of Book