Or, you might have run into one of the very few features that do not support dynamic arrays. Or the same formula copied across the entire column blocks a spill range. Perhaps, one or more cells in the spilled area contain a space or a non-printing character invisible to a human eye. For instance, if your formula is expected to return more than one value, but the nearby cells are filled with some other data, simply delete that data, and an error will be gone.īut sometimes the reasons are not so obvious and therefore confusing. And if something on the sheet prevents filling that range, a #SPILL! error occurs.įor the most part, this behavior is understandable and predictable. A range of cells containing the results is called a spill range. Please notice, any formula, even the ones that were not initially designed to handle arrays. With the launch of dynamic arrays in Excel 365, any formula that produces multiple calculation results automatically 'spills' those results into neighboring cells. Generally, a #SPILL! error occurs when a formula produces multiple results but cannot output them all on the sheet.īefore we dive into specific use cases, let's get a general understanding of spilling in Excel. Does anyone know what it means? Of course, we do, and you'll get your solution in a moment :) Whatever you do, you are now getting a #SPILL error. Just imagine this: you upgraded to Microsoft Office 365 with the latest Excel updates and for some reason the tried and tested formulas you've been using for years have suddenly stopped working. To learn what can trigger this error and how you can resolve it, please keep reading. What does #SPILL mean in Excel? It's an error that occurs when a formula is unable to populate multiple cells with the calculated results.

Transpose excel 365