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

Become or hire the top 3% of the developers on Toptal https://topt.al/25cXVn

--

Music by Eric Matyas
https://www.soundimage.org
Track title: RPG Blues Looping

--

Chapters
00:00 Question
00:46 Accepted answer (Score 85)
01:44 Answer 2 (Score 1)
02:02 Thank you

--

Full question
https://superuser.com/questions/448376/w...

Question links:
[this page]: http://dmcritchie.mvps.org/excel/shortx2...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#microsoftexcel #worksheetfunction #hotkeys

#avk47

ACCEPTED ANSWER

Score 88

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.

ANSWER 2

Score 1

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...