Recheck dependent formulas and calculate all cells in all open workbooks
Master this Excel shortcut with our comprehensive guide
Excel Formula-Related Shortcuts
Ctrl + Alt + Shift + F9
⌘ + Option + Shift + F9
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Alt + Shift + F9
Instructions
1. Press Ctrl + Alt + Shift + F9
2. Forces recalculation of all formulas, including dependent ones, across all open workbooks
2. Forces recalculation of all formulas, including dependent ones, across all open workbooks
Keyboard Shortcut
⌘ + Option + Shift + F9
Instructions
1. Press Command + Option + Shift + F9
2. Recalculates all formulas in all open workbooks
2. Recalculates all formulas in all open workbooks
💡 Pro Tip: Use when complex formulas aren't updating automatically or after changing calculation options.
Quick Actions
More Excel Formula-Related Shortcuts
Alt + =
Ctrl + Shift + U