Let's learn some Excel Home Ribbon shortcuts to make our work faster. All the shortcuts listed below start with Alt + H.
Some of the bold letters are like an acronym of what they can do. It's easy to remember that way.
- Alt + H - Home
- Alt + H + C - Copy
- Alt + H + X - Cut
- Alt + H + V - Paste
- Alt + E + S - Paste Special
- Alt + E + S + V - Paste Special (Values)
- Alt + E + S + F - Paste Special (Formulas)
- Alt + H + FP - Format Painter
- Alt + H + B - Borders
- Alt + H + BN - No Border
- Alt + H + BO - Bottom Border
- Alt + H + BP - Top Border
- Alt + H + BL - Left Border
- Alt + H + BR - Right Border
- Alt + H + BA - All Borders
- Alt + H + BT - Thick Outside Borders
- Alt + H + BB - Bottom Double Border
- Alt + H + H - Fill color
- Alt + H + H + N - No Fill
- Alt + H + FC - Change Font Color
- Alt + H + F - Font
- Alt + H + FS - Font Size
- Alt + H + FG - Increase Font Size
- Alt + H + FK - Decrease Font Size
- Alt + H + AR - Align Right
- Alt + H + AC - Align Centre
- Alt + H + AL - Align Left
- Alt + H + AT - Align Top
- Alt + H + AM - Align Middle
- Alt + H + AB - Align Bottom
- Alt + H + 5 - To increase Indent
- Alt + H + 6 - To decrease Indent
- Alt + H + FQ - To change orientation
- Alt + H + W - Wrap text/Unwrap text
- Alt H + MC - Merge & Centre
- Alt + H + MA - Merge Across
- Alt + H + MM - Merge Cells
- Alt + H + MU - Unmerge Cells
- Alt + H + AN - Accounting Number Format
- Alt + H + P - Percentage
- Alt + H + K - Comma
- Alt + H + 0 - Increase Decimal
- Alt + H + 9 - Decrease Decimal
- Alt + H + L - Conditional Formatting
- Alt + H + LH - Conditional Formatting Highlight Cells Rules
- Alt + H + LT - Top/Bottom Rules
- Alt + H + LN - New Rules
- Alt + H + LD - Data Bars
- Alt + H + LS - Color Scales
- Alt + H + LI - Icon Sets
- Alt + H + LC - Clear Rules
- Alt + H + LR - Manage Rules
- Alt + H + L + HD - Duplicate Values
- Alt + H + T - Format as Table
- Alt + H + J - Cell styles
- Alt + H + II - Insert cells
- Alt + H + IR - Insert Sheet Rows
- Alt + H + IC - Insert Sheet Columns
- Alt + H + IS - Insert Sheet
- Alt + H + DD - Delete cells
- Alt + H + DR - Delete Sheet Rows
- Alt + H + DC - Delete Sheet Columns
- Alt + H + DS - Delete Sheet
- Alt + H + O - Format
- Alt + H + OR - Rename Sheet
- Alt + H + OH - Row Height
- Alt + H + OW - Column Width
- Alt + H + OT - Tab Color
- Alt + H + E - Clear
- Alt + H + EA - Clear All
- Alt + H + S - Sort & Filter
- Alt + H + SS - Sort by A to Z
- Alt + H + SO - Sort by Z to A
- Alt + H + U - AutoSum
- Alt + H + FI - Fill