Shortcut keys
WindowsAlt → M → V
MacNo direct shortcut
Ribbon path
Formulas → Evaluate Formula
What it does
Step through a formula one calculation at a time to find errors. Highlights each part of the formula as it evaluates.
How to use this shortcut
- Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
- Press the shortcut keys shown above for your platform.
- Confirm any dialog options if Excel opens a menu or prompt.
FAQ
What is the Excel shortcut for evaluate formula?
On Windows, use Alt → M → V. On Mac, use No direct shortcut.
Where is evaluate formula in the Excel Ribbon?
The Ribbon path is Formulas → Evaluate Formula.
What does evaluate formula do in Excel?
Step through a formula one calculation at a time to find errors. Highlights each part of the formula as it evaluates.