Microsoft Excel
Check dependent formulas and calculate all cells in all open workbooks
Forces a complete recalculation of all formulas in all open workbooks, including those that depend on other cells.
Ctrl
+
Alt
+
Shift
+
F9
When to use it
Use when you need to ensure all formulas are up-to-date after making changes to dependent cells or external references.
Pro tip
This shortcut recalculates everything, which can be slow on large workbooks. Use F9 for active sheet only or Shift+F9 for current sheet.
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
PrtSc
Scroll
Pause
`
~
1
!
2
@
3
#
4
$
5
%
6
^
7
&
8
*
9
(
0
)
-
_
=
+
⌫
Ins
Home
PgUp
Tab
Q
W
E
R
T
Y
U
I
O
P
[
{
]
}
\
|
Del
End
PgDn
Caps
A
S
D
F
G
H
J
K
L
;
:
'
"
Enter
Shift
Z
X
C
V
B
N
M
,
<
.
>
/
?
Shift
↑
Ctrl
Win
Alt
Space
Fn
Alt
Ctrl
←
↓
→