75 Excel Home Ribbon Shortcuts



Quick Summary
This guide provides a comprehensive list of Excel shortcuts specifically for the Home Ribbon, all starting with the Alt + H combination. These shortcuts are designed to significantly speed up your workflow by offering quick access to common functions like copying, pasting, formatting, alignment, and cell manipulation. By learning these key combinations, you can become much more efficient when working with spreadsheets.

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

Excel Home Ribbon Shortcuts: Boost Your Speed

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
 
 

FAQ :

The main shortcut to access the Excel Home Ribbon is Alt + H.

You can copy using Alt + H + C and paste using Alt + H + V.

To apply borders, you can use Alt + H + B. Specific borders include No Border (Alt + H + BN), Bottom Border (Alt + H + BO), Top Border (Alt + H + BP), Left Border (Alt + H + BL), Right Border (Alt + H + BR), and All Borders (Alt + H + BA).

To change font colour, use Alt + H + FC. For fill colour, use Alt + H + H, and to remove fill, use Alt + H + H + N.

You can align text using shortcuts like Align Right (Alt + H + AR), Align Centre (Alt + H + AC), Align Left (Alt + H + AL), Align Top (Alt + H + AT), Align Middle (Alt + H + AM), and Align Bottom (Alt + H + AB).

To insert sheet rows, use Alt + H + IR, and for columns, use Alt + H + IC. To delete sheet rows, use Alt + H + DR, and for columns, use Alt + H + DC.




About the Author

EL

I am a Chartered Accountant and a Company Secretary Professional, currently employed in a multinational corporation. Additionally, I operate a blog titled investorsbuck.com, with the aim of simplifying finance.


Related Articles


Loading


Popular Articles





CCI Pro

CCI Articles

submit article


Follow