Ask Mini NOVA, then clear the spill
Select the cell that shows #SPILL! so the dashed border is on screen. Microsoft Support uses that border to show where the formula wanted to put its results.
- Leave the error on screen. Keep the message, the formula bar, or the settings page in view. Mini NOVA captures the screen when you submit the question, so scroll until the error and a little of the window around it are visible.
- Press Insert and type your question. Press Insert, then type what you want to know. Mini NOVA sees that screen and guides you step by step. You make the click. There is no server or browser extension to set up, and no Microsoft 365 plan is needed.
- Change one thing, then look again. You make the change. If the error is still there, ask a follow-up with the new screen visible. Mini NOVA remembers the conversation context. There is no chat history list.
- Select the cells that are in the way. Select the cell with #SPILL!. A dashed border shows the intended spill range, and an error-checking alert appears. Choose Select Obstructing Cells. Delete or move whatever is in those cells. When the blockage is gone, the formula spills, or a PivotTable expands, into that range.
- Unmerge cells inside the border. A spilled formula cannot land on merged cells. Unmerge them, or move the formula to a range that does not cross a merge. Select Obstructing Cells finds the merged cells as well.
- Move the formula out of a table. Spilled array formulas are not supported inside a table. Move the formula out of the table, or select the table and use Table Design, then Tools, then Convert to range.
- Shrink a lookup that covers a whole column. A formula such as =VLOOKUP(A:A,A:C,2,FALSE) tries to look up every row and spill more than a million results, which runs off the sheet. Microsoft Support gives three replacements: look up only the rows you need, such as A2:A7; look up the single cell on that row, such as A2, and copy the formula down; or use the @ operator, as in =VLOOKUP(@A:A,A:C,2,FALSE), and copy down. The single-cell and @ forms work in a table. The whole-block form does not.
Nearby formula errors
#N/A is a lookup that found nothing. #REF! is a reference that no longer exists. #VALUE! is a value of the wrong kind. The spreadsheet guide is the place to start when the code on the sheet is none of these.
Sources
Checked on 9 Oct 2026. Support pages change, so open the source before you rely on a step. Mini NOVA is not affiliated with Microsoft. Questions about the account itself go to admin@deskwithnova.com.
- How to correct a #SPILL! error (Microsoft Support)
- #SPILL! error when the result extends beyond the sheet (Microsoft Support)
- Dynamic array formulas and spilled array behavior (Microsoft Support)
FAQ
How do I fix a #SPILL! error in Excel?
Select the cell so the dashed border shows, then use Select Obstructing Cells and clear or move what is blocking the range. Also check for merged cells and for a formula that sits inside a table.
Why does a whole-column VLOOKUP show #SPILL! in Excel?
Passing a whole column as the lookup value makes the formula try to return a result for every row. Limit the lookup to the rows you need, look up one cell and copy down, or use @.
Can Mini NOVA clear the spill range for me?
No. It can tell you which cells on the screen are in the way. You delete or move them.
Does Mini NOVA click or type for me?
No. It guides you step by step, and you make the click. It never acts on its own.
How do I open Mini NOVA?
Press Insert, then type your question about what is on your screen.
Does Mini NOVA keep a chat history?
It remembers the context of the conversation. There is no chat history list.
Is Mini NOVA free to try?
7 days or 100 questions free. No card required.
Is Mini NOVA the Novation MiniNova synth?
No. Mini NOVA by NOVA is a Windows screen assistant from NOVA ENTERPRISE LIMITED. It is not related to the Novation MiniNova synthesizer.
Who do I contact about Mini NOVA?
Email admin@deskwithnova.com.