This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Spill seems to be a solution (a questionable one) in search of a problem, and it actually causes me a ton of problems. This function has really screwed up decades of simple processes, such as creating index or table of contents tabs with columns for Tab Names and Page Numbers. When I try to create them now, if there's anything next to the cells with that info, I get the darn spill errors.
I know Microsoft and thus the community experts here will say that just means Spill is working as intended. But we survived for decades without the darn thing, without any problems. How to we turn it off? If we can't turn it off, can someone please give me the actual site address where I can post feedback to whoever is responsible for Excel's development to let us turn off Spill in the future? While there, I'd like to also post a request to bring back Draft view in Word (getting rid of it was yet another unhelpful "improvement").
Thanks!!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
If you really need a screenshot of a cell with a link in it then I suspect you would not be able to advise on how to get rid of this dumb "feature".
Sorry, I don't get alerts when people respond to my posts, so am just checking and saw these.
Yes, Spill does nothing but cause problems for me. As an auditor, I have to add a Index tab to my clients' workbooks then add workpaper references (such as "A1", "A2", etc.) in all the client's tabs. I then link those references to my Index tab, and then put the Tab Names and other relevant info in the columns to the right.
Thanks to this stupid Spill thing, i'm constantly getting Spill errors when Ido this now, even though I make sure the cell I add my workpaper references in are not adjacent to populated cells. No one can tell me how to turn off / disable or otherwise work around this spill "function". All of Microsoft's changes in the last 10 years have been worthless, but this is one of the first that actually makes Excel more difficult to use.
Let us assume you have 1,2,3 in the cells A1,A2,A3 and a formula =A1:A3 anywhere.
This formula spills in Excel 2021 and above. To disable the spill add the @ operator:
=@A1:A3
That disables the spilling and returns only 1 in this example.
Andreas.
Very simple. I do not wish to have Excel's stupid Spill function/feature. Every cell has different calculation formulae and Excel should not copy the same from previous one stupidly.
I often receive workbooks from clients that are not indexed. So the first thing I have to do is add an workpaper reference into each tab, then create an Index tab that links to the reference in each tab (i.e., =tabname/cell). But this annoying Spill "function" (is it really a function if the only thing it does is cause problems?) constantly generates Errors messages, which never happened before Spill.