Tracing Precedent and Dependent Trees with Drill-down
Right-Click (on Windows) or Shift-Click (on Mac) on an expression that is a range reference or source reference loads the contents of that reference into Explorer Pro.
For example, right-clicking the TaxFilter reference drills down to A17 and loads its formula into Explorer Pro.
You can drill-down using right click/shift click in both Precedent and Expression modes.
Right-click/Shift-Click does not change the Home cell and you can always go back to the home cell using the Home button (Alt-H).
When drilling down a chain of precedents you can move forwards and backwards in the chain using the Back and Forward buttons on the Explorer Pro form.
|