XL n CAD

Excel isn’t just a tool – it's a way of Life!

Keyboard Shortcuts in Excel

There are 200+ Keyboard Shortcuts in Excel and they are listed below. Learning all these shortcuts will not be easy but I encourage you to practice as much as you can. You can even challenge yourself by disabling the mouse for some time and see how well you can do. Good Luck!

1. Close Excel – ALT F4

2. Activate Access Keys – ALT

3. Open options – ALT F T

4. Create Embedded Chart – ALT F1

5. Display Auto-Complete list – ALT ↓

6. Display modify Cell Style Dialog – ALT ‘

7. Display Control Menu – ALT SPACE

8. Create Slicer Filter – ALT C

9. Insert a copy into a worksheet – ALT Drag

10. Move one page to Right – ALT PAGE DOWN

11. Move one page to Left – ALT PAGE UP

12. Extend selection to next page on right side – ALT SHIFT PAGE DOWN

13. Extend selection to next page on left side – ALT SHIFT PAGE UP

14. Select all visible cells – ALT ;

15. Line Break/Start a new line in the cell – ALT ENTER

16. Align Center – ALT H A C

17. Align Right – ALT H A R

18. Align Left – ALT H A L

19. Indent – ALT H 6

20. Remove Indent – ALT H 5

21. Increase Font size one step – ALT H F G

22. Decrease Font size one step – ALT H F K

23. Auto sum selected cells – ALT =

24. Group Columns or Rows – ALT SHIFT →

25. Ungroup Columns or Rows – ALT SHIFT ←

26. Open Group Dialog Box – ALT SHIFT →

27. Open Ungroup Dialog Box – ALT SHIFT ←

28. Open Pivot table wizard – ALT D P

29. Open Macros dialog – ALT F8

30. Open VBA Editor – ALT F11

31. Span to Grid (with Objects) – ALT

32. Display modify Cell Style Dialog – ALT ‘

33. Display Control Menu – ALT SPACE

34. Zoom Dialog – ALT W Q

35. Record Macro – ALT W M R

36. Display convert text to column dialog – ALT A E

37. Delete active sheet – ALT H D S

38. Paste as values – ALT H V V

39. Advanced Filter – ALT A Q

40. Sort Smallest to Largest – ALT H S S

41. Sort Largest to Smallest – ALT H S O

42. Displays Sort Dialog Box – ALT H S U

43. Display move or copy dialog – ALT E M

44. Excel Name Box – ALT F3

45. Create a New workbook – CTRL N

46. Open an existing workbook – CTRL O

47. Save workbook – CTRL S

48. Print file – CTRL P

49. Open Print preview window – CTRL F2

50. Close current workbook – CTRL F4

51. Expand/Collapse Ribbon – CTRL F1

52. Select All – CTRL A

53. Undo last action – CTRL Z

54. Redo last action – CTRL Y

55. Copy selected cells – CTRL C

56. Cut Selected cells – CTRL X

57. Paste content from clipboard – CTRL V

58. Display Paste Special dialog – CTRL ALT V

59. Find and Replace – CTRL F

60. Replace – CTRL H

61. Toggle Auto Filter – CTRL SHIFT L

62. Select entire column/columns – CTRL SPACE

63. Find Previous Match – CTRL SHIFT F4

64. Create an Excel Table – CTRL T

65. Toggle Table Total Row – CTRL SHIFT T

66. Copy – CTRL Drag

67. Insert a Copy – CTRL SHIFT Drag

68. Create a copy of the worksheet – CTRL Drag Sheet Tab

69. Move to Top edge of Data region – CTRL ↑

70. Move to Bottom edge of Data region – CTRL ↓

71. Move to right edge of Data region – CTRL →

72. Move to left edge of Data region – CTRL ←

73. Move to First cell of a worksheet – CTRL HOME

74. Move to last cell used in a worksheet – CTRL END

75. Go back to Hyperlink – CTRL G ENTER

76. Add cell/cells/data ranges to selection – CTRL Click (left mouse button)

77. Select a Entire worksheet – CTRL A A

78. Select entire column/columns – CTRL SPACE

79. Toggle through non adjacent Selection (towards Left) – CTRL ALT ←

80. Toggle through non adjacent Selection (towards Right) – CTRL ALT →

81. Show activecell on the worksheet – CTRL BACKSPACE

82. Toggle through edges of selection (Clockwise direction) – CTRL .

83. Extend selection to the top cell – CTRL SHIFT ↑

84. Extend selection to the bottom cell – CTRL SHIFT ↓

85. Extend selection to the last cell on left – CTRL SHIFT ←

86. Extend selection to the last cell on right – CTRL SHIFT →

87. Extend selection to first cell in the worksheet – CTRL SHIFT HOME

88. Extend selection to last used cell in the worksheet – CTRL SHIFT END

89. Display Go To dialog – CTRL G

90. Select cells with comments – CTRL SHIFT O

91. Select current region around Active Cell – CTRL SHIFT *

92. Select current Array – CTRL \

93. Select Row differences – CTRL /

94. Select Column differences – CTRL SHIFT |

95. Select direct precedents – CTRL [

96. Select all precedents – CTRL SHIFT {

97. Select direct dependents – CTRL ]

98. Select all dependents – CTRL SHIFT }

99. Move one word left – CTRL ←

100. Move one word right – CTRL →

101. Select one word left – CTRL SHIFT ←

102. Select one word right – CTRL SHIFT →

