15 Excel Shortcuts for Data Analysis

1. Select current data region → Ctrl + *
2. Turn filter on or off → Ctrl + Shift + L
3. Open PivotTable dialog → Alt + N, V
4. Refresh PivotTable → Alt + F5
5. Insert PivotTable from ribbon → Alt + N, V, T
6. Fill right → Ctrl + R
7. Copy formula down → Ctrl + D
8. Show formulas → Ctrl + `
9. Calculate active sheet → Shift + F9
10. Calculate all sheets → F9
11. Create chart → Alt + F1
12. Create chart on new sheet → F11
13. Group rows or columns → Alt + Shift + →
14. Ungroup rows or columns → Alt + Shift + ←
15. Toggle outline symbols → Ctrl + 8

Double Tap ♥️ For More