Microsoft Excel tips and tricks: 100 Excel Shortcuts that make working faster for Windows Users

Main Image
  • Like
  • Comment
  • Share

Shortcuts are something that aims to save our time. Whether they are in traveling routes or software in PC, using keyboard shortcuts save us time and make work easier. Microsoft Excel is a tool that has a good number of shortcuts for different functions. Although you can’t be expected to remember all of them by heart, some basic ones can be learned depending on your usage. Here is a list of 100 important shortcuts in Microsoft Excel for Windows Users.

It might initially seem very hard to use these keyboard shortcuts as you have been using a mouse since day one, but learning these shortcuts will save you a good amount of time going forward. You will be able to work faster and more efficiently in Microsoft Excel.

ALSO READ: Realme GT 2 and GT 2 Pro tipped to launch in India soon

Note- The list below doesn’t claim to include all shortcuts that exist. These are 100 those which can prove to be most useful.

100 Microsoft Excel Keyboard Shortcuts for Windows Users

1. Ctrl+A: To select all the contents in a workbook.

2. Ctrl+ B: To turn highlighted cells bold.

3. Ctrl+ C: To copy cells that are highlighted.

4. Ctrl+ D: To fill the selected cell within the content of the cell right above.

5. Ctrl+ F: To search for anything in a workbook.

6. Ctrl+ G: To jump to a certain area within a single command.

7. Ctrl+ H: To find and replace cell contents.

8. Ctrl+ I: To italicize cell contents.

9. Ctrl+ K: To insert a hyperlink in a cell.

10. Ctrl+ L: To open the create table dialog box.

11. Ctrl+ N: To create a new workbook.

12. Ctrl+ O: To open a saved workbook.

13. Ctrl+ P: To print a workbook.

14. Ctrl+ R: To fill the selected cell with the content of the cell on the left.

15. Ctrl+ S: To save a workbook.

16. Ctrl+ U: To underline the highlighted cells.

17. Ctrl+ V: To paste anything that was copied.

18. Ctrl+ W: To close your current workbook.

19. Ctrl+ Z: To undo the last action

20. Ctrl+0: To hide a column.

21. Ctrl+1: To format the cell contents.

22. Ctrl+5: To put a strikethrough in a cell.

23. Ctrl+8: To show the outline symbols.

24. Ctrl+9: To hide a row.

25. Ctrl+ Shift+: : To enter the current time in a cell.

26. Ctrl+: To enter the current date in a cell.

27. Ctrl+ ‘ : To copy the formula from the cell above.

28. Ctrl+‛ : To change the view from displaying cell values to formulas.

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 the selected cells.

38. Ctrl+ Shift+_: To remove a border.

39. Ctrl+ Shift+ Spacebar: To select an entire workbook.

40. Ctrl+ Spacebar: To select an entire row.

41. Ctrl+-: To delete a selected row or column.

42. Ctrl+ Home: To redirect to cell A1.

43. Ctrl+ Shift+ Tab: To switch between the previous workbook.

44. Ctrl+ Shift+ F: To open the fonts 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 copy.

48. Ctrl+ Up arrow: To go to the topmost cell in a current column.

49. Ctrl+ Down arrow: To jump to the last cell in a current column.

50. Ctrl+ Right arrow: To go to the last cell in a selected row.

51. Ctrl + Left arrow: To jump back to the first cell in a selected row.

52. Ctrl + End: To go to the last cell in a workbook.

53. Alt+ Page down: To move the screen towards the right.

54. Alt + Page up: To move the screen towards the left.

55. Ctrl+ F1: To expand or collapse the ribbon.

56. Ctrl+ F2: To open the print preview window.

57. Alt: To open the access keys.

58. Alt+ F+ T: To open the options.

59. Tab: Move to the next cell.

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 edit a cell comment.

64.  Alt+ H+ B: To add a border.

ALSO READ: Google to launch Android 13 during its I/O Event in May 2022

65. Alt + H+ H: To select a fill color.

66. Ctrl +9: To hide the selected rows.

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 to the next one.

70. Shift + Right arrow: To extend the cell selection to the right.

71. Shift + Left arrow: To extend the cell selection to the left.

72. Page up/down: To move the screen up or down.

73. Shift+ Space: To select the entire row.

74. Alt+ H: To go to the Home tab in Ribbon.

75. Alt+ N: To go to the Insert tab in Ribbon.

76. Alt+ P: To go to the Page Layout tab in Ribbon.

77. Alt+ M: To go to the Formulas tab in Ribbon.

78. Alt+ A: To go to the Data tab in Ribbon

79. Alt+ R: To go to the review tab in Ribbon.

80. Alt+ W: To go to the view tab in Ribbon.

81. Alt+ Y: To open the help section in Ribbon,

82. Alt+ Q: To quickly jump to 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 calculate 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 inside a workbook.

91. Ctrl+ Alt+: To zoom outside a workbook.

92.  Alt+ 1: To 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: To close and save your workbook.

97. Alt or F11: To turn key tips on or off.

98. Alt+ Y+ W: To know what’s new in Microsoft Excel.

99. F1: To open Microsoft Excel help.

100. Ctrl+F4: To close Microsoft Excel.

Shivangi AgarwalShivangi Agarwal
Shivangi is an honours graduate in English from Delhi University with a passion for reading and writing. Always keen to know more about the latest gadgets, when she is not reading about tech, she loves listening to Hindi music and grooving to the latest Hindi beats.

Related Articles

ImageSamsung Galaxy Z Fold6 Review: Incremental Upgrades and Galaxy AI Make It Stand Out

Samsung’s latest foldable, the Galaxy Z Fold6, has hit the market, and it’s unfolding a new chapter for foldables. This is the sixth generation of Samsung foldable, and a lot has changed in these six years. Until last year, Samsung virtually had a honeymoon period as there was almost no competition. But things are changing …

Image30+ Best Google Docs Keyboard Shortcuts for Windows and MacBooks

Google Docs is one online tool that most working professionals and students use every other day. The simplicity and streamlined approach tagged with Google Docs make this online word processor an incredible productivity tool. The other significant factor responsible for the popularity of Google Docs is its free availability for every Google account holder. Google …

ImageWindows 11 Keyboard Shortcuts: The Essential Guide to Boosting Your Productivity

In the digital age, time is of the essence, and efficiency in using your computer can significantly impact your productivity. Windows 11, the latest desktop operating system from Microsoft, comes with a host of keyboard shortcuts that can streamline your daily tasks. These shortcuts are designed to make your work life easier, helping you navigate …

ImageArtificial Intelligence Powered Microsoft Designer App Now Live for Android & iOS Users

Microsoft has rolled out the Canva-like AI-powered App for editing as a general app for Android and iOS users. Microsoft Designer App is now accessible with a Microsoft account and lets you edit, create, and make designs from scratch, all with the help of AI. The app works seamlessly as it integrates Microsoft products like …

ImageWindows Recall Explained: How It Works, Potential Privacy Concerns, And What Microsoft Is Doing To Address Them

At the annual developer conference, Microsoft showcased many of the features and abilities coming to the Copilot+ PCs (software platform that brings new AI features) with Windows 11. However, one of the most unique features was Recall.  Previously, we’ve heard about a rumored AI-based feature called AI Explorer. The feature was supposed to help users …

Discuss

Be the first to leave a comment.