In Easy Steps Articles

August 14, 2021

Did you know you can use the Evaluate command in Excel to run a formula one step at a time to see how it operates?

To use this feature:

1) Select the cell with the formula you wish to investigate.

2) Select Formulas and click Evaluate Formula in the Formula Auditing group.

The formula displays with the first step underlined.

3) Press Evaluate repeatedly, to run the calculation forwards, a step at a time. The expressions in the formula are calculated, one by one in turn. You can view the intermediate values as they are displayed.

Find out more tips like this in Excel Functions & Formulas in easy steps.


192 pages
By Michael Price
ISBN: 97818404788815

Sign up to our


Our newsletters inform you of new and forthcoming titles, handy tips, and other updates and special offers. You can opt out anytime.

"*" indicates required fields

By In Easy Steps Team