There are two ways to fix this cause of the #SPILL! error. First, select the entire spill range (or at least the cell or ...
There are situations where you may want to temporarily disable Windows' built-in security feature. I'll show you how to do it safely.
First, set up a model cell with the replacement formatting. Next, press Ctrl+H to launch the Find and Replace dialog. There, define both the Find What and Replace With formatting by clicking "Choose ...