Share this article:

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!