Check the ExcelAnalyzer features to see how to locate and fix all issues in just a few clicks
Highlighting Unique Formulas
ExcelAnalyzer highlights all Unique Formulas which allows the user to quickly see how the worksheet was built and makes it very simple to identify inconsistencies when formulas are different from each other.
In this example the green highlighted formulas in cells F7-G7 don’t add up all rows above and should be fixed.
Click on image to increase size
Click on image to increase size
Formulas report
ExcelAnalyzer’s Formula report lists all unique formulas and helps in detecting inconsistent formulas and it contains a link to easily navigate and correct the issues in formulas.
ExcelAnalyzer uses a colour-coding method to make each formula easier to read.
Colour-coding formulas
ExcelAnalyzer uses a colour-coding method to make each formula easier to read.
Click on image to increase size
Click on image to increase size
ExcelAnalyzer does far more than just checking formulas
It’s about discovering the full DNA of the spreadsheet and checks:
Formulas &
- VBA Code
- Tables
- Pivot Tables
- Charts
- Conditional Formats
- Validation Cells
- Names
- Hidden Columns & Rows
- Intersheet connections
- Comments
- Objects
- Hyperlinks
- and many more