Templates Services SQL Reports Excel Shortcuts Blog About Contact
⌨ Excel Shortcut Guide

Recalculate all formulas Shortcut in Excel

Use this quick reference to learn the Windows shortcut, Mac shortcut, Ribbon path, and best use case for recalculate all formulas in Excel.

Shortcut keys

WindowsF9
MacF9

Ribbon path

Formulas → Calculate Now

What it does

Forces Excel to recalculate all formulas in the workbook. Useful when automatic calculation is turned off.

How to use this shortcut

  1. Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
  2. Press the shortcut keys shown above for your platform.
  3. Confirm any dialog options if Excel opens a menu or prompt.

FAQ

What is the Excel shortcut for recalculate all formulas?

On Windows, use F9. On Mac, use F9.

Where is recalculate all formulas in the Excel Ribbon?

The Ribbon path is Formulas → Calculate Now.

What does recalculate all formulas do in Excel?

Forces Excel to recalculate all formulas in the workbook. Useful when automatic calculation is turned off.