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 the last recalculation. | Ctrl+Alt+F9 |
Check dependent formulas, and then recalculate all formulas in all open workbooks, regardless of whether they have changed since the last recalculation. | Ctrl+Shift+Alt+F9 |
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.