Spill Manager for Excel | keep spill formatting consistent

Dynamic array formulas spill and resize automatically, but their formatting does not, unlike tables. Spill Manager solves that by watching spill ranges and keeping formatting consistent when spills resize. It supports guided Add/Edit workflows, live updates, and optional cleanup when spills shrink.

Content

• What is Spill Manager
• Key features
• Installation
• How it works
• Getting started (Try It)
• Add a watch
• Manage watches
• Version history
• Support

What is Spill Manager

Spill Manager is an Excel add-in that lets you watch dynamic array spill ranges 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!

Installation

Web and Teams Excel

Install Spill Manager (Teams, Web Excel) now

A new Excel file will open in your browser with this information:

Click the "Accept and Continue" button in the task pane to start using the add-in. After clicking the button, Spill Manager will also be available in Excel within Teams.

Manual installation

If the button does not work, open any Excel file in your browser and click the add-ins button. Then search for Spill Manager:

Click Add to add the add-in to your Web Excel.

The search functionality is broken. Finding add-ins which contain more than a single word in their names is really hard. To find most of mine, simply search for my initials: jkp

Desktop Excel

Install Spill Manager (Desktop Excel) now

After clicking that button, the browser will ask permission to open Excel. Click Open and Excel will start and display this:

Click the "Accept and Continue" button in the task pane to start using the add-in.

Manual installation

If the button above does not work for you, you can also install the tool by opening Excel and clicking Add-ins (On the Home tab). Then search for "Spill Manager":

To add Spill Manager to your Excel, click the Add button. 

How it works

• Watches are stored in worksheet-scoped defined names, so the file stays self-contained and the configuration travels with it (no hidden sheets, no custom XML).
• Spill Manager applies formats to the spill output range based on your selected direction.
• Formatting is applied when you click Manage > Refresh all, and (when Live updates is enabled) automatically after worksheet value and format changes while the add-in is running.
• If the add-in is not running, the workbook still opens normally; only the automated formatting updates won’t occur.
• When Live updates is on, Spill Manager waits briefly before acting on a change — this is intentional. Excel’s dynamic array formulas (also called spill formulas) can trigger multiple events in quick succession as the spill range resizes. The short pause lets all those events settle before formatting is applied, so you see one clean update rather than several partial ones.

Getting started (Try It)

1. Open the Spill Manager task pane.
2. Go to Try It and click Insert training sheet.
3. Change the input cells next to Rows and Columns to resize the spills and see formatting update live.
4. Optionally click Insert info sheet to add a workbook explanation page for recipients.

Add a watch

1. Select any cell inside a spill range.
2. In Spill Manager, go to Add Watch.
3. Choose where to copy formatting to (Across columns, Down rows, or Both).
   
4. (Optional) enable Header and/or Totals row/column support (available for Across columns / Down rows).
   Checking the header box changes how the heading format is treated:
   
5. (Optional) enable Live updates and Cleanup on shrink.
6. Click Add Watch.

Note that you can turn off live updates for a single watch by unchecking "Live updates". A click on "Refresh All" will update all watches, including watches which have this setting unchecked.

Next unwatched workflow

• Unwatched finds the next spill range that isn't in the watch list. It scans the active sheet first, then other worksheets.
• If settings were changed for the current spill, Spill Manager asks: Yes (save), No (discard), or Cancel (stay).
• The scan skips already watched spills and ignores formula cells inside Excel tables.
• When no eligible spill exists, the pane reports that no unwatched spills were found.

Manage watches

Existing watched spills can be managed from the Manage tab, which looks like this:

The following features are available here:

• Refresh all watches to apply formatting to current spill sizes
• Use the Automatic / Manual switch (next to Refresh all) to control whether Spill Manager automatically refreshes watches in this workbook while you work. Refresh all always refreshes, regardless of the switch.
• Edit a watch to change direction and options (Header/Totals, Cleanup on shrink, Live updates)
• Remove a watch to stop automated formatting
• Use Repair watch list when invalid entries are detected
• Broken watch entries containing #REF! are removed automatically when the watch list is loaded
• Legacy watch direction labels are automatically upgraded when watches are read

Version History

• 1.1.1.0 (2026-04-21)
  • First release

Support

Feedback and support: info@jkp-ads.com.