Mar 11 2021 10:00 AM
You may empty the space for it, or place in another place, or re-write the formula
Mar 25 2021 01:23 PM
@Sergei Baklan how do you stop excel from doing the Spill, like I would like my computer to forget how to use that function even if I can because it just always gets in the way and has not been useful for me
Mar 25 2021 02:11 PM
Are you any happier with Excel now? If it is any consolation, I detest the A1 notation and the concept of relative referencing, but I can't make that go away either! Excel makes a remarkably good attempt at being all things to all people but it is not possible to please all the people all the time.
Trust me, dynamic arrays and spilt ranges represent a superb advance and it is well worth taking the time to learn to exploit them to the full.
Mar 26 2021 07:47 AM
Hey @Peter Bartholomew so you're saying I can't stop excel from doing the spill, or deactivate this function somehow?
Mar 26 2021 10:00 AM