Microsoft Excel 100 Keyboard Shortcuts

Microsoft Excel 100 Shortcuts

1. Alt + 1: To turn on Autosave.
2. Alt + 2: To save a workbook.
3. Alt + A: To go to the Data tab in Ribbon.
4. Alt + Down arrow: To activate filters for cells.
5. Alt + Enter: To start a new line in a current cell.
6. Alt + F + C: To close and save your workbook.
7. Alt + F + E: To export your workbook.
8. Alt + F + T: To open the options.
9. Alt + F + Z: To share your workbook.
10. Alt + H + B: To add a border.
11. Alt + H + H: To select a fill colour.
12. Alt + H: To go to the Home tab in Ribbon.
13. Alt + M: To go to the Formulas tab in Ribbon.
14. Alt + N: To go to the Insert tab in Ribbon.
15. Alt + P: To go to the Page Layout tab in Ribbon.
16. Alt + Page down: To move the screen towards the right.
17. Alt + Page Up: To move the screen towards the left.
18. Alt + Q: To quickly jump to search.
19. Alt + R: To go to the Review tab in Ribbon.
20. Alt + W: To go to the View tab in Ribbon.
21. Alt + Y + W: To know what’s new in Microsoft Excel.
22. Alt + Y: To open the Help tab in Ribbon.
23. Alt or F11: To turn key tips on or off.
24. Alt: To open the access keys.
25. Ctrl + -: To delete a selected row or column.
26. Ctrl + -: To delete columns or rows.
27. Ctrl + ;: To enter the current date in a cell.
28. Ctrl + `: To change the view from displaying cell values to formulas.
29. Ctrl + ‘: To copy the formula from the cell above.
30. Ctrl + 0: To hide a column.
31. Ctrl + 0: To hide the selected columns.
32. Ctrl + 1: To format the cell contents.
33. Ctrl + 5: To put a strikethrough in a cell.
34. Ctrl + 8: To show the outline symbols.
35. Ctrl + 9: To hide a row.
36. Ctrl + 9: To hide the selected rows.
37. Ctrl + A: To select all the contents in a workbook.
38. Ctrl + Alt + +: To zoom in inside a workbook.
39. Ctrl + Alt + F9: To force calculate all workbooks.
40. Ctrl + Alt +: To zoom out inside a workbook.
41. Ctrl + B: To turn highlighted cells bold.
42. Ctrl + C: To copy cells that are highlighted.
43. Ctrl + D: To fill the selected cell with the content of the cell right above.
44. Ctrl + Down arrow: To jump to the last cell in a current column.
45. Ctrl + Drag: To drag and copy a cell or to a duplicate worksheet.
46. Ctrl + End: To go to the last cell in a workbook.
47. Ctrl + F: To search for anything in a workbook.
48. Ctrl + F1: To expand or collapse the ribbon.
49. Ctrl + F2: To open the print preview window.
50. Ctrl + F3: To open the name manager.
51. Ctrl + F4: To close Microsoft Excel.
52. Ctrl + G: To jump to a certain area with a single command.
53. Ctrl + H: To find and replace cell contents.
54. Ctrl + Home: To redirect to cell A1.
55. Ctrl + I: To italicise cell contents.
56. Ctrl + K: To insert a hyperlink in a cell.
57. Ctrl + L: To open the create table dialog box.
58. Ctrl + Left arrow: To jump back to the first cell in a selected row.
59. Ctrl + N: To create a new workbook.
60. Ctrl + O: To open a saved workbook.
61. Ctrl + P: To print a workbook.
62. Ctrl + R: To fill the selected cell with the content of the cell on the left.
63. Ctrl + Right arrow: To go to the last cell in a selected row.
64. Ctrl + S: To save a workbook.
65. Ctrl + Shift + !: To apply comma formatting.
66. Ctrl + Shift + #: To apply date formatting.
67. Ctrl + Shift + $: To apply currency formatting.
68. Ctrl + Shift + %: To apply percentage formatting.
69. Ctrl + Shift + &: To place borders around the selected cells.
70. Ctrl + Shift + :: To enter the current time in a cell.
71. Ctrl + Shift + @: To apply time formatting.
72. Ctrl + Shift + _: To remove a border.
73. Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell.
74. Ctrl + Shift + =: To insert columns and rows.
75. Ctrl + Shift + Drag: To drag and insert copy.
76. Ctrl + Shift + F: To open the fonts menu under format cells.
77. Ctrl + Shift + F3: To create names from values in rows and columns.
78. Ctrl + Shift + O: To select the cells containing comments.
79. Ctrl + Shift + Spacebar: To select an entire workbook.
80. Ctrl + Shift + Tab: To switch to the previous workbook.
81. Ctrl + Spacebar: To select an entire column.
82. Ctrl + U: To underline highlighted cells.
83. Ctrl + Up arrow: To go to the top most cell in a current column.
84. Ctrl + V: To paste anything that was copied.
85. Ctrl + W: To close your current workbook.
86. Ctrl + Z: To undo the last action.
87. Enter: To complete the entry in a cell and move to the next one.
88. Esc: To cancel an entry.
89. F1: To open Microsoft Excel help.
90. F2: To edit a cell.
91. F3: To paste a cell name if the cells have been named.
92. F9: To calculate workbooks.
93. Page up/ down: To move the screen up or down.
94. Shift + F2: To add or edit a cell comment.
95. Shift + F3: To open the Insert function dialog box.
96. Shift + F9: To calculate an active workbook.
97. Shift + Left arrow: To extend the cell selection to the left.
98. Shift + Right arrow: To extend the cell selection to the right.
99. Shift + Space: To select the entire row.
100. Tab: Move to the next cell.