100 Common Excel Shortcuts
Increase your Excel skills by using shortcuts, saving time, effort and impressing others with your knowledge.
1. Ctrl + N: Create a new workbook.
2. Ctrl + O: Open a saved workbook.
3. Ctrl + S: Save a workbook.
4. Ctrl + A: Select all the contents in a workbook.
5. Ctrl + B: Turn highlighted cells bold.
6. Ctrl + C: Copy cells that are highlighted.
7. Ctrl + D: Fill the selected cell with the content of the cell right above.
8. Ctrl + F: Search for anything in a workbook.
9. Ctrl + G: Jump to a certain area with a single command.
10. Ctrl + H: Find and replace cell contents.
11. Ctrl + I: Italicize cell contents.
12. Ctrl + K: Insert a hyperlink in a cell.
13. Ctrl + L: Open the create table dialog box.
14. Ctrl + P: Print a workbook.
15. Ctrl + R: Fill the selected cell with the content of the cell on the left.
16. Ctrl + U: Underline highlighted cells.
17. Ctrl + V: Paste anything that was copied.
18. Ctrl + W: Close your current workbook.
19. Ctrl + Z: Undo the last action.
20. Ctrl + 1: Format the cell contents.
21. Ctrl + 5: Put a strikethrough in a cell.
22. Ctrl + 8: Show the outline symbols.
23. Ctrl + 9: Hide a row.
24. Ctrl + 0: Hide a column.
25. Ctrl + Shift + :: Enter the current time in a cell.
26. Ctrl + ;: Enter the current date in a cell.
27. Ctrl + `: Change the view from displaying cell values to formulas.
28. Ctrl + ‘: Copy the formula from the cell above.
29. Ctrl + -: Delete columns or rows.
30. Ctrl + Shift + =: Insert columns and rows.
31. Ctrl + Shift + ~: Switch between displaying Excel formulas or their values in cell.
32. Ctrl + Shift + @: Apply time formatting.
33. Ctrl + Shift + !: Apply comma formatting.
34. Ctrl + Shift + $: Apply currency formatting.
35. Ctrl + Shift + #: Apply date formatting.
36. Ctrl + Shift + %: Apply percentage formatting.
37. Ctrl + Shift + &: Place borders around the selected cells.
38. Ctrl + Shift + _: Remove a border.
39. Ctrl + -: Delete a selected row or column.
40. Ctrl + Spacebar: Select an entire column.
41. Ctrl + Shift + Spacebar: Select an entire workbook.
42. Ctrl + Home: Redirect to cell A1.
43. Ctrl + Shift + Tab: Switch to the previous workbook.
44. Ctrl + Shift + F: Open the fonts menu under format cells.
45. Ctrl + Shift + O: Select the cells containing comments.
46. Ctrl + Drag: Drag and copy a cell or to a duplicate worksheet.
47. Ctrl + Shift + Drag: Drag and insert copy.
48. Ctrl + Up arrow: Go to the top most cell in a current column.
49. Ctrl + Down arrow: Jump to the last cell in a current column.
50. Ctrl + Right arrow: Go to the last cell in a selected row.
51. Ctrl + Left arrow: Jump back to the first cell in a selected row.
52. Ctrl + End: Go to the last cell in a workbook.
53. Alt + Page down: Move the screen towards the right.
54. Alt + Page Up: Move the screen towards the left.
55. Ctrl + F2: Open the print preview window.
56. Ctrl + F1: Expand or collapse the ribbon.
57. Alt: Open the access keys.
58. Tab: Move to the next cell.
59. Alt + F + T: Open the options.
60. Alt + Down arrow: Activate filters for cells.
61. F2: Edit a cell.
62. F3: Paste a cell name if the cells have been named.
63. Shift + F2: Add or edit a cell comment.
64. Alt + H + H: Select a fill color.
65. Alt + H + B: Add a border.
66. Ctrl + 9: Hide the selected rows.
67. Ctrl + 0: Hide the selected columns.
68. Esc: Cancel an entry.
69. Enter: Complete the entry in a cell and move to the next one.
70. Shift + Right arrow: Extend the cell selection to the right.
71. Shift + Left arrow: Extend the cell selection to the left.
72. Shift + Space: Select the entire row.
73. Page up/ down: Move the screen up or down.
74. Alt + H: Go to the Home tab in Ribbon.
75. Alt + N: Go to the Insert tab in Ribbon.
76. Alt + P: Go to the Page Layout tab in Ribbon.
77. Alt + M: Go to the Formulas tab in Ribbon.
78. Alt + A: Go to the Data tab in Ribbon.
79. Alt + R: Go to the Review tab in Ribbon.
80. Alt + W: Go to the View tab in Ribbon.
81. Alt + Y: Open the Help tab in Ribbon.
82. Alt + Q: Quickly jump to search.
83. Alt + Enter: Start a new line in a current cell.
84. Shift + F3: Open the Insert function dialog box.
85. F9: Calculate workbooks.
86. Shift + F9: Calculate an active workbook.
87. Ctrl + Alt + F9: Force calculate all workbooks.
88. Ctrl + F3: Open the name manager.
89. Ctrl + Shift + F3: Create names from values in rows and columns.
90. Ctrl + Alt + +: Zoom in inside a workbook.
91. Ctrl + Alt +: Zoom out inside a workbook.
92. Alt + 1: Turn on Auto save.
93. Alt + 2: Save a workbook.
94. Alt + F + E: Export your workbook.
95. Alt + F + Z: Share your workbook.
96. Alt + F + C: Close and save your workbook.
97. Alt or F11: Turn key tips on or off.
98. Alt + Y + W: Know what’s new in Microsoft Excel.
99. F1: Open Microsoft Excel help.
100. Ctrl + F4: Close Microsoft Excel.
