Full transparency of inner working of model with Inspect formulas! Decomposition of formulas into individual elements Tree-like structure to navigate formulas and dependencies Intelligent cell naming based on row and column headers Add cell watches to the model to keep track of critical values Realtime model editing and navigation
Select a cell with a formula you wish to inspectClick ‘Inspect formulas’ See all dependent cells for the currently selected cell in a tree structure Use the ‘Inspect formula’ panel to drill down on the selected formula. Double click to navigate to cells. See description for the currently selected formula Add Watches to the workbook by right clicking on a cell and press ‘Add to watches’ Was this article helpful?