103. Delete up to End of the line – CTRL

104. Confirm Entry and Stay in the cell – CTRL ENTER

105. Enter the same data into Multiple cells – CTRL ENTER

106. Enter current date into a cell – CTRL ;

107. Enter current time into a cell – CTRL SHIFT :

108. Fill down from the top cell in the selection – CTRL D

109. Fill right from the cell on leftmost cell in the selection – CTRL R

110. Copy formula/content from the above cell – CTRL ‘

111. Copy value from the above cell – CTRL SHIFT “

112. Add Hyperlink – CTRL K

113. Flash Fill – CTRL E

114. Display Format Cells dialog – CTRL 1

115. Display Format Cells dialog with Font tab selected – CTRL SHIFT 1

116. Apply or Remove Bold formatting – CTRL B

117. Apply or Remove Italic formatting – CTRL I

118. Apply or Remove Undeline formatting – CTRL U

119. Apply or Remove Strikethrough formatting – CTRL 5

120. Apply General Format – CTRL SHIFT ~

121. Apply Currency Format – CTRL SHIFT $

122. Apply Percentage Format – CTRL SHIFT %

123. Apply Scientific Format – CTRL SHIFT ^

124. Apply Date Format – CTRL SHIFT #

125. Apply Time Format – CTRL SHIFT @

126. Apply Number Format – CTRL SHIFT !

127. Add Border Outline – CTRL SHIFT &

128. Remove Border lines – CTRL SHIFT _

129. Show formulas – CTRL `

130. Insert function arguments – CTRL SHIFT A

131. Enter Array Formula – CTRL SHIFT ENTER

132. Force calculate all worksheets – CTRL ALT F9

133. Expand/Collapse Formula bar – CTRL SHIFT U

134. Display function arguments dialog box – CTRL A

135. Define name – CTRL F3

136. Define name using Row and Column Labels – CTRL SHIFT F3

137. Display Insert dialog – CTRL SHIFT +

138. Display Delete dialog – CTRL –

139. Hide Columns – CTRL 0

140. Hide Rows – CTRL 9

141. Unhide Columns – CTRL SHIFT 0

142. Unhide Rows – CTRL SHIFT 9

143. Show or hide outline symbols – CTRL 8

144. Zoom in – CTRL ALT +

145. Zoom out – CTRL ALT –

146. Full screen – CTRL SHIFT F1

147. Go to Next worksheet – CTRL PAGE DOWN

148. Go to Previous worksheet – CTRL PAGE UP

149. Go to Next workbook – CTRL TAB

150. Go to previous workbook – CTRL SHIFT TAB

151. Minimize Current workbook window – CTRL F9

152. Maximize Current workbook window – CTRL F10

153. Move to next Tab – CTRL TAB

154. Move to previous Tab – CTRL SHIFT TAB

155. Duplicate Object (with objects) – CTRL D

156. Hide and Show Objects – CTRL 6

157. Previous window – CTRL SHIFT F6

158. Select entire Row/Rows – SHIFT SPACE

159. Swap or Insert Cells/Rows/Columns – SHIFT Drag

160. Toggle add to Selection Mode – SHIFT F8

161. Select Active Cell only – SHIFT BACKSPACE

162. Move active cell up in selection – SHIFT ENTER

163. Move active cell left in selection – SHIFT TAB

164. Extend Selection by one cell/row up – SHIFT ↑

165. Extend Selection by one cell/row down – SHIFT ↓

166. Extend Selection by one cell/row right – SHIFT →

167. Extend Selection by one cell/row left – SHIFT ←

168. Extend selection up to the first cell of the row – SHIFT HOME

169. Add comment – SHIFT F2

170. Select one character right – SHIFT →

171. Select one character left – SHIFT ←

172. Select up to Beginning of a cell – SHIFT HOME

173. Select up to End of a cell – SHIFT END

174. Move up one cell in selection – SHIFT ENTER

175. Move left one cell in selection – SHIFT TAB

176. Open insert function dialog – SHIFT F3

177. Calculate active worksheet – SHIFT F9

178. Insert new worksheet – SHIFT F11

179. Move to previous pane (Split pane) – SHIFT F6

180. Select adjacent worksheets – SHIFT Click (left mouse button)

181. Find Next Match (after closing Find Dialog) – SHIFT F4

182. Move to next control (any Dialog box) – SHIFT TAB

183. Open Thesaurus Dialog box) – SHIFT F7

184. Display Right click menu – SHIFT F10

185. Delete comment – SHIFT F10 M

186. Save as Dialog – F12

187. Help – F1

188. Repeat last action – F4

189. Create a chart in a new worksheet – F11

190. Enable or Disable End mode – END

191. Move one cell down (in selection) – ENTER

192. Move one cell right (in selection) – TAB

193. Toggle through Extend selection mode – F8

194. Edit Active cell – F2

195. Cancel Entry – ESCAPE

196. Confirm Entry and move to righ – TAB

197. Toggle Absolute, Mixed and Relative References – F4

198. Calculate worksheets/Evaluate a formula – F9

199. Paste name into a Formula – F3

200. Accept function with AutoComplete – TAB

201. Move to Next Pane – F6

202. Open Spelling Dialog – F7

203. Go To Dialog – F5

Videos Explaining Keyboard Shortcuts in Excel

21 Keyboard Shortcuts for Beginners

https://youtu.be/kOmPcBY6ap8

25 Advanced Excel Shortcuts

https://youtu.be/mRpKwsnydM4