Let's learn some cool Alt Excel shortcuts

50 Excel Shortcuts with Alt Key
  1. Alt + A - To go to the Data tab on the Ribbon
  2. Alt + A + G + G - Group cells
  3. Alt + A + U + U - Ungroup cells
  4. Alt + A + W - What if Analysis
  5. Alt + A + W + G - Goal Seek
  6. Alt + A + V + V - Data Validation
  7. Alt + A + M - Remove duplicates
  8. Alt + E + S - Paste Special
  9. Alt + E + S + F - Paste Special Formulas
  10. Alt + E + S + V - Paste Special Values
  11. Alt + H - To access the Home tab on the Ribbon
  12. Alt + F - To access to the File tab on the Ribbon
  13. Alt + P - To access to the Page Layout tab on the Ribbon
  14. Alt + JI - To access the Draw tab on the Ribbon
  15. Alt + R - To access the Review tab on the Ribbon
  16. Alt + Q - To go to the Search bar
  17. Alt + N - To access the Insert tab on the Ribbon
  18. Alt + N + R - Recommended charts
  19. Alt + N + V + T - Creates Pivot Table
  20. Alt + N + T - To create Table
  21. Alt + N + Q - To Insert Pie chart
  22. Alt + N + C1 - To Insert Column or Bar chart
  23. Alt + N + N1 - To insert Line or Area Chart
  24. Alt + N + I2 - To insert Hyperlink
  25. Alt + W - To access the View tab on the Ribbon
  26. Alt + W + L - Normal Page View
  27. Alt + W + I - Page Break Preview
  28. Alt + W + P - Page Layout
  29. Alt + W + VG - To show/hide the Gridlines
  30. Alt + W + W - To Switch windows
  31. Alt + L - To go to the Developer tab
  32. Alt + L + R - To Record Macros
  33. Alt + L + PM - To View Macros
  34. Alt + M - To access to the Formulas tab on the Ribbon
  35. Alt + M + D - To Trace Dependents
  36. Alt + M + P - To Trace Precedents
  37. Alt + M + A - Remove Arrows
  38. Alt + M + A + P - To Remove Precedent Arrows
  39. Alt + M + A + D - To Remove Dependent Arrows
  40. Alt + M + H - To show Formulas
  41. Alt + M + U + S - AutoSum
  42. Alt + = - Sum Function
  43. Alt + M + U + A - Average Function
  44. Alt + M + U + C - Count Numbers
  45. Alt + M + U + M - Maximum Function
  46. Alt + M + U + I - Minimum Function
  47. Alt + M + I - Financial Functions
  48. Alt + M + L - Logical Functions
  49. Alt + M + T - Text Functions
  50. Alt + M + O - Lookup and Reference Functions
 
 



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


Company
ARTICLESHIP 24 June 2026
CA Article Trainee

Rahul Dang & Associates

Pune

CA Inter

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
25 June 2026
AUDIT MANAGER

JDAS & ASSOCIATES

New Delhi

CA

View Details
Company
ARTICLESHIP 28 June 2026
Article Assistant

Sharma Chetan And Company

Gurgaon

CA Inter

View Details
Company
14 July 2026
Senior Executive/ Manager

H S SHARMA AND CO

Pune

CA Final

View Details
Company
Featured 16 July 2026
Semi Qualified Company Secretary

Vakilsearch.com

Chennai

CS

View Details
Company
ARTICLESHIP 11 July 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
21 July 2026
Chartered Accountant

Keshri & Associates

Thiruvananthapuram

CA

View Details