110 shortcut keys used in ms excel | Microsoft excel shortcut keys


Microsoft Excel Shortcut Keys


Complete List of MS Excel Shortcut Key



  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 - Goto
  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 - Strike through
  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

Share this

Related Posts

Previous
Next Post »