What is the Excel hotkey to re-calculate all formula in sheet?

This often happens with very large and complex spreadsheets. Here are some workarounds you could try:

• CTRL + ALT + SHIFT + F9 to recheck all formula dependencies and then recalculate all formulas.

• Select any blank cell, press F2 and then Enter.

• Re-enter = :

  • Select cells that contain formulas you'd like to update
  • Press CTRL+H.
  • Find what: =
  • Replace with: =

  This may take a while depending on the size of your workbook. Save your file before attempting.

From the settings, there is a part where you can ask excel to automatically update them once you have a new input. You don't need to press any hotkey...