Back to library
Microsoft Excel

Calculate all worksheets in all open workbooks

Press F9 to recalculate all worksheets in all open workbooks.

F9

When to use it

Use when you need to force a full recalculation of all formulas across all open workbooks.

Pro tip

Combine with Shift+F9 to calculate only the active worksheet.

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

More from Microsoft Excel View all