Formula Explorer Pro Overview
Explorer Pro combines and extends Excel’s Evaluate Formula and Trace Precedents tools to give you improved ways of viewing, validating, editing and debugging formulas:
Modeless and resizable Form – select and modify cells whilst Explorer Pro is showing
Explore Cell formulas, Conditional Format Formulas, Data Validation Formulas and Named Formulas
Forwards and Backwards debug using your arrow keys
View, filter and select the results of array expressions and ranges in both Normal and Debug modes.
Toggle between Expressions, Precedents and Dependents view
oPrecedents include INDIRECT, OFFSET, INDEX and source cells
oClick a reference or function to select its precedents both within and across worksheets.
oSee which precedents are formulas.
oDependents view shows the formulas in the dependent cells
oDrilldown from references to their formulas using right-click (Windows) or Shift-Click (Mac)
Show the source cells that functions like VLOOKUP, SUMIFS, MAX etc. are pulling from
See the results of individual criteria’s in SUMIFS, COUNTIFS etc.
Show the result of IF, CHOOSE, IFS, SWITCH functions
Show filtered results from the arguments of functions like SUMPRODUCT
Indented formula view shows how the parts of your formula fit together, simplifies bracket forests
Auto-scroll to show selected cells
Show formulas and functions in English or local language.
Contract/expand the Treeview of sub-expressions and results
Extensive keyboard shortcuts
Highly customisable user interface
Handles Dynamic Arrays, Linked Data Types, Structured References, 3D references, Named Ranges, Dynamic Ranges, Intersect, Union, Complex References, Whole Column ranges, Used-Range intersection, Constant Arrays and more.
Use the Tooltips, Online help and PDF User guide for a fast understanding of Explorer Pro
Clicking this button on the FastExcel Manager Ribbon, or using Control-Shift-M will launch Explorer Pro for the formula in the active cell.
The Explorer Pro Userform The explorer form is modeless and resizable. Because the form is modeless you can interact with the workbook in all the usual ways with the mouse and keyboard whilst keeping the form visible, and switch the focus between the worksheet and the form by clicking with the mouse.
The Indented Formula, Array Results, Expressions /Precedents and Source/Reference Boxes show views of the formula and its results.
The Array Results Box and the Array Results Filter only show when the Filter button is toggled on and the selected expression results in an array of values.
Drag a splitter bar to change the amount of space used by the 4 display boxes within the overall form, or drag the resize button to change the size of the form
Explorer Pro Command Buttons
The command buttons give easy access to common tasks. Formula Explorer also has a large number of keyboard shortcuts.
|