Excel provides a wide range of keyboard shortcuts to help you work more efficiently and quickly. Here are 150 useful keyboard shortcuts for Excel for Windows:

Navigation and Selection Shortcuts

1. Ctrl + A: Selects all cells in the current worksheet.
2. Ctrl + Home: Moves to the beginning of the worksheet.
3. Ctrl + End: Moves to the last cell in the worksheet.
4. Ctrl + Arrow Key: Moves to the last filled cell in the direction of the arrow key.
5. Shift + Arrow Key: Extends the selection by one cell in the direction of the arrow key.
6. Ctrl + Shift + Arrow Key: Extends the selection to the last filled cell in the direction of the arrow key.
7. Ctrl + Shift + Home: Selects all cells from the current position to the beginning of the worksheet.
8. Ctrl + Shift + End: Selects all cells from the current position to the last cell in the worksheet.
9. F5: Opens the Go To dialog box.
10. Ctrl + G: Opens the Go To dialog box.
11. Ctrl + F2: Displays the Print Preview window.
12. Ctrl + Shift + F2: Prints the current worksheet.
13. Ctrl + F6: Switches to the next workbook window.
14. Ctrl + Shift + F6: Switches to the previous workbook window.
15. Ctrl + Page Up: Moves to the previous worksheet.
16. Ctrl + Page Down: Moves to the next worksheet.
17. Ctrl + Shift + Page Up: Selects the current and previous worksheets.
18. Ctrl + Shift + Page Down: Selects the current and next worksheets.
19. Ctrl + Tab: Switches to the next worksheet.
20. Ctrl + Shift + Tab: Switches to the previous worksheet.
21. F2: Edits the current cell.
22. Shift + F2: Adds a comment to the current cell.
23. Ctrl + D: Copies the value from the cell above to the current cell.
24. Ctrl + R: Copies the value from the cell to the left to the current cell.
25. Ctrl + Shift + &: Applies an outline border to the selected cells.
26. Ctrl + Shift + _: Removes a border from the selected cells.
27. Ctrl + Shift + +: Inserts cells, rows, or columns.
28. Ctrl + -: Deletes cells, rows, or columns.
29. Ctrl + Spacebar: Selects the current column.
30. Shift + Spacebar: Selects the current row.
31. Ctrl + Shift + Spacebar: Selects the entire worksheet.
32. F4: Repeats the last action.
33. F6: Switches between the worksheet, ribbon, task pane, and zoom controls.
34. F7: Opens the Spelling dialog box.
35. Shift + F10: Displays the right-click menu.

Editing Shortcuts

