15 Excel Formula Tricks & Shortcuts

1. Insert SUM function → Alt + =


2. Insert IF function quickly → Type =IF( and press Tab


3. Insert VLOOKUP / XLOOKUP → Type function name + Tab


4. Toggle between relative/absolute refs → F4


5. Select entire formula → Ctrl + Shift + U


6. Expand or collapse formula bar → Ctrl + Shift + U


7. Paste formula only → Ctrl + Alt + V, F


8. Paste values only → Ctrl + Alt + V, V


9. Calculate selected cells only → Shift + F9


10. Trace precedents → Ctrl + [


11. Trace dependents → Ctrl + ]


12. Remove arrows → Alt + M, A, A


13. Evaluate formula step-by-step → Alt + M, V


14. Insert array formula (legacy) → Ctrl + Shift + Enter


15. Repeat last formula action → F4


Double tap ♥️ if this helped you