Instantly understand and troubleshoot complex Excel formulas
The horizontal view displays the result of each part of a formula in order to see how the result is calculated. You can also expand and collapse the formula parts by clicking the green result bar.
The vertical view displays a formula as a tree of the parts of a formula. The parts can be expanded and collapsed.
Excel tells you when a formula has an error, but that’s it. Long formulas are even worse...where do you even start to track down the problem?
Now, FormulaSpy will pinpoint EXACTLY where the error is – no more guessing or wasting hours of your precious time.
Explore the cells that the formula uses, visit them and see their formulas, then drill into their references to gain a deep understanding of the entire calculation chain.
Live editor with instant feedback.
Format the formula at any time by clicking the 'Format'' button. This will auto-indent the formula to make it easier to read.
As you edit the formula, the border will turn green or red to indicate whether the formula is valid or not, making it very easy to check your formula for completeness.
Click the 'Focus' button to syntax highlight only the formula that contains the cursor - color all other parts of the formula a light gray. This makes it easier to see which part of a fromula you're working on.
Workbook Detective finds issues quickly. All errors, comments, external links, data connections and invalid data…all in one place…in a treeview that is easy to navigate.
Style Explorer shows exactly what styles are being used (and abused) and where they are hiding.
The Style Map visually shows where a style is being used, so that you can easily look at the pattern to decide if anything is wrong or unexpected.
Styles are listed as well as all of their variations, where the style has been applied but the formatting has been altered slightly afterwards, so the cell is no longer using a ‘pure’ version of the style.
When you click on a style or one of its variants then Style Explorer will list the cells that are using it. Clicking on a style, or one the cells that are using it, will select the range in Excel.
Select cells that contain the styles you want, then find all instances other other styles - the ones you don't want. Alternatively, select some cells that contain styles that you want to find, then find all instances of these selected styles anywhere in your workbook.
Lambda functions allow you to create new functions without VBA. Now, FormulaSpy enables you to create these new custom functions by using your existing formulas as templates.
Convert an existing formula into a custom function by clicking on the parts that you want to convert into variables.
Find and rewrite and rewrite and update formulas that can be enhanced to use the new custom function....with just a few clicks.
Excel 365, 2019, 2016, 2013 (Windows Desktop only)