Shift+F9: Calculate in active worksheet

Yesterday we learned about the F9 key and how it calculates formulas manually if you’ve switched off automatic calculation (which you’d only do if you’re working with a big spreadsheet that has lots of formulas).

The technical definition of what F9 does, per Excel, is:

Calculates formulas that have changed since the last calculation, and formulas dependent on them, in all open workbooks.

Sometimes you don’t want to recalculate in all open workbooks. Perhaps, instead, you only want to recalculate the formulas in the sheet that you’re currently working with (because you don’t want to wait for all the other worksheets to get recalculated as well). If so, then press Shift+F9.

Here’s the technical definition of Shift+F9’s functionality:

Calculates formulas that have changed since the last calculation, and formulas dependent on them, in the active worksheet.

Leave a Reply

Your email address will not be published. Required fields are marked *