banner_ad

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.


CCI Pro

Comments


Related Articles


Loading


Popular Articles





CCI Pro
Meet our CAclubindia PRO Members


CCI Articles

submit article


Company
29 May 2026
Company Secretary - Part time

Shaswat initial support private limited

Ahmedabad

CS

View Details
Company
22 May 2026
Sr. Financial Analyst - Consolidation

Search Synergy

Mumbai

CA

View Details
Company
Featured 26 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
04 June 2026
Semi Qualified CA

Goyal Puneet & Associates

New Delhi

CA Final

View Details
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
ARTICLESHIP 15 May 2026
ARTICLE ASSISTANT, TRAINEE AND PAID ASSISTANT

YOGESH KAPOOR AND ASSOCIATES

New Delhi

B.Com

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details