Excel shortcuts

Excel Shortcut Keys List: The 50+ Best Shortcuts You Need to Know

If you're an Excel power user, you know that shortcut keys are essential for working quickly and efficiently in spreadsheets. While there are hundreds of different shortcut keys you can use in Excel, we've compiled a list of the 50+ best shortcuts you need to know to help you boost your productivity.

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 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 with the contents of the cell to the left.

14. Ctrl + S: Saves the active workbook.

15. Ctrl + U: Applies or removes underlining.

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 a new worksheet.

22. Ctrl + Shift + C: Copies the selected cells as a picture.

23. Ctrl + Shift + F: Opens the Format Cells dialog box.

24. Ctrl + Shift + N: Applies or removes bold formatting.

25. Ctrl + Shift + P: Opens the Page Setup dialog box.

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

27. Ctrl + Shift + U: Applies or removes underlining.

28. Ctrl + Shift + V: Pastes the contents of the clipboard into the selected cells as a picture.

29. Ctrl + Shift + W: Closes all open workbooks.

30. Ctrl + Shift + 8: Adds or removes the outline border from the selected cells.

31. Ctrl + Shift + 9: Hides the selected rows.

32. Ctrl + Shift + 0: Unhides the selected rows.

33. Ctrl + Shift + -: Hides the selected columns.

34. Ctrl + Shift + =: Unhides the selected columns.

35. Ctrl + ': Copies the value from the cell above the active cell into the cell or the Formula Bar.

36. Ctrl + Shift + !: Changes the number format of the selected cells to the number format.

37. Ctrl + Shift + @: Changes the number format of the selected cells to the time format.

38. Ctrl + Shift + #: Changes the number format of the selected cells to the date format.

39. Ctrl + Shift + $: Changes the number format of the selected cells to the currency format.

40. Ctrl + Shift + %: Changes the number format of the selected cells to the percentage format.

41. Ctrl + Shift + ^: Changes the number format of the selected cells to the exponential format.

42. Ctrl + Shift + &: Changes the number format of the selected cells to the text format.

43. Ctrl + Shift + _: Removes the outline border from the selected cells.

44. Ctrl + Shift + +: Adds an outline border to the selected cells.

45. Ctrl + Shift + *: Selects the entire worksheet.

46. Ctrl + Shift + ~: Applies or removes the General number format.

47. Ctrl + Shift + Tab: Switches to the previous tab in the workbook.

48. Ctrl + Tab: Switches to the next tab in the workbook.

49. Ctrl + Page Up: Switches to the previous worksheet in the workbook.

50. Ctrl + Page Down: Switches to the next worksheet in the workbook.

51. Shift + F11: Inserts a new worksheet.

52. Shift + Spacebar: Selects the entire row in the worksheet.

53. Ctrl + Spacebar: Selects the entire column in the worksheet.

54. Ctrl + Shift + Spacebar: Selects the entire worksheet.

55. Ctrl + Arrow keys: Moves to the next or previous cell in a row or column.

56. Ctrl + Home: Moves to the beginning of the worksheet.

57. Ctrl + End: Moves to the end of the worksheet.

58. Ctrl + Page Up: Moves one screen up in the worksheet.

59. Ctrl + Page Down: Moves one screen down in the worksheet.

60. Alt + F1: Inserts a chart of the data in the current range.

61. Alt + F2: Saves the active workbook.

62. Alt + F4: Closes the active workbook.

63. Alt + F11: Opens the Microsoft Visual Basic Editor.

64. Alt + Enter: Inserts a new line in the same cell.

65. Shift + Enter: Completes a cell entry and moves down one cell in the worksheet.

66. Ctrl + Enter: Completes a cell entry and moves across one cell in the worksheet.

67. Tab: Completes a cell entry and moves across one cell in the worksheet.

68. Shift + Tab: Completes a cell entry and moves up one cell in the worksheet.

69. Esc: Cancels an entry in the cell or Formula Bar.

70. F2: Edits the active cell.

71. F4: Repeats the last command or action.

72. F5: Opens the Go To dialog box.

73. F7: Opens the Spelling dialog box to check spelling in the active worksheet or selected range.

74. F11: Creates a chart of the data in the current range.

75. Shift + F3: Opens the Paste Function dialog box.

76. Shift + F5: Opens the Find

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.