Below is an extensive list of Excel keyboard shortcuts to help you work more efficiently. You can either scroll through the entire list or use the Index to jump directly to the section you need.
Shortcut | Description |
---|---|
1. Ctrl + Arrow keys | Move to the edge of data in the direction of the arrow (left, right, up, or down). |
2. Home | Move to the beginning of the current row. |
3. Ctrl + Home | Move to the first cell (A1) of the worksheet. |
4. Ctrl + End | Move to the last cell with data. |
5. Page Up | Move up one screen in the worksheet. |
6. Page Down | Move down one screen in the worksheet. |
7. Ctrl + Page Up | Move to the previous worksheet. |
8. Ctrl + Page Down | Move to the next worksheet. |
9. Alt + Tab | Switch between open applications. |
10. Ctrl + A | Select all cells in the worksheet. |
11. Shift + Spacebar | Select the entire row of the active cell. |
12. Ctrl + Spacebar | Select the entire column of the active cell. |
13. Ctrl + Shift + Arrow keys | Select all data in the direction of the arrow. |
14. Shift + Arrow keys | Extend the selection one cell at a time in the direction of the arrow. |
15. Ctrl + Shift + L | Toggle AutoFilter on or off for the selected range. |
16. Ctrl + Shift + “+” | Insert a new row or column. |
17. Ctrl + “-“ | Delete the selected row or column. |
18. Ctrl + Shift + 9 | Unhide rows. |
19. Ctrl + 9 | Hide selected rows. |
20. Ctrl + Shift + 0 | Unhide columns. |
21. Ctrl + 0 | Hide selected columns. |
22. Ctrl + C | Copy the selected data. |
23. Ctrl + X | Cut the selected data. |
24. Ctrl + V | Paste the copied or cut data. |
25. Ctrl + Z | Undo the last action. |
26. Ctrl + Y | Redo the last undone action. |
27. Delete | Clear the contents of the selected cell(s). |
28. Ctrl + D | Fill down (copy the content from the cell above). |
29. Ctrl + R | Fill right (copy the content from the left cell). |
30. Alt + E, S, V | Paste values only (useful when you want to paste data without formulas or formatting). |
31. F2 | Edit the active cell. |
32. Ctrl + B | Toggle bold formatting. |
33. Ctrl + I | Toggle italic formatting. |
34. Ctrl + U | Toggle underline formatting. |
35. Ctrl + 1 | Open the Format Cells dialog box. |
36. Ctrl + Shift + $ | Apply the currency format to the selected cells. |
37. Ctrl + Shift + % | Apply the percentage format to the selected cells. |
38. Ctrl + Shift + # | Apply the date format to the selected cells. |
39. Ctrl + Shift + ! | Apply number format with two decimal places. |
40. Alt + E, S, F | Paste special and open the Format Cells dialog box. |
41. Ctrl + Shift + & | Add borders to the selected cells. |
42. Ctrl + Shift + _ | Remove borders from the selected cells. |
43. Alt + Equals (=) | Automatically insert a SUM formula for the selected range. |
44. F4 | Repeat the last action (or toggle between absolute and relative references in a formula). |
45. Ctrl + ` (grave accent) | Toggle between displaying formulas and the result of the formulas. |
46. Ctrl + Shift + Enter | Enter an array formula. |
47. Ctrl + Shift + U | Expand or collapse the formula bar. |
48. Ctrl + Shift + F3 | Open the Name Manager dialog box. |
49. Ctrl + F3 | Open the Name Manager dialog box to define or manage named ranges. |
50. Ctrl + F | Open the Find dialog box to search for specific content. |
51. Ctrl + H | Open the Find and Replace dialog box to search and replace content. |
52. Ctrl + P | Open the Print dialog box. |
53. Ctrl + K | Insert a hyperlink. |
54. Ctrl + S | Save the current workbook. |
55. Alt + F4 | Close the Excel application. |
56. Ctrl + T | Create a table from the selected range. |
57. Ctrl + N | Open a new workbook. |
58. Ctrl + O | Open an existing workbook. |
59. Ctrl + W | Close the current workbook. |
60. Ctrl + Q | Show the Quick Analysis tool (when a range is selected). |
61. Ctrl + F2 | Open Print Preview mode. |
62. Ctrl + F7 | Move the current workbook window. |
63. Ctrl + F8 | Resize the current workbook window. |
64. Ctrl + F9 | Minimize the workbook window. |
65. Ctrl + F10 | Maximize the workbook window. |
66. Alt + H | Go to the Home tab on the ribbon. |
67. Alt + E | Go to the Edit menu. |
68. Alt + I | Go to the Insert menu. |
69. Alt + W | Go to the View menu. |
70. Alt + M | Go to the Formulas tab. |
71. Ctrl + Shift + F | Open the Format Cells dialog box directly to the Font tab. |
72. Ctrl + Shift + P | Open the Format Cells dialog box directly to the Protection tab. |
73. Alt + F1 | Create a chart of the selected data in the current worksheet. |
74. F3 | Paste a defined name into a formula. |
75. Ctrl + Shift + L | Turn on or off AutoFilter. |
76. Ctrl + Shift + T | Create a new worksheet. |
77. Ctrl + Alt + V | Open the Paste Special dialog box. |
78. Ctrl + Shift + O | Select all cells with comments. |
79. Ctrl + Shift + K | Insert a hyperlink. |
80. Ctrl + Shift + Z | Undo the last Zoom action. |
81. Alt + F8 | Open the Macro dialog box. |
82. F11 | Create a chart based on selected data in a new worksheet. |
83. Ctrl + Shift + 5 | Apply percentage formatting. |
84. Ctrl + F11 | Insert a new macro sheet. |
85. Alt + A | Go to the Data tab on the ribbon. |
86. Alt + N | Go to the Insert tab on the ribbon. |
87. Ctrl + Shift + “+” | Insert a new row or column. |
88. Ctrl + Shift + “-“ | Delete the selected row or column. |
89. Ctrl + Shift + 1 | Apply number formatting with two decimal places. |
90. Ctrl + Shift + E | Expand the Excel options in the ribbon. |
91. Ctrl + Alt + Shift + F9 | Recalculate all open workbooks. |
92. Ctrl + Alt + D | Open the Data tab of the ribbon. |
93. Ctrl + Alt + M | Open the Macro dialog box. |
94. Alt + Shift + F1 | Insert a new worksheet. |
95. Alt + N + V | Insert a PivotTable. |
96. Ctrl + Shift + 7 | Add or remove borders from selected cells. |
97. Ctrl + Shift + F | Open the Format Cells dialog box for font settings. |
98. Ctrl | Fill the selected cells with the content from the cell above. |
99. Ctrl + Shift + E | Apply “E” style formatting (currency, percentage, etc.). |
100. Ctrl + Shift + H | Hide the selected columns or rows. |