Saturday 17 June 2017

Complete List of MS Excel-Word-Power Point Shortcut Keys


  1. Ctrl+A - Select All 
  2. Ctrl+B - Bold 
  3. Ctrl+C - Copy 
  4. Ctrl+D - Fill Down 
  5. Ctrl+F - Find 
  6. Ctrl+G - Goto 
  7. Ctrl+H - Replace 
  8. Ctrl+I - Italic 
  9. Ctrl+K - Insert Hyperlink 
  10. Ctrl+N - New Workbook 
  11. Ctrl+O - Open 
  12. Ctrl+P - Print 
  13. Ctrl+R - Fill Right 
  14. Ctrl+S - Save 
  15. Ctrl+U - Underline 
  16. Ctrl+V - Paste 
  17. Ctrl W - Close 
  18. Ctrl+X - Cut 
  19. Ctrl+Y - Repeat 
  20. Ctrl+Z - Undo 
  21. F1 - Help 
  22. F2 - Edit 
  23. F3 - Paste Name 
  24. F4 - Repeat last action 
  25. F4 - While typing a formula, switch between absolute/relative refs 
  26. F5 - Go to 
  27. F6 - Next Pane 
  28. F7 - Spell check 
  29. F8 - Extend mode 
  30. F9 - Recalculate all workbooks 
  31. F10 - Activate Menubar 
  32. F11 - New Chart 
  33. F12 - Save As 
  34. Ctrl+: - Insert Current Time 
  35. Ctrl+; - Insert Current Date 
  36. Ctrl+" - Copy Value from Cell Above 
  37. Ctrl+’ - Copy Formula from Cell Above 
  38. Shift - Hold down shift for additional functions in Excel’s menu 
  39. Shift+F1 - What’s This? 
  40. Shift+F2 - Edit cell comment 
  41. Shift+F3 - Paste function into formula 
  42. Shift+F4 - Find Next 
  43. Shift+F5 - Find 
  44. Shift+F6 - Previous Pane 
  45. Shift+F8 - Add to selection 
  46. Shift+F9 - Calculate active worksheet 
  47. Shift+F10 - Display shortcut menu 
  48. Shift+F11 - New worksheet 
  49. Shift+F12 - Save 
  50. Ctrl+F3 - Define name 
  51. Ctrl+F4 - Close 
  52. Ctrl+F5 - XL, Restore window size 
  53. Ctrl+F6 - Next workbook window 
  54. Shift+Ctrl+F6 - Previous workbook window 
  55. Ctrl+F7 - Move window 
  56. Ctrl+F8 - Resize window 
  57. Ctrl+F9 - Minimize workbook 
  58. Ctrl+F10 - Maximize or restore window 
  59. Ctrl+F11 - Inset 4.0 Macro sheet 
  60. Ctrl+F1 - File Open 
  61. Alt+F1 - Insert Chart 
  62. Alt+F2 - Save As 
  63. Alt+F4 - Exit 
  64. Alt+F8 - Macro dialog box 
  65. Alt+F11 - Visual Basic Editor 
  66. Ctrl+Shift+F3 - Create name by using names of row and column labels 
  67. Ctrl+Shift+F6 - Previous Window 
  68. Ctrl+Shift+F12 - Print 
  69. Alt+Shift+F1 - New worksheet 
  70. Alt+Shift+F2 - Save 
  71. Alt+= - AutoSum 
  72. Ctrl+` - Toggle Value/Formula display 
  73. Ctrl+Shift+A - Insert argument names into formula 
  74. Alt+Down arrow - Displayy AutoComplete list 
  75. Alt+’ - Format Style dialog box 
  76. Ctrl+Shift+~ - General format 
  77. Ctrl+Shift+! - Comma format 
  78. Ctrl+Shift+@ - Time format 
  79. Ctrl+Shift+# - Date format 
  80. Ctrl+Shift+$ - Currency format 
  81. Ctrl+Shift+% - Percent format 
  82. Ctrl+Shift+^ - Exponential format 
  83. Ctrl+Shift+& - Place outline border around selected cells 
  84. Ctrl+Shift+_ - Remove outline border 
  85. Ctrl+Shift+* - Select current region 
  86. Ctrl++ - Insert 
  87. Ctrl+- - Delete 
  88. Ctrl+1 - Format cells dialog box 
  89. Ctrl+2 - Bold 
  90. Ctrl+3 - Italic 
  91. Ctrl+4 - Underline 
  92. Ctrl+5 - Strikethrough 
  93. Ctrl+6 - Show/Hide objects 
  94. Ctrl+7 - Show/Hide Standard toolbar 
  95. Ctrl+8 - Toggle Outline symbols 
  96. Ctrl+9 - Hide rows 
  97. Ctrl+0 - Hide columns 
  98. Ctrl+Shift+( - Unhide rows 
  99. Ctrl+Shift+) - Unhide columns 
  100. Alt or F10 - Activate the menu 
  101. Ctrl+Tab - In toolbar: next toolbar 
  102. Shift+Ctrl+Tab - In toolbar: previous toolbar 
  103. Ctrl+Tab - In a workbook: activate next workbook  
  104. Shift+Ctrl+Tab - In a workbook: activate previous workbook 
  105. Tab - Next tool 
  106. Shift+Tab - Previous tool 
  107. Enter - Do the command 
  108. Shift+Ctrl+F - Font Drop Down List 
  109. Shift+Ctrl+F+F - Font tab of Format Cell Dialog box 
  110. Shift+Ctrl+P - Point size Drop Down List

No comments:

Post a Comment

Handsome Man In Hotel With Boss

A handsome man went into a hotel and asked to see the boss. When the boss came, the story began. The client : Is room 39 empty? The boss:...