Microsoft Excel: 100 shortcuts every Windows user should know
There is no denying the fact that shortcuts make our lives easier, and if you are a user of Microsoft Excel, you can refer to this guide for some of the main shortcuts. You might be surprised to know the variety of Excel shortcuts out there, and while we don’t expect you to remember them all, it’s always a good idea to have a list within a glance. Read on, as we list some of the most important Microsoft Excel shortcuts for Windows to make your work easier.
Microsoft Excel keyboard shortcuts
Before proceeding, note that the list is quite long but by no means a complete one consisting of all Excel Shortcuts. However, we have picked some of the most useful shortcuts, and we hope this one was worth your time.
1. Ctrl + N: To create a new workbook.
2. Ctrl + O: To open a saved workbook.
3. Ctrl + S: To save a workbook.
4. Ctrl + A: Select all content in a workbook.
5. Ctrl + B: Converts the cells marked in bold.
6. Ctrl + C: To copy the highlighted cells.
7. Ctrl + D: To fill in the selected cell with the cell content above.
8. Ctrl + F: To search for anything in a workbook.
9. Ctrl + G: To jump to a specific area with one command.
10. Ctrl + H: Find and replace cell contents.
11. Ctrl + I: To make the cell contents italic.
12. Ctrl + K: To insert a hyperlink into a cell.
13. Ctrl + L: To open the Create Table dialog.
14. Ctrl + P.: To print a workbook.
15. Ctrl + R: Fills the selected cell with the content of the cell to the right.
16. Ctrl + U: Underline the highlighted cells.
17. Ctrl + V: To paste anything copied.
18. Ctrl + W: Close your current workbook.
19. Ctrl + Z: To undo the last action.
20. Ctrl + 1: To format the contents of the cell.
21. Ctrl + 5: To place a strikethrough in the cell.
22. Ctrl + 8: To show the outline symbols.
23. Ctrl + 9Hide a row.
24. Ctrl + 0: To hide a column.
25. Ctrl + Shift +:: Enters the current time in a cell.
26. Ctrl +;: Enters the current date into a cell.
27. Ctrl + `: Change the view from displaying cell values to formulas.
28. Ctrl + ‘: To copy the formula from the cell above.
29. Ctrl + –: To delete columns or rows.
30. Ctrl + Shift + =: To insert columns and rows.
31. Ctrl + Shift + ~: Switches between displaying Excel formulas or their values in the cell.
32. Ctrl + Shift + @: To apply the time format.
33. Ctrl + Shift +!: To apply comma formatting.
34. Ctrl + Shift + $: To apply the currency format.
35. Ctrl + Shift + #: To apply the date format.
36. Ctrl + Shift +%: Applies the percentage format.
37. Ctrl + Shift + &: To place borders around selected cells.
38. Ctrl + Shift + _: To remove a limit.
39. Ctrl + –: To delete a selected row or column.
40. Ctrl + Spacebar: To select an entire column.
41. Ctrl + Shift + Spacebar: To select an entire workbook.
42. Ctrl + Home: To redirect to cell A1.
43. Ctrl + Shift + Tab: Switch to the previous workbook.
44. Ctrl + Shift + F: To open the list of fonts under Format Cells.
45. Ctrl + Shift + O: To select cells that contain comments.
46. Ctrl + drag: To drag and copy a cell or to a duplicate worksheet.
47. Ctrl + Shift + Drag: To withdraw and insert a copy.
48. Ctrl + Up Arrow: Move to the highest cell in the current column.
49. Ctrl + Down arrow: Moves to the last cell in the current column.
50. Ctrl + Right Arrow: Moves to the last cell in a specified row.
51. Ctrl + Left Arrow: Goes back to the first cell in a specified row.
52. Ctrl + end: Moves to the last cell in the workbook.
53. Alt + Page down: To move the screen to the right.
54. Alt + Page Up: To move the screen to the left.
55. Ctrl + F2: Open the print preview window.
56. Ctrl + F1: To expand or collapse the ribbon.
57. Alternative: To open access keys.
58. TabMove to the next cell.
59. Alt + F + T.: To open options.
60. Alt + Down Arrow: Activate filters for cells.
61- F2: To edit a cell.
62. F3: Paste a cell name if cells are named.
63. Shift + F2: To add or edit a cell comment.
64. Alt + H + H: Define a fill color.
65. Alt + H + B: To add a limit.
66. Ctrl + 9: Hides the selected rows.
67. Ctrl + 0: Hide the selected columns.
68. Esc: To cancel the entry.
69. Enter: Complete an entry in a cell and move to the next cell.
70. Shift + Right Arrow: Expand the cell selection to the right.
71. Shift + Left Arrow: Extend the cell selection to the left.
72. Shift + distance: To select the entire row.
73. Page Up / Down: To move the screen up or down.
74. Alt + H: Move to the Home tab in the ribbon.
75. Alt + N: Move to the Ribbon Insert tab.
76. Alt + P: Move to the Page Layout tab in the ribbon.
77. Alt + M: Move to the Formulas tab in the ribbon.
78. Alt + A: To go to the “Data” tab in the ribbon.
79. Alt + R: Move to the “Review” tab in the ribbon.
80. Alt + W: To go to the “View” tab in the ribbon.
81. Alt + Y: To open the Help tab in the ribbon.
82. Alt + Q: To quickly jump to search.
83. Alt + Enter: To start a new line in an existing cell.
84. Shift + F3: To open the “Insert Function” dialog.
85. F9: To calculate the workbooks.
86. Shift + F9: To calculate an active workbook.
87. Ctrl + Alt + F9: To force all workbooks to be counted.
88. Ctrl + F3: To open the name manager.
89. Ctrl + Shift + F3: Create names from values in rows and columns.
90. Ctrl + Alt ++: To zoom inside a workbook.
91. Ctrl + Alt +: Zoom out inside a workbook.
92. Alt + 1: Turn on autosave.
93. Alt + 2: To save a workbook.
94. Alt + F + E: To export your workbook.
95. Alt + F + Z: To share your workbook.
96. Alt + F + C: Close and save your workbook.
97. Substitute or F11: Turn key tips on or off.
98. Alt + Y + W: Find out what’s new in Microsoft Excel.
99. F1: To open Microsoft Excel Help.
100. Ctrl + F4: To close Microsoft Excel.
These are some of the important shortcuts that can help you become an expert in Microsoft Excel. If you think we missed something, or if you have some suggestions, please let us know in the comments.
Is MacBook Air M1 the portable laptop beast of your dreams? We discussed this on Orbital, Our weekly tech podcast, which you can subscribe to via Apple PodcastAnd the Google Podcastor RSSAnd the Download the episodeOr, just hit the play button below.
To the most recent Technology news And the reviewFollow Gadgets 360 at TwitterAnd the The social networking site FacebookAnd Google News. For the latest videos on tools and technology, subscribe to our site YouTube channel.
“Coffee fanatic. Gamer. Award-winning zombie lover. Student. Hardcore internet advocate. Twitter guru. Subtly charming bacon nerd. Thinker.”