How to correct a #NOSPILL! error

The #NOSPILL! error is Excel's way of saying that a modern array formula can't extend itself because there is a potential blockage in its way.

Important: Modern array formulas are only available in Excel 2016 if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.

Identify your intended array range

If you select the cell with the #NOSPILL! error, Excel will automatically highlight the array's intended area. This will allow you to identify the blockage and remove it, or resize your array.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.