Exceljet

Quick, clean, and to the point

Force calculate all worksheets

Windows shortcut 
CtrlAltF9

This shortcut will force calculation in all worksheets in all open workbooks even when cells have not been changed. We aren't aware of a keyboard shortcut to do this on the Mac. If you know of one, please let us know.

I watched a few videos this morning and learned one key thing that will save me hours at work!
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course