AppGarden Selection-Scoped Formula Explainer logo AppGarden

Selection-Scoped Formula Explainer

What does this Excel™ formula do? How to read a long one step by step

By Paul Kemp · Published

You inherit a workbook, click a cell and see a formula that runs across the formula bar. Before you change anything, you need to know what it does.

Read from the inside out

Nested formulas evaluate innermost first. Reading them the same way turns one wall of text into a few small steps.

By hand

These steps apply to Excel™ in Microsoft 365.

  1. Click the cell and read the formula bar. Expand the bar with the arrow at its right if it is cut off.
  2. Choose Formulas → Evaluate Formula and press Evaluate repeatedly. Excel™ underlines the next part to be computed and replaces it with its result.
  3. Alternatively, select part of the formula in the formula bar and press F9 to see its value. Press Escape afterwards so you do not leave the value in the formula.
  4. Choose Formulas → Trace Precedents to draw arrows to the cells it reads.
  5. For names, open Formulas → Name Manager (Ctrl+F3) to see what each one refers to.
  6. Write a plain sentence for each step in a note beside the cell: "looks up the price for this code, multiplies by quantity, adds the uplift".

Watch for typed numbers in the middle of a formula. A rate buried in a formula is the commonest surprise.

Have it written out for you

Selection-Scoped Formula Explainer explains the selected cell's formula in the workbook's own words, using real column headers, defined names and live values. It shows the formula step by step (innermost first), lists what it reads, flags typed-in values and shows what each function does. It is built from a parser and fixed templates, so the same formula always gets the same explanation, and your formulas never leave the machine. Explaining any cell is free and unlimited.

See Selection-Scoped Formula Explainer for Excel™

Microsoft, Excel and Microsoft 365 are trademarks of the Microsoft group of companies. Selection-Scoped Formula Explainer is not affiliated with or endorsed by Microsoft.