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 |
-