| To | Press |
|---|---|
Recalculate formulas that have changed since the last calculation, and formulas dependent on them, in all open workbooks. If a workbook is set for automatic recalculation, you do not need to press F9 for recalculation.
| F9 |
| Recalculate formulas that have changed since the last calculation, and formulas dependent on them, in the active worksheet. | SHIFT+F9 |
| Recalculate all formulas in all open workbooks, regardless of whether they have changed since last time or not. | CTRL+ALT+F9 |
Recheck dependent formulas, and then recalculate all formulas in all open workbooks, regardless of whether they have changed since last time or not.
| CTRL+SHIFT+ALT+F9 |