Toggle formula visualization to easily audit worksheet

  • Easily discover model inconsistencies and potential errors using patters
  • Overview of dragged/copied formulas
  • Clear indication of where constants are used in formulas
  • Significant time reduction by only auditing cells with unique formulas

  1. Click ‘Visualize formulas in selected sheets’
  2. Use patterns to identify inconsistencies in formulas

  • Cross-hatches represent partial inputs.
  • Horizontal patterns represent unique formulas dragged horizontally
  • Vertical patterns represent unique formulas dragged vertically
  • Square patterns represent formulas dragged horizontally and vertically
Try free