Easy Office
LCI Learning

75 Excel Home Ribbon Shortcuts

Swathi Reddy , Last updated: 10 August 2023  
  Share


Let's learn some Excel Home Ribbon shortcuts to make our work faster. All the shortcuts listed below start with Alt + H.

75 Excel Home Ribbon Shortcuts

Some of the bold letters are like an acronym of what they can do. It's easy to remember that way.

  1. Alt + H - Home
  2. Alt + H + C - Copy
  3. Alt + H + X - Cut
  4. Alt + H + V - Paste
  5. Alt + E + S - Paste Special
  6. Alt + E + S + V - Paste Special (Values)
  7. Alt + E + S + F - Paste Special (Formulas)
  8. Alt + H + FP - Format Painter
  9. Alt + H + B - Borders
  10. Alt + H + BN - No Border
  11. Alt + H + BO - Bottom Border
  12. Alt + H + BP - Top Border
  13. Alt + H + BL - Left Border
  14. Alt + H + BR - Right Border
  15. Alt + H + BA - All Borders
  16. Alt + H + BT - Thick Outside Borders
  17. Alt + H + BB - Bottom Double Border
  18. Alt + H + H - Fill color
  19. Alt + H + H + N - No Fill
  20. Alt + H + FC - Change Font Color
  21. Alt + H + F - Font
  22. Alt + H + FS - Font Size
  23. Alt + H + FG - Increase Font Size
  24. Alt + H + FK - Decrease Font Size
  25. Alt + H + AR - Align Right
  26. Alt + H + AC - Align Centre
  27. Alt + H + AL - Align Left
  28. Alt + H + AT - Align Top
  29. Alt + H + AM - Align Middle
  30. Alt + H + AB - Align Bottom
  31. Alt + H + 5 - To increase Indent
  32. Alt + H + 6 - To decrease Indent
  33. Alt + H + FQ - To change orientation
  34. Alt + H + W - Wrap text/Unwrap text
  35. Alt H + MC - Merge & Centre
  36. Alt + H + MA - Merge Across
  37. Alt + H + MM - Merge Cells
  38. Alt + H + MU - Unmerge Cells
  39. Alt + H + AN - Accounting Number Format
  40. Alt + H + P - Percentage
  41. Alt + H + K - Comma
  42. Alt + H + 0 - Increase Decimal
  43. Alt + H + 9 - Decrease Decimal
  44. Alt + H + L - Conditional Formatting
  45. Alt + H + LH - Conditional Formatting Highlight Cells Rules
  46. Alt + H + LT - Top/Bottom Rules
  47. Alt + H + LN - New Rules
  48. Alt + H + LD - Data Bars
  49. Alt + H + LS - Color Scales
  50. Alt + H + LI - Icon Sets
  51. Alt + H + LC - Clear Rules
  52. Alt + H + LR - Manage Rules
  53. Alt + H + L + HD - Duplicate Values
  54. Alt + H + T - Format as Table
  55. Alt + H + J - Cell styles
  56. Alt + H + II - Insert cells
  57. Alt + H + IR - Insert Sheet Rows
  58. Alt + H + IC - Insert Sheet Columns
  59. Alt + H + IS - Insert Sheet
  60. Alt + H + DD - Delete cells
  61. Alt + H + DR - Delete Sheet Rows
  62. Alt + H + DC - Delete Sheet Columns
  63. Alt + H + DS - Delete Sheet
  64. Alt + H + O - Format
  65. Alt + H + OR - Rename Sheet
  66. Alt + H + OH - Row Height
  67. Alt + H + OW - Column Width
  68. Alt + H + OT - Tab Color
  69. Alt + H + E - Clear
  70. Alt + H + EA - Clear All
  71. Alt + H + S - Sort & Filter
  72. Alt + H + SS - Sort by A to Z
  73. Alt + H + SO - Sort by Z to A
  74. Alt + H + U - AutoSum
  75. Alt + H + FI - Fill
 
 
Join CCI Pro

8 Likes   6420 Views

Comments


Related Articles


Loading