Excel shortcuts

35 Excel Shortcut Keys You Need to Know

If you're an Excel power user, you know that shortcut keys can save you a ton of time. Here are 35 essential shortcut keys for Microsoft Excel that will help you work faster and more efficiently.

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 Find and Replace dialog box with the Replace tab selected.

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 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 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 Find and Replace dialog box with the Replace tab selected.

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

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

35. Ctrl + Shift + U: Applies or removes underlining from the selected cells.

These are just a few of the many shortcut keys that can save you time and help you work more efficiently in Excel. For a complete list of shortcut keys, consult the Help menu in Excel.

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.