The top 40 Excel Shortcuts Every User Should Know

Table of Contents

Because you handle data entry in Microsoft Excel; you must find the easiest way of navigating around Microsoft Excel. The shortcuts make it easier and you can refer to this guide to learn some of the major shortcut tips.

Knowing a variety of Excel shortcuts makes you more proficient, and helps you in achieving your goal in a short time. While we do not expect you to remember all of them, it is always a good thing to glance at the list of the most common shortcuts.

Read on, as we list some of the top 40 excel shortcuts every user should know for Windows to make your work easier and faster.

Excel Shortcuts Keys

1. Ctrl + C to copy
2. Ctrl + V to paste
3. Ctrl + X to cut
4. Ctrl + Z to undo

5. CTRL+SHIFT+( to Unhides any hidden rows within the selection
6. CTRL+SHIFT+) to Unhides any hidden columns within the selection.
7. Ctrl + Y to redo
8. Ctrl + P to print

9. Ctrl + S to save
10. Ctrl + F to find and replace
11. Ctrl + N to create a new blank workbook
12. Ctrl + Home to go to the beginning of the worksheet
13. Ctrl + End to go to the end of the worksheet

14. CTRL+SHIFT+& to Apply the outline border to the selected cells.
15. CTRL+; to enter the current date.
16. CTRL+’ to Copy a formula from the cell above the active cell into the cell or the Formula Bar.

17. CTRL+1 to Display the Format Cells dialog box.
18. CTRL+F1 to display or hide the ribbon.
19. ALT+F1 to create a chart of the data in the current range.
20. SHIFT+F5 to display this tab,

21. SHIFT+F4 to repeat the last Find action
22. CTRL+SHIFT+F to open the Format Cells dialog box with the Font tab selected.
23. SHIFT+F2 adds or edits a cell comment.
24. CTRL+F2 displays the Print Preview window.

25. ALT+SHIFT+F1 to insert a new worksheet.
26. Shift + F2 to insert a comment in a cell
27. Alt + = to insert a formula to sum a range of cells
28. Ctrl +; to insert the current date
29. Ctrl + Shift + ; to insert the current time
30. Ctrl + Shift + F to apply a specific cell format

31. Ctrl + Shift + 5 to apply the currency cell format
32. Ctrl + Shift + H to apply the fill color to a range of cells
33. Ctrl + Shift + I to apply the italic font style
34. Ctrl + Shift + L to apply the auto filter to a range of cells
35. Ctrl + Shift + U to apply the underline font style
36. Ctrl + Shift + B to apply the bold font style

37. Ctrl + Shift + 8 to apply the outline border to a range of cells
38. Ctrl + Shift + 9 to apply the inside border to a range of cells
39. Ctrl + Shift + 7 to apply the outside border to a range of cells
40. Ctrl + Shift + J to justify the text in a cell
41. Ctrl + Shift + E to apply the center align to a cell or range of cells
42. Ctrl + Shift + R to apply the right align to a cell or range of cells
43. Ctrl + Shift + L to apply the left align to a cell or range of cells

Want to keep up with our blog?

Get our most valuable tips right inside your inbox, once per month!