FormulaDesk FormulaSpy 1.38

FormulaDesk FormulaSpy is an Excel add-on that makes Excel formulas easy to understand, easy to test, easy to troubleshoot, and easy to repair. It provides a horizontal view that shows the results of each part of the formula to see how the results are calculated. You can also expand and collapse formula sections by clicking the green results bar. Additionally, you can use FormulaSpy to discover the cells the formula uses, access those cells and view their formulas, then dig deeper into their references to gain a deeper understanding of the formula. entire calculation chain.

Features of FormulaSpy

• See all your sheets at once, in a multi-line display
• Drag the pane to display as many or as few rows of worksheet tabs as you want.
• Displays worksheet tabs along the bottom or top of the Excel window.
• Vertical tabs are great for presentations.
• Sheet filtering and sorting tab.
• Define custom tags to filter displayed worksheets.
• Live editor with instant feedback.
• Format the formula at any time by clicking the 'Format' button.
• Horizontal view shows the results of each part of the formula to see how the results are calculated
• Vertical view shows the formula as a tree of formula parts.
• Create custom functions (Lambda) from existing formulas.
• Convert existing formulas into custom functions by clicking the parts you want to convert into variables.
• Find, rewrite, and update formulas that can be enhanced to use new custom functions....in just a few clicks.