MS Excel Shortcut Keys | A to Z MS Excel Shortcut Keys

List of Top MS Excel Shortcut Keys or a to z MS Excel Shortcut Keys:

1. Alt + F + E: To export your own workbook.
2. Ctrl + Shift + Tab: To go to the previous workbook.
3. Ctrl + Shift + F: To open fonts menu under format cells. (Main shortcut keys of ms excel)
4. Ctrl + Shift + O: To select cells containing comments.
5. Ctrl + Up arrow: To go to topmost cell in a current column.
6. Ctrl + End: To go to last cell in a workbook. (Main shortcut keys of ms excel)
7. Alt + Page down: To move screen towards the right.
8. Alt + Page Up: To move the screen towards the left.
9. Alt + F + Z: To share your workbook.
10. Alt + F + C: To close & save your workbook. (Very Important MS Excel Shortcut Keys)
11. Ctrl + Drag: To drag a& copy a cell or to a duplicate worksheet.
12. Ctrl + Shift + Drag: To drag and insert copy.
13. F1: To open Microsoft Excel help. (Function keys in excel)
14. Ctrl + F2: To open print preview window. (Use of function keys in excel)
15. Ctrl + F1: To expand or collapse ribbon. (Use of function keys in excel)
16. F2: For edit a cell. (Function keys in ms excel)
17. F3: To paste a cell name if the cells have been named. (Function keys in excel)
18. Ctrl + F3: For open the name manager. (Use of function keys in excel)
19. Ctrl + F4: To close Microsoft Excel. (Use of function keys in excel)
20. Ctrl + Shift + F3: To create names from values in rows and columns.
21. Shift + F2: To add or edit a cell comment. (Shortcut function keys in excel)
22. Alt or F11: To turnkey tips on or off. (Use of function keys in excel)
23. Shift + F3: To open the Insert function dialog box. (Function keys in excel)
24. F5: Displays to Go to dialog box. (Function keys in ms excel)
25. Ctrl+F5: Restores window size of selected workbook window.
26. F6: Switches between worksheet, task pane, ribbon & Zoom controls. (Function keys in excel)
27. Shift+F6: Switches between worksheet, task pane, Zoom controls & ribbon.
28. Ctrl+F6: Switches to next workbook window when more than one workbook window is open.
29. F7: Open Spelling dialog box to check spelling in active worksheet or selected range. (Function keys in excel)
30. Ctrl+F7: Performs Move command on workbook window when it not maximized. Use arrow keys to move window, & when finished press Enter, or Esc for cancel.
31. F8: Turns extend mode on or off.  (Function keys in excel)
32. Shift+F8: Enables you to add a nonadjacent cell or range to selection of cells by using arrow keys.
33. Ctrl+F8: Performs Size command when a workbook is not maximized.
34. Alt+F8: Displays Macro dialog box to create, run, edit, or delete a macro.
35. F9: For calculate workbooks. (Function keys in excel)
36. Shift + F9: For calculate an active workbook.
37. Ctrl + Alt + F9: For force calculate all workbooks.
38. F10: Turns key tips on or off. (Function keys in excel)
39. Shift+F10: Displays shortcut menu for a selected item.
40. Alt+Shift+F10: Displays menu or message for an Error Checking button.
41. Ctrl+F10: Maximizes or restores selected workbook window.
42. F11: Creates a chart of the data in current range in a separate Chart sheet. (Function keys in excel)
43. Shift+F11: inserts a new worksheet.
44. Alt+F11: Opens the Microsoft Visual Basic for Applications Editor, in this create a macro by using visual basic for applications
45. F12: Displays the Save As dialog box. (Function keys in excel)
46. Ctrl + Down arrow: To jump to last cell in a current column.
47. Ctrl + Right arrow: To go to last cell in a selected row.
48. Ctrl + Left arrow: To jump back to first cell in a selected row.
49. Alt + Y + W: To know what’s new in Microsoft Excel.
50. Ctrl + Shift + %: To apply percentage formatting.
51. Ctrl + Shift + &: To place borders around selected cells.
52. Ctrl + Shift + _: To remove a border.
53. Ctrl + –: To delete a selected row or column.
54. Ctrl + Spacebar: To select an entire column.
55. Tab: Move to next cell. (Also, Important shortcut keys of ms excel)
56. Alt + F + T: To open options.
57. Alt + Down arrow: To activate filters for cells.
58. Ctrl + Shift + Spacebar: To select an entire workbook.
59. Ctrl + Alt + +: To zoom in inside a workbook.
60. Ctrl + Alt +: To zoom out inside a workbook.
61. Alt + 1: To turn on Autosave.
62. Alt: For Open the access keys.
63. Alt + 2: For save a workbook.
64. Alt + N: To go to the Insert tab in Ribbon.
65. Alt + P: To go to the Page Layout tab in Ribbon.
66. Alt + M: To go to the Formulas tab in Ribbon. (shortcut excel formulas)
67. Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell. (shortcut excel formulas)
68. Ctrl + Shift + @: To apply time formatting.
69. Ctrl + Shift + !: To apply comma formatting. (Main shortcut keys of ms excel)
70. Ctrl + Shift + $: To apply currency formatting.
71. Ctrl + Shift + #: For apply date formatting.
72. Alt + A: To go to the Data tab in Ribbon.
73. Alt + R: To go to the Review tab in Ribbon.
74. Alt + W: To go to the View tab in Ribbon.
75. Alt + Y: For open the Help tab in Ribbon.
76. Alt + Q: To quickly jump to search.
77. Alt + Enter: For start a new line in a current cell.
78. Alt + Down arrow: To activate filters for cells.
79. Ctrl + 9: To hide the selected rows. (Also, Important MS Excel Shortcut Keys)
80. Ctrl + 0: To hide the selected columns. (Also, Important MS Excel Shortcut Keys)
81. Esc: To cancel an entry.
82. Enter: To complete the entry in a cell and move to the next one.
83. Shift + Right arrow: To extend the cell selection to the right.
84. Shift + Left arrow: To extend the cell selection to the left.
85. Shift + Space: For select the entire row.
86. Alt + H + H: For select a fill colour. (Also, Important shortcut keys of ms excel)
87. Alt + H + B: To add a border.
88. Page up/ down: To move the screen up or down.
89. Alt + H: For go to the Home tab in Ribbon. (Also, Important shortcut keys of ms excel)
90. Ctrl + 8: To show the outline symbols.
91. Ctrl + 9: For hide a row.
92. Ctrl + 0: To hide a column.
93. Ctrl + Shift + :: To enter the current time in a cell.
94. Ctrl + ;: To enter the current date in a cell.
95. Ctrl + `: For change the view from displaying cell values to formulas. (shortcut excel formulas)
96. Ctrl + ‘: To copy the formula from the cell above. (shortcut excel formulas)
97. Ctrl + –: To delete columns or rows.
98. Ctrl + Shift + =: To insert columns and rows.
99. Ctrl + N: For create a new workbook.
100. Ctrl + O: To open a saved workbook.
101. Ctrl + S: To save a workbook.
102. Ctrl + A: For select all the contents in a workbook.
103. Ctrl + B: To turn highlighted cells bold.
104. + C: To copy cells that are highlighted.
105. Ctrl + D: To fill the selected cell with the content of the cell right above.
106. Ctrl + F: To search for anything in a workbook.
107. Ctrl + G: To jump to a certain area with a single command.
108. Ctrl + H: To find and replace cell contents.
109. Ctrl + U: To underline highlighted cells.
110. Ctrl + V: To paste anything that was copied.
111. Ctrl + W: To close your current workbook.
112. Ctrl + Z: To undo the last action.
113. Ctrl + 1: To format the cell contents.
114. Ctrl + 5: To put a strikethrough in a cell.
115. Ctrl + I: To italicise cell contents.
116. Ctrl + K: To insert a hyperlink in a cell.
117. Ctrl + L: To open the create table dialog box.
118. Ctrl + P: To print a workbook.
119. Ctrl + R: To fill the selected cell with the content of the cell on the left.

How to enable function keys in excel or how to activate function keys in excel?

• Check keyboard for “F-Lock” or “Function Lock” key.
• Press “F-Lock” key & then try using a function key 

Ms excel shortcut keys pdf:

You can download ms excel shortcut keys pdf when your internet not working or you cann’t find ms excel shortcut keys online.

Click below link

Download ms excel shortcut keys pdf