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

- Click ‘Visualize formulas in selected sheets’
- 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
Was this article helpful?