Excel shortcuts

50 Microsoft Excel Shortcut Keys You Need to Know

Microsoft Excel is a powerful spreadsheet application that can be used for a variety of purposes. Whether you're a student, a business owner, or just someone who wants to be able to keep track of their finances, Excel is a great tool to know how to use.

While Excel is fairly user-friendly, there are a ton of shortcut keys that can make your life a lot easier. In this article, we'll share 50 of the most essential Excel shortcut keys that you need to know.

1. Ctrl + A

This shortcut key is used to select all cells in a worksheet. This is a great key to use when you need to make global changes to your spreadsheet.

2. Ctrl + B

This shortcut key is used to bold selected text. This is a great way to make important information stand out.

3. Ctrl + C

This shortcut key is used to copy selected text. This is a great way to quickly duplicate information.

4. Ctrl + D

This shortcut key is used to fill down. This is a great way to quickly fill in a series of cells with the same information.

5. Ctrl + F

This shortcut key is used to open the Find dialog box. This is a great way to quickly search for specific information in your spreadsheet.

6. Ctrl + G

This shortcut key is used to open the Go To dialog box. This is a great way to quickly jump to a specific cell in your spreadsheet.

7. Ctrl + H

This shortcut key is used to open the Replace dialog box. This is a great way to quickly find and replace information in your spreadsheet.

8. Ctrl + I

This shortcut key is used to italicize selected text. This is a great way to make important information stand out.

9. Ctrl + K

This shortcut key is used to insert a hyperlink. This is a great way to quickly add links to your spreadsheet.

10. Ctrl + N

This shortcut key is used to create a new workbook. This is a great way to quickly start a new spreadsheet.

11. Ctrl + O

This shortcut key is used to open an existing workbook. This is a great way to quickly access a spreadsheet that you've already created.

12. Ctrl + P

This shortcut key is used to print a workbook. This is a great way to quickly print out a copy of your spreadsheet.

13. Ctrl + S

This shortcut key is used to save a workbook. This is a great way to quickly save your changes to a spreadsheet.

14. Ctrl + U

This shortcut key is used to underline selected text. This is a great way to make important information stand out.

15. Ctrl + V

This shortcut key is used to paste selected text. This is a great way to quickly insert information that you've copied from another source.

16. Ctrl + W

This shortcut key is used to close a workbook. This is a great way to quickly close a spreadsheet that you're finished with.

17. Ctrl + X

This shortcut key is used to cut selected text. This is a great way to quickly remove information from a cell.

18. Ctrl + Y

This shortcut key is used to repeat the last action. This is a great way to quickly apply the same change to multiple cells.

19. Ctrl + Z

This shortcut key is used to undo the last action. This is a great way to quickly undo a change that you've made to a cell.

20. F2

This shortcut key is used to edit the selected cell. This is a great way to quickly make changes to a cell without having to re-select it.

21. F5

This shortcut key is used to open the Go To dialog box. This is a great way to quickly jump to a specific cell in your spreadsheet.

22. F7

This shortcut key is used to spell check a workbook. This is a great way to quickly check for spelling errors in your spreadsheet.

23. F11

This shortcut key is used to create a chart from selected data. This is a great way to quickly create a visual representation of your data.

24. Shift + F2

This shortcut key is used to edit a cell comment. This is a great way to quickly make changes to a cell comment.

25. Shift + F5

This shortcut key is used to open the Find dialog box. This is a great way to quickly search for specific information in your spreadsheet.

26. Shift + F11

This shortcut key is used to insert a new worksheet. This is a great way to quickly add a new worksheet to your workbook.

27. Shift + F12

This shortcut key is used to save a workbook. This is a great way to quickly save your changes to a spreadsheet.

28. Alt + F1

This shortcut key is used to insert a chart. This is a great way to quickly insert a chart into your worksheet.

29. Alt + F2

This shortcut key is used to save a workbook. This is a great way to quickly save your changes to a spreadsheet.

30. Alt + F5

This shortcut key is used to refresh a workbook. This is a great way to quickly update your spreadsheet with new data.

31. Alt + F8

This shortcut key is used to open the Macro dialog box. This is a great way to quickly access your macros.

32. Alt + F11

This shortcut key is used to open the Visual Basic Editor. This is a great way to access the Visual Basic code for your workbook.

33. Ctrl + Shift + F3

This shortcut key is used to insert a defined name. This is a great way to quickly insert a defined name into a cell.

34. Ctrl + Shift + F5

This shortcut key is used to open the Find and Replace dialog box. This is a great way to quickly find and replace information in your spreadsheet.

35. Ctrl + Shift + F11

This shortcut key is used to insert a new worksheet. This is a great way to quickly add a new worksheet to your workbook.

36. Ctrl + Shift + F12

This shortcut key is used to print a workbook. This is a great way to quickly print out a copy of your spreadsheet.

37. Shift + F3

This shortcut key is used to insert a function. This is a great way to quickly insert a function into a cell.

38. Shift + F5

This shortcut key is used to open the Go To dialog box. This is a great way to quickly jump to a specific cell in your spreadsheet.

39. Shift + F6

This shortcut key is used to switch between worksheets. This is a great way to quickly switch between different worksheets in your workbook.

40. Shift + F8

This shortcut key is used to extend a selection. This is a great way to quickly select a range of cells.

41. Shift + F9

This shortcut key is used to calculate all open workbooks. This is a great way to quickly calculate all of the open workbooks in Excel.

42. Shift + F11

This shortcut key is used to insert a new worksheet. This is a great way to quickly add a new worksheet to your workbook.

43. Shift + F12

This shortcut key is used to save a workbook. This is a great way to quickly save your changes to a spreadsheet.

44. Ctrl + ;

This shortcut key is used to insert the current date. This is a great way to quickly insert the current date into a cell.

45

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.