15 Excel Formula Shortcuts You Must Know

1. Start a formula →Type =
2. Insert function dialog → Shift + F3
3. AutoSum selected cells → Alt + =
4. Toggle absolute reference → F4
5. Edit formula in cell → F2
6. Accept formula and move down → Enter
7. Accept formula and move right → Tab
8. Insert line break in formula bar → Alt + Enter
9. Select formula range → Shift + Arrow keys
10. Copy formula down → Ctrl + D
11. Copy formula right → Ctrl + R
12. Show all formulas → Ctrl + `
13. Calculate active sheet → Shift + F9
14. Calculate all workbooks → Ctrl + Alt + F9
15. Recalculate formulas manually → F9

Double Tap ♥️ For More