Cell Radar for Excel - BASIC
Cell Radar lists the problems in the formulas of the workbook you have open in Excel. The list appears in a pane next to the sheet. One click on a row takes you to the cell.
The BASIC version is free and needs no license key. It checks five things:
- Error values (#DIV/0!, #REF!, #N/A...)
- Formula differs from the rest of the column
- Hard-coded number in a column of formulas
- Volatile function (OFFSET, INDIRECT, NOW...)
- Reference to a whole column or row (A:A)
The FULL version adds fifteen checks, most of which Excel does not do: a total that includes a subtotal, a lookup with approximate match, IFERROR hiding errors, a formula that differs from the sibling sheets, a number compared with text, spaces in a lookup key, and more.
Works in English, Italian, French, Spanish and German.
REQUIREMENTS: Excel for Microsoft 365 on Windows. Not for Mac, not for Excel on the web.