How to replace ctrl+~ show formulas mode with a permanent colour-coded excel audit map
- Step 1Upload the workbook to colour-code — Drop the .xlsx. ExcelJS loads every worksheet for cell classification.
- Step 2Run the highlighter — Blue fill applied to formula cells, amber to hardcoded. All sheets in one pass.
- Step 3Open and audit the highlighted workbook — Formula and hardcoded cells are instantly visible in normal view — no Ctrl+~ toggling needed.
Frequently asked questions
Does the colour coding survive if I sort or filter data?+
Yes. Cell fill colours move with the cell during sort and filter operations.
Can I remove the highlighting after the audit?+
Use Excel's Ctrl+A → Clear → Clear Formats to remove all fills. Or use a Find & Replace to target specific fill colours.
Does Ctrl+~ show hidden formulas in protected sheets?+
No. Protected sheets with hidden formulas don't reveal them via Ctrl+~. The Formula Highlighter applies formatting to cells it can read — also blocked by protection.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.