Usage¶

Understanding Formulas with FormulaChop¶

Select a cell containing a formula in the workbook, navigate to the FORMULAS tab, and click the Chop button.

The FormulaChop FormulaChop Tab will open. The colors of the ranges in the Formula section correspond to the colors in the Precedents section

Note

Because FormulaChop creates a new tab for its output, it will not work on a spreadsheet that is protected.

To see the formula broken out step-by-step, see the Step by Step section

To see the cell’s dependents, see the Dependents section

Select any value on the FormulaChop Tab in the Precedents or Dependents sections. Click the Chop button.

FormulaChop will find the value’s location in the spreadsheet, and the run on that cell.

Note

Tip

Because FormulaChop can be run on either Precedents or Dependents, following long chains of dependency across many tabs and locations is fast and easy.
This operation also works in the Cell Info section, which provides an easy way to re-run FormulaChop on the same cell.
To keep a FormulaChop FormulaChop Tab from being erased the next time FormulaChop is run, use the Save button.

Some information is hidden by default, see the FormulaChop Tab section to learn more

If FormulaChop does not run on a cell, or does something unexpected, see the FormulaChop Status Messages in the lower-left corner of Excel.