If you find excel freezes on you, this might just be the life hack you need!
Also take a note of the different hotkeys used for Calculating Manually:
F9 = Calculates all formulas in all workbooks who's references have been changed
Shift + F9 = Calculates formulas in the active worksheet who's references have been changed
Ctrl + Alt + F9 = Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
#excel #exceltips