Ctrl+Alt+F9: Calculate all formulas

To continue the theme from yesterday and Monday, there’s another recalculate option — mostly useful if you have a spreadsheet that seems to have been corrupted and you want to check all the formulas. Press Ctrl+Alt+F9 to do the following:

Calculates all formulas in all open workbooks, regardless of whether they have changed since last time or not.

Leave a Reply

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