Explorer Pro Precedents

Working with Precedents

Explorer Pro shows 3 different kinds of precedents:

Direct References showing in the formula.

Source References showing the cells that an expression or function (INDIRECT, SUMIFS, VLOOKUP …) is actually pulling from. Source References are shown in Green in the Source Result Box

Restricted References resulting from Intersections are shown in Orange

Click the Precedents button (Alt-R) to toggle between showing Precedents and showing Expressions in the Expression TreeView and Source/result boxes. The default precedents setting is to only show unique precedents.
A precedent will be shown when either the left-hand Expression Box or the right-hand Source Box show a reference.

Left-click a precedent range to select that range on its worksheet.
Right-click (or shift-click on the Mac) drills down to the formula in the precedent range and makes it the home cell.

 When all the cells in a precedent range contain formulas a green icon is shown.

 When some of the cells in a precedent range contain formulas and some of the cells contain constant data a yellow icon is shown.
You can use the Filter button to find which cells have or do not have formulas

Copyright © 2020 Decision Models Ltd