There are two ways to fix this cause of the #SPILL! error. First, select the entire spill range (or at least the cell or ...
If you've used Excel's Merge And Center tool for a long time (like I had), you could be forgiven for thinking there's no better alternative (like I did). Well, let me introduce you to Center Across ...