100 SHORTCUT KEYS FOR EXCEL

Hello Friends,

This is Amey Kulkarni

In this Blog I will Share 100 Keyboard Short cut key for you. I will share the My Channel in last.

So Let's begin...

  1. CTRL + A – To Select all the content in a workbook 
  2. CTRL + B – To Turn highlighted cell Bold 
  3. CTRL + C – To Copy cells that are highlighted 
  4. CTRL + D – To Fill the selected cell with the content of the cell right above 
  5. CTRL + E – To Flash fill the current Column 
  6. CRTL + F – To Search for anything in a workbook 
  7. CTRL + G – To Jump to a certain area with a single command 
  8. CTRL + H – To Find and Replace cell contents 
  9. CTRL + I – To Turn highlighted cell Italic 
  10. CTRL + K – To Insert a hyperlink in a cell 
  11. CTRL + L – To Open the create table dialog box 
  12. CTRL + N – To Create a new workbook 
  13. CTRL + O - To Open a saved workbook 
  14. CTRL + P – To Print a workbook 
  15. CTRL + R – To Fill the selected cell with the content of the cell on the left 
  16. CTRL + S – To Save a workbook 
  17. CTRL + T – To Crete a table in workbook 
  18. CTRL + U – To Underline highlighted cell 
  19. CTRL + V – To Paste anything that is copied 
  20. CTRL + W – To Close current workbook 
  21. CTRL + X – To Cut anything that is selected 
  22. CTRL + Y – To Redo any undo thing 
  23. CTRL + Z – To Undo any changes made in spreadsheet 
  24. CTRL + 1 – To Format the cell contents 
  25. CTRL + 2 – To Turn highlighted cell Bold 
  26. CTRL + 3 – To Turn highlighted cell Italic 
  27. CTRL + 4 – To Underline highlighted cell 
  28. CTRL + 5 – To Put strikethrough in a cell 
  29. CTRL + 6 – Hides and shows hidden objects 
  30. CTRL + 8 – To Show the outline symbols. 
  31. CTRL + 9 – To Hide a row 
  32. CTRL + 0 – To Hide column 
  33. CTRL +; - To Enter current date in a cell 
  34. CTRL + ` - To Change the view from displaying cell values to formulas 
  35. CTRL + (-) - To Delete column or row 
  36. CTRL + Space – To Select an entire column 
  37. CTRL + Home – To Redirect to cell A1 
  38. CTRL + End – To go to the last cell in a workbook 
  39. CTRL + Up Arrow – To Go to the topmost cell in a current column 
  40. CTRL + Down Arrow – To Go to the last cell in a current column 
  41. CTRL + Right Arrow – To Go to the last cell in a selected row 
  42. CTRL + Left Arrow – To Jump back to first cell in a selected row 
  43. CTRL + Page Up – To Move the screen towards the left 
  44. CTRL + Page Down – To Move the screen towards the right 
  45. CTRL + F1 – To Expand or collapse the ribbon 
  46. CTRL + F2 – To Open print preview window 
  47. CTRL + F4 – To Save the workbook 
  48. CTRL + F5 – To Restore down the workbook 
  49. CTRL + F9 – To Minimize the workbook 
  50. CTRL + F10 – To Restore up the workbook 
  51. CTRL + F11 – To Add a Macro enabled workbook 
  52. CTRL + F12 – To Open workbook window 
  53. CTRL + Shift +: - To Enter the current time in a cell 
  54. CTRL + Shift + (+) - To Insert column or row 
  55. CTRL + Shift + ~ - To Switch between displaying Excel formulas or their values in cell 
  56. CTRL + Shift + @ - To Apply time formatting 
  57. CTRL + Shift +! - Apply comma formatting 
  58. CTRL + Shift + $ - Apply Currency formatting 
  59. CTRL + Shift + # - Apply Date formatting 
  60. CTRL + Shift + % - Apply Percentage formatting 
  61. CTRL + Shift + & - To Place border around the selected cell 
  62. CTRL + Shift + _ – To Remove a border 
  63. CTRL + Shift + Spacebar – To Select an entire workbook 
  64. CTRL + Shift + Tab – To Switch to the previous workbook 
  65. CTRL + Shift + F – To Open the font menu under format cells 
  66. CTRL + Shift + O – To Select the cells containing comments 
  67. CTRL + Shift + F3 – To Create names from values in rows and column  
  68. CTRL + Alt + F9 – To Force calculate all workbooks 
  69. CTRL + Alt + = - Zoom in 
  70. CTRL + Alt + (-) - Zoom Out 
  71. ALT – To Open the access keys 
  72. Alt + F + T – To Open the options 
  73. Alt + Down Arrow – To Activate filters for cells 
  74. Alt + H + H – To Select a fill color 
  75. Alt + H + B – To Select a border menu 
  76. Alt + H + I + S – To Add a sheet 
  77. Alt + H + D + S – To Delete a sheet 
  78. Alt + H + O + R – To Rename a sheet 
  79. Alt + H + O + U + S – To Hide a sheet 
  80. Alt + H + O + U + H – To Unhide a sheet 
  81. Alt + H + O + I – Auto Format column width 
  82. Alt + H + O + A – Auto Format row height 
  83. Alt + H + FC – Format Font color 
  84. Alt + H + FF – Format Actual font 
  85. Alt + H + 0 – Increase Decimals display in number 
  86. Alt + H + 9 – Decrease Decimals display in number 
  87. Alt + H + E + F – Clear Cell for all formatting 
  88. Alt + H + E + A – Clear cell for all contents 
  89. Alt + H + FD + S – Go to Special 
  90. Alt + N + V – Insert Pivot table 
  91. Alt + N + C – Insert column chart 
  92. Alt + P + R + S – Set Print area 
  93. Alt + M + D – Formula auditing, trace dependents of your formula 
  94. Alt + M + A – Formula auditing, clears the arrows of your formula audit 
  95. Alt + A + E + F – Text to Column 
  96. Alt + R + S – Check Spelling 
  97. Alt + W + V + G – View and Hide gridlines 
  98. Alt + W + F + F – Freeze and Unfreeze panes 
  99. Shift + F11 – To Insert sheet left to current sheet 
  100. Alt + Enter – To Start a new line in same cell. 

Comments

Post a Comment

If you have any doubts, please let me know in comment below

Popular Posts