https://catalogartifact.azureedge.net/publicartifacts/80931690.71d8f277-6cbf-4ef6-91ea-b6ea467bf367-1f816a5c-41f7-4e53-a423-bb53f1f3c666/image1_icon300.png

Spill Manager For Excel

by JKP Application Development Services

Spill Manager ensures formatting of Dynamic array formulas also spill and resize

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!

App capabilities

When this app is used, it
  • Can read and make changes to your document
  • Can send data over the Internet

At a glance

https://catalogartifact.azureedge.net/publicartifacts/80931690.71d8f277-6cbf-4ef6-91ea-b6ea467bf367-1f816a5c-41f7-4e53-a423-bb53f1f3c666/image3_spillmgrtryit.png
https://catalogartifact.azureedge.net/publicartifacts/80931690.71d8f277-6cbf-4ef6-91ea-b6ea467bf367-1f816a5c-41f7-4e53-a423-bb53f1f3c666/image2_spillmgreditwatch.png
https://catalogartifact.azureedge.net/publicartifacts/80931690.71d8f277-6cbf-4ef6-91ea-b6ea467bf367-1f816a5c-41f7-4e53-a423-bb53f1f3c666/image0_spillmgrmanage.png