TECHNOLOGY

81 Microsoft Excel shortcut keys – Master your Spreadsheet

Mastering these Microsoft Excel shortcut keys, you will be amazed how fast you could get your job done with ease.

81 Microsoft Excel shortcut keys you should know.

Be that guru you have always wanted to be. With these shortcut keys, you will not only master excel, but you will good at using the keyboard.

1. Ctrl+K > Insert Hyperlink.
2. Ctrl+N > New Workbook.
3. Ctrl+H > Replace.
4. Ctrl+C > Copy.
5. Ctrl+F > Find.
6. F4 > While typing a formula, switch between absolute/ref.
7. F5 >
8. Edit, Goto.
9. F6 > Next Pane None
10. F7 > Spell check
11. F8 > Extend mode
12. F9 > Recalculate all workbooks Tools, Options, Calculation.
13. F10 > Activate Menu bar.
14. F11 > Insert  Chart
15. F12 > Save File As
16. Ctrl+: > Insert Current Time
17. Ctrl+; > Insert Current Date
18. Ctrl+” > Copy Value from Cell Above
19. Edit, Paste Special, Value
20. Ctrl+’ > Copy Formula from Cell Above Edit, Copy Shift
21. Shift+F1 > Help
22. Shift+F2
23. Tab > Next tool
24. Shift+Tab > Previous tool
25. Shift+Ctrl+F > Font Drop Down List
26. Shift+F3 > Insert Function into formula.
27. Shift+F4 > Find Next

Read Also – Mac Shortcut Keys –  Bring out the Best of your Skills

28. Shift+F6 > Previous Pane.
29. Shift+F8 > Add to selection.
30. Shift+F9 > Calculate active worksheet.
31. Shift+F10 > Display shortcut menu.
32. Shift+F11 > New worksheet.
33. Shift+F12 >
34. Ctrl+F3 > Insert Names.
35. Ctrl+F4 >
36. Ctrl+F5 > Restore window size.
37. Ctrl+F6 > Next workbook window.
38. Shift+Ctrl+F6 > Previous workbook window.
39. Ctrl+F7 > Move window
40. Ctrl+F8 > Resize window
41. Ctrl+F9 > Minimize workbook

Related –  OVER 201 WINDOWS SHORTCUT KEYS – MAKE LIFE EASIER !

42. Ctrl+F10 > Maximize or restore window
43. Ctrl+F12 > Open File
44. Alt+F1 > Insert Chart
45. Ctrl+Shift+F6 > Previous Window
46. Ctrl+Shift+F12 > Print
47. Alt+Shift+F1 > New worksheet
48. Alt+Shift+F2 > Save
49. Ctrl+Shift+A > Insert argument names into formula
50. Alt+Down arrow > Display AutoComplete list
51. Alt+’ > Format Style dialog box
52. Ctrl+Shift+~ > General format
53. Ctrl+Shift+! > Comma format

See Also –  63 MICROSOFT WORD SHORTCUT KEYS – BE A PROFESSIONAL

54. Ctrl+Shift+@ > Time format
55. Ctrl+Shift+# > Date format
56. Ctrl+Shift+$ > Currency format
57. Ctrl+Shift+% > Percent format
58. Ctrl+Shift+& > Place outline border around selected cells
59. Ctrl+Shift+_ > Remove outline border
60. Ctrl+Shift+* > Select current region
61. Ctrl++ >Insert, (Rows, Columns, or Cells)
62. Ctrl+1 > Format cells dialog box
63. Ctrl+2 > Bold
64. Ctrl+3 > Italic
65. Ctrl+4 > Underline

Also Read – Top 5 Video Conferencing – Video Chat Apps – Download and Sign Up

66. Ctrl+5 > Strikethrough
67. Ctrl+6 > Show/Hide objects
68. Ctrl+7 > Show/Hide Standard toolbar
69. Ctrl+8 > Toggle Outline symbols
70. Ctrl+9 > Hide rows
71. Ctrl+0 > Hide columns
72. Ctrl+Shift+ > Unhide rows
73. Alt or F10 > Activate the menu
74. Ctrl+Tab > next toolbar
75. Shift+Ctrl+Tab > previous toolbar
76. Ctrl+Tab > activate next workbook
77. Shift+Ctrl+Tab > activate previous workbook
78. Shift+Tab > Previous tool
79. Shift+Ctrl+F > Font Drop Down List

Don’t Miss this – 7 Top VPN to use – Enjoy Online Privacy and Freedom

80. Shift+Ctrl+F+F > Font tab of Format Cell Dialog box
81. Shift+Ctrl+P > Point size Drop Down List