Microsoft Excel
Force Recalculate All Worksheets
Forces a full recalculation of all worksheets in every open workbook, ignoring the 'changed since last calculation' flag.
Ctrl
+
Alt
+
F9
When to use it
Use when you suspect formulas are not updating correctly or when you need to ensure all dependent cells are recalculated.
Pro tip
This shortcut is more thorough than F9 (calculate active sheet) or Shift+F9 (calculate active workbook).
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
←
↓
→