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

Follow us
add to google news

CCI Articles

submit article


Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details