Writing over Spilled Legacy Array Formulas

Occasional Visitor

I always try to learn from Microsoft Templates. I  came across this Photo calendar template were the author was able to make cells write over legacy spilled arrays with no errors. 



Does anyone know how to duplicate this? I thought we are unable to write in cells that occupy an array formula. 

1 Reply


If on Excel with dynamic arrays you enter formula without CSE it returns spill


However, if you enter same formula with CSE it returns only first element of the array, that how dynamic array formula works


You may try on any other formula