MS Excel Shortcut Key

MS Excel Shortcut Key

 

1. Ctrl+A - Select All
2. Ctrl+B - Bold
3. Ctrl+C - Copy
4. Ctrl+D - Fill Down
5. Ctrl+F - Find
6. Ctrl+G - Goto
7. Ctrl+H - Replace
8. Ctrl+I - Italic
9. Ctrl+K - Insert Hyperlink
10. Ctrl+N - New Workbook
11. Ctrl+O - Open
12. Ctrl+P - Print
13. Ctrl+R - Fill Right
14. Ctrl+S - Save
15. Ctrl+U - Underline
16. Ctrl+V - Paste
17. Ctrl W - Close
18. Ctrl+X - Cut
19. Ctrl+Y - Repeat
20. Ctrl+Z - Undo
21. F1 - Help
22. F2 - Edit
23. F3 - Paste Name
24. F4 - Repeat last action
25. F4 - While typing a formula, switch between absolute/relative refs
26. F5 - Goto
27. F6 - Next Pane
28. F7 - Spell check
29. F8 - Extend mode
30. F9 - Recalculate all workbooks
31. F10 - Activate Menubar
32. F11 - New Chart
33. F12 - Save As
34. Ctrl+: - Insert Current Time
35. Ctrl+; - Insert Current Date
36. Ctrl+" - Copy Value from Cell Above
37. Ctrl+’ - Copy Formula from Cell Above
38. Shift - Hold down shift for additional functions in Excel’s menu
39. Shift+F1 - What’s This?
40. Shift+F2 - Edit cell comment
41. Shift+F3 - Paste function into formula
42. Shift+F4 - Find Next
43. Shift+F5 - Find
44. Shift+F6 - Previous Pane
45. Shift+F8 - Add to selection
46. Shift+F9 - Calculate active worksheet
47. Shift+F10 - Display shortcut menu
48. Shift+F11 - New worksheet
49. Shift+F12 - Save
50. Ctrl+F3 - Define name
51. Ctrl+F4 - Close
52. Ctrl+F5 - XL, Restore window size
53. Ctrl+F6 - Next workbook window
54. Shift+Ctrl+F6 - Previous workbook window
55. Ctrl+F7 - Move window
56. Ctrl+F8 - Resize window
57. Ctrl+F9 - Minimize workbook
58. Ctrl+F10 - Maximize or restore window
59. Ctrl+F11 - Inset 4.0 Macro sheet
60. Ctrl+F1 - File Open
61. Alt+F1 - Insert Chart
62. Alt+F2 - Save As
63. Alt+F4 - Exit
64. Alt+F8 - Macro dialog box
65. Alt+F11 - Visual Basic Editor
66. Ctrl+Shift+F3 - Create name by using names of row and column labels
67. Ctrl+Shift+F6 - Previous Window
68. Ctrl+Shift+F12 - Print
69. Alt+Shift+F1 - New worksheet
70. Alt+Shift+F2 - Save
71. Alt+= - AutoSum
72. Ctrl+` - Toggle Value/Formula display
73. Ctrl+Shift+A - Insert argument names into formula
74. Alt+Down arrow - Display AutoComplete list
75. Alt+’ - Format Style dialog box
76. Ctrl+Shift+~ - General format
77. Ctrl+Shift+! - Comma format
78. Ctrl+Shift+@ - Time format
79. Ctrl+Shift+# - Date format
80. Ctrl+Shift+$ - Currency format
81. Ctrl+Shift+% - Percent format
82. Ctrl+Shift+^ - Exponential format
83. Ctrl+Shift+& - Place outline border around selected cells
84. Ctrl+Shift+_ - Remove outline border
85. Ctrl+Shift+* - Select current region
86. Ctrl++ - Insert
87. Ctrl+- - Delete
88. Ctrl+1 - Format cells dialog box
89. Ctrl+2 - Bold
90. Ctrl+3 - Italic
91. Ctrl+4 - Underline
92. Ctrl+5 - Strikethrough
93. Ctrl+6 - Show/Hide objects
94. Ctrl+7 - Show/Hide Standard toolbar
95. Ctrl+8 - Toggle Outline symbols
96. Ctrl+9 - Hide rows
97. Ctrl+0 - Hide columns
98. Ctrl+Shift+( - Unhide rows
99. Ctrl+Shift+) - Unhide columns
100. Alt or F10 - Activate the menu
101. Ctrl+Tab - In toolbar: next toolbar
102. Shift+Ctrl+Tab - In toolbar: previous toolbar
103. Ctrl+Tab - In a workbook: activate next workbook 
104. Shift+Ctrl+Tab - In a workbook: activate previous workbook
105. Tab - Next tool
106. Shift+Tab - Previous tool
107. Enter - Do the command
108. Shift+Ctrl+F - Font Drop Down List
109. Shift+Ctrl+F+F - Font tab of Format Cell Dialog box
110. Shift+Ctrl+P - Point size Drop Down List