Let's learn some cool Alt Excel shortcuts
- Alt + A - To go to the Data tab on the Ribbon
- Alt + A + G + G - Group cells
- Alt + A + U + U - Ungroup cells
- Alt + A + W - What if Analysis
- Alt + A + W + G - Goal Seek
- Alt + A + V + V - Data Validation
- Alt + A + M - Remove duplicates
- Alt + E + S - Paste Special
- Alt + E + S + F - Paste Special Formulas
- Alt + E + S + V - Paste Special Values
- Alt + H - To access the Home tab on the Ribbon
- Alt + F - To access to the File tab on the Ribbon
- Alt + P - To access to the Page Layout tab on the Ribbon
- Alt + JI - To access the Draw tab on the Ribbon
- Alt + R - To access the Review tab on the Ribbon
- Alt + Q - To go to the Search bar
- Alt + N - To access the Insert tab on the Ribbon
- Alt + N + R - Recommended charts
- Alt + N + V + T - Creates Pivot Table
- Alt + N + T - To create Table
- Alt + N + Q - To Insert Pie chart
- Alt + N + C1 - To Insert Column or Bar chart
- Alt + N + N1 - To insert Line or Area Chart
- Alt + N + I2 - To insert Hyperlink
- Alt + W - To access the View tab on the Ribbon
- Alt + W + L - Normal Page View
- Alt + W + I - Page Break Preview
- Alt + W + P - Page Layout
- Alt + W + VG - To show/hide the Gridlines
- Alt + W + W - To Switch windows
- Alt + L - To go to the Developer tab
- Alt + L + R - To Record Macros
- Alt + L + PM - To View Macros
- Alt + M - To access to the Formulas tab on the Ribbon
- Alt + M + D - To Trace Dependents
- Alt + M + P - To Trace Precedents
- Alt + M + A - Remove Arrows
- Alt + M + A + P - To Remove Precedent Arrows
- Alt + M + A + D - To Remove Dependent Arrows
- Alt + M + H - To show Formulas
- Alt + M + U + S - AutoSum
- Alt + = - Sum Function
- Alt + M + U + A - Average Function
- Alt + M + U + C - Count Numbers
- Alt + M + U + M - Maximum Function
- Alt + M + U + I - Minimum Function
- Alt + M + I - Financial Functions
- Alt + M + L - Logical Functions
- Alt + M + T - Text Functions
- Alt + M + O - Lookup and Reference Functions
CAclubindia
