The Spill Is Gone
True, the term “spill” – the name Excel has conferred upon its new multi-cell formula capability – suggests an episode of untidiness, like the kind of mishap I routinely inflict upon my shirt at dinner. But as we’ve seen in the realm of spreadsheets, spilling is a good thing indeed. Empowering one formula to dispense thousands of results to as many cells is a hugely efficient and praiseworthy feature. But there are two principal circumstances under which Excel won’t allow a spill to happen. ...