100 Shortcuts Microsoft Excel: Every Windows user should know about

by -

techno.rentetan.com – Speed up your workflow to become a master of Excel.

It is undeniable that shortcutes make our life easier and you can consult this guide to find out some of the major ones if you are a Microsoft Excel user. You may be surprised to learn about the various Excel shortcuts available, and while we don’t expect you to remember them all, it’s good to always have a list a glance away. Check out the list of some of Microsoft Excel’s most important shortcuts for Windows to facilitate your work.

Shortcuts for Microsoft Excel

Note that the list is pretty long before you start, but it is by no means a complete list of all Excel-shortcuts. But we have chosen some of the most useful shortcuts and we hope your time will be worth it.

  1. Press Ctrl + N to open a new workbook.
  2. Press Ctrl + O to open a previously saved workbook.
  3. Press Ctrl + S to save a workbook.
  4. Ctrl + A: Selects all of the contents of a workbook.
  5. Use Ctrl + B to make highlighted cells bold.
  6. Ctrl + C: Copy highlighted cells.
  7. Ctrl + D: Fills the selected cell with the content of the cell above it.
  8. Ctrl + F: To search for text in a workbook.
  9. Ctrl + G: To quickly navigate to a specific location.
  10. Ctrl + H: To search for and replace cell content.
  11. Ctrl + I: Italicizes the contents of a cell.
  12. Ctrl + K: Insert a hyperlink into a cell.
  13. Ctrl + L: Opens the Create Table dialog box.
  14. Ctrl + P: Prints a workbook.
  15. Ctrl + R: Fills the selected cell with the content of the cell on the left.
  16. Ctrl + U: Highlighted cells will be underlined.
  17. Ctrl + V: To paste any copied text.
  18. Press Ctrl + W to close the current workbook.
  19. Ctrl + Z: Undo the previous action.
  20. Ctrl + 1 is used to format the cell contents.
  21. Ctrl + 5 is used to insert a strikethrough in a cell.
  22. Ctrl + 8 displays the outline symbols.
  23. To hide a row, use Ctrl + 9.
  24. Ctrl + 0: Hide a column.
  25. To enter the current time in a cell, use Ctrl + Shift + :.
  26. Ctrl + ;: Enter the current date into a cell.
  27. Ctrl +: To switch from viewing cell values to formulas.
  28. Ctrl + ‘: To copy the formula from the previous cell.
  29. To delete columns or rows, press Ctrl + -.
  30. To insert columns and rows, use Ctrl + Shift + =.
  31. Ctrl + Shift +: To toggle between showing Excel formulas and their values in cells.
  32. To apply time formatting, press Ctrl + Shift + @.
  33. Shift + Ctrl +! To use comma formatting.
  34. To apply currency formatting, press Ctrl + Shift + $.
  35. To format a date, press Ctrl + Shift + #.
  36. To apply percentage formatting, press Ctrl + Shift + percent.
  37. Ctrl + Shift + &: To draw a border around the cells you’ve chosen.
  38. To remove a border, press Ctrl + Shift + .
  39. To delete a selected row or column, press Ctrl + -.
  40. To select an entire column, press Ctrl + Spacebar.
  41. To select an entire workbook, press Ctrl + Shift + Spacebar.
  42. Ctrl + Home: This will take you to cell A1.
  43. To return to the previous workbook, press Ctrl + Shift + Tab.
  44. Ctrl + Shift + F: Opens the fonts menu in the format cells section.
  45. Ctrl + Shift + O: To select cells with comments.
  46. Ctrl + Drag: To copy a cell or to a duplicate worksheet, drag and drop it.
  47. Ctrl + Shift + Drag: For dragging and inserting a copy.
  48. Ctrl + Up arrow: To go to the top 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 in a row.
  51. Ctrl + Left arrow: To return to the first cell in a selected row, press Ctrl + Left arrow.
  52. Ctrl + End: This command takes you to the last cell in a workbook.
  53. To move the screen to the right, press Alt + Page down.
  54. To move the screen to the left, press Alt + Page Up.
  55. To open the print preview window, press Ctrl + F2.
  56. To expand or collapse the ribbon, press Ctrl + F1.
  57. To open the access keys, press Alt.
  58. To move to the next cell, use the tab key.
  59. To open the options, press Alt + F + T.
  60. To activate cell filters, press Alt + Down arrow.
  61. To edit a cell, press F2.
  62. F3: To copy a cell name if the cells have already been named.
  63. To add or edit a cell comment, press Shift + F2.
  64. To select a fill color, press Alt + H + H.
  65. To add a border, press Alt + H + B.
  66. Ctrl + 9: Hiding the selected rows.
  67. Ctrl + 0: Hide the columns you’ve chosen.
  68. To cancel an entry, press Esc.
  69. Enter: To finish an entry in a cell and move on to the next one.
  70. Shift + Right arrow: To move the cell selection to the right.
  71. Shift + Left arrow: To move the selection to the left.
  72. To select the entire row, press Shift + Space.
  73. Page up/down: To move the screen to the right or left.
  74. Alt + H: Opens the Home tab in the Ribbon.
  75. Alt + N: Opens the Insert tab in the Ribbon.
  76. Alt + P: Opens the Page Layout tab in the Ribbon.
  77. Alt + M: Opens the Formulas tab in the Ribbon.
  78. Alt + A: Opens the Data tab in the Ribbon.
  79. Alt + R: Opens the Ribbon’s Review tab.
  80. Alt + W: Opens the View tab in the Ribbon.
  81. Pressing Alt + Y will bring up the Help tab in the Ribbon.
  82. Alt + Q: To quickly access the search function.
  83. Alt + Enter: To begin a new line in a currently selected cell.
  84. To open the Insert function dialog box, press Shift + F3.
  85. F9: Workbooks must be calculated.
  86. To calculate an active workbook, press Shift + F9.
  87. Ctrl + Alt + F9: Forces all workbooks to be calculated.
  88. To open the name manager, press Ctrl + F3.
  89. Ctrl + Shift + F3: To generate names from row and column values.
  90. Ctrl + Alt + +: To zoom in on a worksheet.
  91. To zoom out within a workbook, press Ctrl + Alt +.
  92. Alt + 1: To enable Autosave.
  93. To save a workbook, press Alt + 2.
  94. To export your workbook, press Alt + F + E.
  95. To share your workbook, press Alt + F + Z.
  96. To close and save your workbook, press Alt + F + C.
  97. Alt or F11: To activate or deactivate key tips.
  98. Alt + Y + W: To find out what’s new in Microsoft Excel.
  99. F1: To access Microsoft Excel help.
  100. To close Microsoft Excel, press Ctrl + F4.