1. Ctrl + X: Cuts the selected cells
2. Ctrl + C: Copies the selected cells.
3. Ctrl + V: Pastes the copied cells.
4. Ctrl + Alt + V: Displays the Paste Special dialog box.
5. Ctrl + D: Fills the selected cells with the value from the cell above.
6. Ctrl + R: Fills the selected cells with the value from the cell to the left.
7. Ctrl + ;: Enters the current date in the selected cell.
8. Ctrl + Shift + ;: Enters the current time in the selected cell.
9. Ctrl + “: Copies the value from the cell above to the current cell.
10. Ctrl + “: Copies the formula from the cell above to the current cell.
11. Ctrl + Shift + “: Inserts the value from the cell above into the current cell.
12. Ctrl + Shift + ” +”: Inserts the formula from the cell above into the current cell.
13. Ctrl + Enter: Fills the selected cells with the value from the active cell.
14. Alt + Enter: Adds a line break to the current cell.
15. Ctrl + Shift + ~: Applies the General number format.
16. Ctrl + Shift + $: Applies the Currency number format.
17. Ctrl + Shift + %: Applies the Percentage number format.
18. Ctrl + Shift + #: Applies the Date number format.
19. Ctrl + Shift + ^: Applies the Scientific number format.
20. Ctrl + Shift + @: Applies the Time number format.
21. Ctrl + Shift + F: Opens the Format Cells dialog box.
22. Ctrl + 1: Opens the Format Cells dialog box.
23. Ctrl + E: Flash fills the selected cells.
24. Ctrl + Alt + F9: Calculates all worksheets in all open workbooks.
25. Ctrl + Alt + Shift + F9: Rebuilds the calculation chain in all open workbooks.
26. F9: Recalculates the active worksheet.
27. Shift + F9: Recalculates all worksheets in all open workbooks.
28. Ctrl + Shift + U: Toggles the formula bar on or off.
29. Ctrl + Shift + O: Displays the Outlining toolbar.
30. Ctrl + Shift + F10: Displays the shortcut menu for a selected item.
31. Ctrl + J: Opens the Fill dialog box.
32. Alt + =: Inserts a sum formula.
33. Ctrl + Shift + &: Applies a border to the selected cells.
34. Ctrl + Shift + _: Removes a border from the selected cells.
35. Ctrl + Shift + +: Inserts cells, rows, or columns.
36. Ctrl + -: Deletes cells, rows, or columns.
37. Ctrl + F3: Opens the Name Manager dialog box.
38. Ctrl + Shift + F3: Creates a name for the selected cells.
39. F3: Displays the Paste Name dialog box.
40. Ctrl + Shift + F3: Displays the Create Names dialog box.
41. Ctrl + Shift + F6: Hides the selected workbook window.
42. Ctrl + F7: Moves the current workbook window.
43. Ctrl + F8: Resizes the current workbook window.
44. Ctrl + F10: Maximizes or restores the current workbook window.
45. Alt + F4: Closes Excel.
46. Formula Shortcuts 81. F4: Repeats the last action or function.
47. Ctrl + A: Selects all cells in the formula.
48. Ctrl + C: Copies the formula.
49. Ctrl + V: Pastes the formula.
50. Ctrl + X: Cuts the formula.
51. Ctrl + Z: Undoes the last action.
52. Ctrl + Y: Redoes the last action.
53. Ctrl + Shift + Enter: Enters an array formula.
54. F2: Edits the formula.
55. F9: Calculates the formula.
56. Ctrl + Shift + A: Inserts the argument names in a function.
57. Ctrl + Shift + L: Displays the function arguments dialog box.
58. Shift + F3: Opens the Insert Function dialog box.
59. Ctrl + Shift + U: Toggles the formula bar on or off.
60. Ctrl + `: Toggles between displaying formulas and displaying values.
61. F7: Opens the Spelling dialog box.
62. Worksheet Shortcuts 97. Ctrl + Page Up: Moves to the previous worksheet.
63. Ctrl + Page Down: Moves to the next worksheet.
64. Ctrl + Shift + Page Up: Selects the current and previous worksheets.
65. Ctrl + Shift + Page Down: Selects the current and next worksheets.
66. Ctrl + Home: Moves to the beginning of the worksheet.
67. Ctrl + End: Moves to the last cell in the worksheet.
68. Ctrl + Shift + Home: Selects all cells from the current position to the beginning of the worksheet.
69. Ctrl + Shift + End: Selects all cells from the current position to the last cell in the worksheet.
70. Ctrl + Shift + F6: Switches to the previous workbook window.
71. Ctrl + Shift + F12: Opens the Save As dialog box.
72. F4: Repeats the last action.
73. F6: Switches between the worksheet, ribbon, task pane, and zoom controls.
74. F9: Calculates the active worksheet.
75. Shift + F9: Calculates all worksheets in all open workbooks.
76. Ctrl + Shift + U: Toggles the formula bar on or off.
77. Ctrl + Shift + O: Displays the Outlining toolbar.
78. Ctrl + Shift + F10: Displays the shortcut menu for a selected item.
79. Ctrl + J: Opens the Fill dialog box.
80. Alt + =: Inserts a sum formula.
81. Ctrl + Shift + &: Applies a border to the selected cells.
82. Ctrl + Shift + _: Removes a border from the selected cells.
83. Ctrl + Shift + +: Inserts cells, rows, or columns.
84. Ctrl + -: Deletes cells, rows, or columns.
85. Ctrl + F3: Opens the Name Manager dialog box.
86. Ctrl + Shift + F3: Creates a name for the selected cells.
87. F3: Displays the Paste Name dialog box.
88. Ctrl + Shift + F3: Displays the Create Names dialog box.
89. Ctrl + Shift + F6: Hides the selected workbook window.
90. Ctrl + F7: Moves the current workbook window.
91. Ctrl + F8: Resizes the current workbook window.
92. Ctrl + F10: Maximizes or restores the current workbook window.
93. Alt + F4: Closes Excel.

Miscellaneous Shortcuts

1. Alt + F: Displays the File tab.
2. Alt + H: Displays the Home tab.
3. Alt + N: Displays the Insert tab.
4. Alt + P: Displays the Page Layout tab.
5. Alt + M: Displays the Formulas tab.
6. Alt + A: Displays the Data tab.
7. Alt + R: Displays the Review tab.
8. Alt + W: Displays the View tab.
9. Alt + Q: Opens the Tell me box.
10. Ctrl + Tab: Switches to the next workbook.
11. Ctrl + Shift + Tab: Switches to the previous workbook.
12. Shift + F11: Inserts a new worksheet.
13. Alt + Shift + F1: Opens the Insert Function dialog box.
14. Alt + Shift + F2: Opens the Save As dialog box.
15. Ctrl + Shift + C: Copies the format of the selected cells.
16. Ctrl + Shift + V: Pastes the format of the copied cells.
17. Ctrl + Shift + W: Toggles between displaying multiple workbook windows and a single workbook window.
18. Ctrl + Shift + T: Inserts a new table.
19. Ctrl + Shift + F5: Opens the Go To dialog box.
20. Ctrl + Shift + F12: Prints the current worksheet.
21. Ctrl + Shift + F11: Creates a new chart sheet.

Any that are missing? Let us know!