There is no denying the fact that shortcuts make our lives easier and if you are a Microsoft Excel user you can refer to this guide to learn some important ones. It may surprise you to learn about the different types of Excel shortcuts out there, and although we do not expect you to remember them all, it’s always a good idea to have a to-do list. Read on as we list some important Microsoft Excel shortcuts for Windows to make your work easier.
Microsoft Excel Keyboard Shortcuts
Before you move on, note that the list is too long, but this is not a complete list at all Excel Shortcuts. However, we have selected the most useful shortcuts and we hope it is worth your time.
1. Ctrl + N.: Creating a new workbook.
2. Ctrl + O.: To open a saved workbook.
3. Ctrl + S.: To save the workbook.
4. Ctrl + A.: To select all the contents of the workbook.
5. Ctrl + B.: To make highlighted cells bold.
6. Ctrl + C.: To copy highlighted cells.
7. Ctrl + D.: To fill the selected cell with the content of the cell mentioned above.
8. Ctrl + F.: To search anything in the workbook.
9. Ctrl + G.: Going to a specific area with a single command.
10. Ctrl + H.: To find and replace cell contents.
11. Ctrl + I.: To make cell contents italic.
12. Ctrl + K.: To insert a hyperlink into a cell.
13. Ctrl + L.Open the Create Table dialog box:
14. Ctrl + P.: To print a workbook.
15. Ctrl + R.: Filling the selected cell with the content of the cell on the left.
16. Ctrl + U.: To underline highlighted cells.
17. Ctrl + V.: Copy and paste anything.
18. Ctrl + W.: To close your current workbook.
19. Ctrl + Z.: To undo the last action.
20. Ctrl + 1: To format cell contents.
21. Ctrl + 5: To put a strike on the cell.
22. Ctrl + 8: To show outline icons.
23. Ctrl + 9: To hide the row.
24. Ctrl + 0: Hide column
25. Ctrl + Shift +:: To enter the current time in the cell.
26. Ctrl +;: To enter the current date in the cell.
27. Ctrl + `: Changing perspective from displaying cell values to principles.
28. Ctrl + ‘: To copy the formula from the cell above.
29. Ctrl + –: To remove columns or rows.
30. Ctrl + Shift + =: 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 configuration.
33. Ctrl + Shift +!: To apply comma configuration.
34. Ctrl + Shift + $: To apply currency configuration.
35. Ctrl + Shift + #: To apply date configuration.
36. Ctrl + Shift +%: To apply percentage configuration.
37. Ctrl + Shift + &: To place borders around selected cells.
38. Ctrl + Shift + _: To remove the border.
39. Ctrl + –: To remove the selected row or column.
40. Ctrl + Spacebar: Choose the whole column:
41. Ctrl + Shift + Spacebar: To select the entire workbook.
42. Ctrl + Home: To redirect to cell A1.
43. Ctrl + Shift + Tab: Switch to previous workbook.
44. Ctrl + Shift + F.: To open the font menu below the format cells.
45. Ctrl + Shift + O.: To select cells containing comments.
46. Press Ctrl +: To drag and copy a cell or to a duplicate worksheet.
47. Ctrl + Shift + Drag: To pull and insert a copy.
48. Ctrl + up arrow: To go to the highest cell in the current column.
49. Ctrl + down arrow: To go to the last cell in the current column.
50. Ctrl + right arrow: To go to the last cell of the selected row.
51. Ctrl + left arrow: To go back to the first cell in the selected row.
52. Ctrl + End: To go 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: To open the print preview window.
56. Ctrl + F1: To extend or tear the ribbon.
57. Alt: To open the access keys.
58. Tab: Move to next cell.
59. Alt + F + T: Open options.
60. Alt + down arrow: To activate filters for cells.
61. F2: To edit the cell.
62. F3: Paste the cell name if the cells are named.
63. Shift + F2: To add or edit a cell comment.
64. Alt + H + H.: To choose the filler color.
65. Alt + H + B.: To add a border.
66. Ctrl + 9: To hide selected rows.
67. Ctrl + 0: To hide selected columns:
68. s: To cancel entry.
69. Enter: Complete the entry in the cell and proceed to the next.
70. Shift + right arrow: Extend cell option to the right.
71. Shift + left arrow: To expand the cell option to the left.
72. Shift + space: To select the entire row.
73. Page up / down: To move the screen up or down.
74. Alt + H: To go to the Home tab in the Ribbon.
75. alt + n: To go to the Insert tab on the ribbon.
76. Alt + p: To go to the Page Layout tab in the Ribbon.
77. Alt + M: To go to the Formulas tab in the Ribbon.
78. Alt + a: To go to the Data tab in the Ribbon.
79. alt + r: To go 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 on the ribbon.
82. Alt + Q.Search quickly:
83. Alt + Enter: To start a new line in the current cell.
84. Shift + F3: Insert function to open the dialog box.
85. F9: To count workbooks.
86. Shift + F9: To calculate the active workbook.
87. Ctrl + Alt + F9: Forcibly counting all workbooks.
88. Ctrl + F3: To open the name manager.
89. Ctrl + Shift + F3: Creating names from values in rows and columns.
90. Ctrl + Alt ++: To zoom inside the workbook
91. Ctrl + Alt +: To zoom out inside the workbook.
92. Alt + 1: To turn on autosave.
93. Alt + 2: To save the 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: Key tips to turn on or off.
98. Alt + Y + W.: Learn what’s new in Microsoft Excel.
99. F1: To open Microsoft Excel help.
100. Ctrl + F4: Close Microsoft Excel.
Here are some important shortcuts to help you become a Microsoft Excel master. If you think we missed something, or you have some suggestions, please let us know in the comments.
The MacBook Air M1 is the portable beast of the laptop you’ve always wanted? We discussed this Orbit, Our weekly technology podcast, you can subscribe to Apple Podcasts, Google Podcasts, Or RSS, Download the episode, Or press the Play button below.