Excel shortcuts

The Top 100 Excel Shortcuts You Need to Know

Excel is a powerful tool, and with that power comes a lot of shortcuts. In this article, we'll go over the top 100 Excel shortcuts that you need to know in order to work more efficiently in Excel.

1. Ctrl + A: Selects the entire worksheet.

2. Ctrl + B: Applies or removes bold formatting.

3. Ctrl + C: Copies the selected cells.

4. Ctrl + D: Fills the selected cells down with the contents of the cell above.

5. Ctrl + F: Opens the Find and Replace dialog box.

6. Ctrl + G: Opens the Go To dialog box.

7. Ctrl + H: Opens the Replace dialog box.

8. Ctrl + I: Applies or removes italic formatting.

9. Ctrl + K: Inserts a hyperlink.

10. Ctrl + N: Creates a new workbook.

11. Ctrl + O: Opens an existing workbook.

12. Ctrl + P: Opens the Print dialog box.

13. Ctrl + R: Fills the selected cells to the right with the contents of the cell to the left.

14. Ctrl + S: Saves the active workbook.

15. Ctrl + U: Applies or removes underline formatting.

16. Ctrl + V: Pastes the contents of the clipboard into the selected cells.

17. Ctrl + W: Closes the active workbook.

18. Ctrl + X: Cuts the selected cells.

19. Ctrl + Y: Repeats the last command or action.

20. Ctrl + Z: Undoes the last command or action.

21. Ctrl + Shift + A: Inserts the sum of the selected cells.

22. Ctrl + Shift + B: Applies or removes bold formatting to the selected cells.

23. Ctrl + Shift + C: Copies the selected cells.

24. Ctrl + Shift + D: Fills the selected cells down with the contents of the cell above.

25. Ctrl + Shift + F: Opens the Find and Replace dialog box.

26. Ctrl + Shift + G: Opens the Go To dialog box.

27. Ctrl + Shift + H: Opens the Replace dialog box.

28. Ctrl + Shift + I: Applies or removes italic formatting to the selected cells.

29. Ctrl + Shift + K: Inserts a hyperlink.

30. Ctrl + Shift + N: Creates a new workbook.

31. Ctrl + Shift + O: Opens an existing workbook.

32. Ctrl + Shift + P: Opens the Print dialog box.

33. Ctrl + Shift + R: Fills the selected cells to the right with the contents of the cell to the left.

34. Ctrl + Shift + S: Saves the active workbook.

35. Ctrl + Shift + U: Applies or removes underline formatting to the selected cells.

36. Ctrl + Shift + V: Pastes the contents of the clipboard into the selected cells.

37. Ctrl + Shift + W: Closes the active workbook.

38. Ctrl + Shift + X: Cuts the selected cells.

39. Ctrl + Shift + Y: Repeats the last command or action.

40. Ctrl + Shift + Z: Undoes the last command or action.

41. Ctrl + Alt + A: Inserts the sum of the selected cells.

42. Ctrl + Alt + B: Applies or removes bold formatting to the selected cells.

43. Ctrl + Alt + C: Copies the selected cells.

44. Ctrl + Alt + D: Fills the selected cells down with the contents of the cell above.

45. Ctrl + Alt + F: Opens the Find and Replace dialog box.

46. Ctrl + Alt + G: Opens the Go To dialog box.

47. Ctrl + Alt + H: Opens the Replace dialog box.

48. Ctrl + Alt + I: Applies or removes italic formatting to the selected cells.

49. Ctrl + Alt + K: Inserts a hyperlink.

50. Ctrl + Alt + N: Creates a new workbook.

51. Ctrl + Alt + O: Opens an existing workbook.

52. Ctrl + Alt + P: Opens the Print dialog box.

53. Ctrl + Alt + R: Fills the selected cells to the right with the contents of the cell to the left.

54. Ctrl + Alt + S: Saves the active workbook.

55. Ctrl + Alt + U: Applies or removes underline formatting to the selected cells.

56. Ctrl + Alt + V: Pastes the contents of the clipboard into the selected cells.

57. Ctrl + Alt + W: Closes the active workbook.

58. Ctrl + Alt + X: Cuts the selected cells.

59. Ctrl + Alt + Y: Repeats the last command or action.

60. Ctrl + Alt + Z: Undoes the last command or action.

61. Ctrl + F1: Hides or unhides the Ribbon.

62. Ctrl + F2: Prints the active worksheet.

63. Ctrl + F3: Opens the Name Manager.

64. Ctrl + F4: Closes the active workbook.

65. Ctrl + F5: Refreshes the active worksheet.

66. Ctrl + F6: Switches to the next workbook.

67. Ctrl + F7: Performs a move or resize operation on the active workbook.

68. Ctrl + F8: Performs a size operation on the active workbook.

69. Ctrl + F9: Minimizes the active workbook.

70. Ctrl + F10: Maximizes the active workbook.

71. Ctrl + F11: Inserts a new worksheet.

72. Ctrl + F12: Opens the Open dialog box.

73. Ctrl + Shift + F1: Hides or unhides the Ribbon.

74. Ctrl + Shift + F2: Prints the active worksheet.

75. Ctrl + Shift + F3: Opens the Name Manager.

76. Ctrl + Shift + F4: Closes the active workbook.

77. Ctrl + Shift + F5: Refreshes the active worksheet.

78. Ctrl + Shift + F6: Switches to the next workbook.

79.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.