Spill Manager For Excel

Spill Manager is an Excel add-in that lets you watch a dynamic array spill range and automatically replicate formatting whenever the spill expands. Optionally, it can also clean up formatting when the spill shrinks.

Key features

Watch any dynamic array spill (select any cell inside the spill)

Copy formatting Across columns, Down rows, or Both

Optional Header and Totals row/column support (for Across columns / Down rows)

Optional cleanup when a spill shrinks

Optional live updates while you edit the workbook

All state stored within workbook defined names, so watches travel with the file (no hidden sheets, no custom XML)

Explicit Add mode and Edit mode behavior for predictable watch updates

Manage list self-heals broken watch references that contain #REF!