Look inside formulas with FormulaView

FormulaView Window

FormulaView – multiple views of the formula with synchronized highlighting (blue) and interim values (red) for each subexpression

Text View – the formula as it appears in Excel’s Formula Bar

Math View – a typographical view to aid recognition

Click here to see a Math View of your formula.

Tree View – a structural view to

organize subexpressions

display interim values

expand and collapse subexpressions

Synchronized views help you see the structure of your formula and allow you to concentrate on portions of particular interest. Coordinated highlighting links subexpressions among the views. FormulaView lets you substitute ellipses (…) or values for collapsed subexpressions to further simplify the display.

FormulaView reduces errors in Excel® spreadsheets

Get FormulaView