Microsoft Excel: 100 Shortcuts Every Windows User Should Know

0

There is no denying that shortcuts make our life easier and if you are a Microsoft Excel user, you can refer to this guide to learn some of the main ones. You might be surprised to learn more about the variety of Excel shortcuts available, and while we wouldn’t expect you to remember them all, it’s always good to have a list handy. Read on as we list some of the most important Microsoft Excel shortcuts for Windows to make your job easier.

Microsoft Excel keyboard shortcuts

Before continuing, please note that the list is quite long but it is by no means a complete list made up of all Excel shortcuts. However, we’ve picked out some of the most useful shortcuts, and we hope it will be worth it.

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: To select all the contents of a workbook.
5. Ctrl + B: to bold the highlighted cells.
6. Ctrl + C: to copy the highlighted cells.
7. Ctrl + D: To fill the selected cell with the contents of the cell just above.
8. Ctrl + F: to find anything in a workbook.
9. Ctrl + G: To jump to a certain area with a single command.
10. Ctrl + H: to find and replace the contents of cells.
11. Ctrl + I: To italicize the contents of the cells.
12. Ctrl + K: To insert a hypertext link in a cell.
13. Ctrl + L: to open the table creation dialog box.
14. Ctrl + P: to print a workbook.
15. Ctrl + R: To fill the selected cell with the content of the left cell.
16. Ctrl + U: to underline the highlighted cells.
17. Ctrl + V: to paste everything that has been copied.
18. Ctrl + W: to 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: Put a strikethrough in a cell.
22. Ctrl + 8: To display outline symbols.
23. Ctrl + 9: to hide a line.
24. Ctrl + 0: to hide a column.
25. Ctrl + Shift +:: To enter the current time in a cell.
26. Ctrl +;: To enter today’s date in a cell.
27. Ctrl + `: to change the display of 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 + ~: to switch between displaying Excel formulas or their values ​​in the cell.
32. Ctrl + Shift + @: To apply time formatting.
33. Ctrl + Shift +!: to apply comma formatting.
34. Ctrl + Shift + $: to apply currency formatting.
35. Ctrl + Shift + #: To apply date formatting.
36. Ctrl + Shift +%: to apply percentage formatting.
37. Ctrl + Shift + &: To place borders around selected cells.
38. Ctrl + Shift + _: to remove a border.
39. Ctrl + –: To delete a selected row or column.
40. Ctrl + space bar: To select an entire column.
41. Ctrl + Shift + Space: to select an entire workbook.
42. Ctrl + Home: To redirect to cell A1.
43. Ctrl + Shift + Tab: to go to the previous workbook.
44. Ctrl + Shift + F: To open the font menu under Format Cells.
45. Ctrl + Shift + O: To select the cells containing comments.
46. ​​Ctrl + Drag: to drag and copy a cell or to a duplicate worksheet.
47. Ctrl + Shift + Drag: To drag and insert a copy.
48. Ctrl + Up Arrow: To go to the highest cell in a current column.
49. Ctrl + Down Arrow: To jump to the last cell of a current column.
50. Ctrl + Right arrow: To go to the last cell of a selected row.
51. Ctrl + Left Arrow: to return to the first cell of a selected row.
52. Ctrl + End: to access the last cell of a workbook.
53. Alt + Page down: To move the screen to the right.
54. Alt + Previous page: To move the screen to the left.
55. Ctrl + F2: To open the print preview window.
56. Ctrl + F1: to expand or collapse the ribbon.
57. Alt: To open the access keys.
58. Tab: go to the next cell.
59. Alt + F + T: To open the options.
60. Alt + Down arrow: To activate filters for cells.
61. F2: To edit a cell.
62. F3: To paste a cell name if the cells have been named.
63. Shift + F2: To add or modify a cell comment.
64. Alt + H + H: To select a fill color.
65. Alt + H + B: To add a border.
66. Ctrl + 9: to hide the selected lines.
67. Ctrl + 0: to hide the selected columns.
68. Esc: To cancel an entry.
69. Enter: To complete the entry in a cell and move on to the next.
70. Shift + Right Arrow: To extend the selection of cells to the right.
71. Shift + Left Arrow: To extend the selection of cells to the left.
72. Shift + Space: To select the entire line.
73. Page up / down: To move the screen up or down.
74. Alt + H: to access the Home tab of the ribbon.
75. Alt + N: to access the Insert tab of the ribbon.
76. Alt + P: to access the Layout tab in the ribbon.
77. Alt + M: to access the Formulas tab in the ribbon.
78. Alt + A: to access the Data tab in the ribbon.
79. Alt + R: to access the Review tab in the ribbon.
80. Alt + W: to access the View tab in the ribbon.
81. Alt + Y: to open the Help tab in the ribbon.
82. Alt + Q: To go quickly to the search.
83. Alt + Enter: To start a new line in a current cell.
84. Shift + F3: to open the Insert Function dialog box.
85. F9: To calculate workbooks.
86. Shift + F9: to calculate an active workbook.
87. Ctrl + Alt + F9: To force the calculation of all workbooks.
88. Ctrl + F3: To open the name manager.
89. Ctrl + Shift + F3: to create names from values ​​in rows and columns.
90. Ctrl + Alt + +: To zoom in in a workbook.
91. Ctrl + Alt +: To zoom out in a workbook.
92. Alt + 1: to activate automatic recording.
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: To close and save your workbook.
97. Alt or F11: To activate or deactivate the key tips.
98. Alt + Y + W: To find out what’s new in Microsoft Excel.
99. F1: to open Microsoft Excel Help.
100. Ctrl + F4: to close Microsoft Excel.

Here are some of the important shortcuts that can help you become a Microsoft Excel master. If you think we’ve missed something, or have any suggestions, let us know in the comments.


Is the MacBook Air M1 the portable beast of a laptop you’ve always wanted? We discussed it on Orbital, our weekly tech podcast, which you can subscribe to through Apple Podcasts, Google Podcasts, or RSS, download the episode, or just hit the play button below.

For the latest tech news and reviews, follow Gadgets 360 on Twitter, Facebook and Google News. For the latest videos on gadgets and tech, subscribe to our YouTube channel.

Apple shares patch for Apple TV and Apple Watch “Unpaired” with Apple Fitness +

Facebook 2020 in Review reveals specific India moments that resonated, from Irrfan Khan to Sushant Singh Rajput to Diwali celebrations

Related stories



Source link

Share.

Comments are closed.