How do I turn off the autofill of the Spill Range Operator?

Hi!

Lets suppose I have a formula that takes in many different columns, or ranges, as is the case quite often. For some reasons, I would like to use a differen range. BEFORE the introduction of this feature, I would just by hand move the highlighted range from one location, e.g. column "A" to column "B". Any '$' symbols would stay and I would be happy. Now, doing the same, $A$1:$A$1001, gets replaced by B1#. This removes the "$" operator, that I do need when copying or moving the formula. Also, chnaging other parts of the worksheet than confuses the spill operator and suddenly my formula does not work anymore - without any changed to its inputs!

1001 elements was just an example. The reason in my case is that I normally operate over 0...n elements, which is n+1 elements.

The automatic appearance of the spill range operator annoys me on the daily basis and correcting it is a real hassle for me. I attached a quick example.