Now, there can be different reasons behind this error. It can be caused when the cells within the spill range contains data or there are merged cells in teh spill range. Besides that, the error could be caused if you have used a table as Excel tables don’t support dynamic array formula...
Let’s see the procedure to fix the #SPILL! error: From the error message drop-down menu, choose Select Obstructing Cells. This will highlight the cell that caused the error. Since cells F6 and G6 are merged, the error occurs. Go to the Home tab from the ribbon. Select the cells th...
SPILL error can also occur when the result range contains themerged cells. In this example, you can see thespill range i.e. B7:B15 is emptybut still, Excel returns#SPILL error. To be sure of thereason, let’s click on theyellow warning signand see what it says – Spill range has m...
Step 1:Open your Excel workbook and identify the cell containing the spill formula resulting in the #SPILL! error. Step 2:Check if any cells within the spill range (the area covered by the formula) have data or values. If there are non-empty cells, this may be causing the #SPILL! err...
How to fix #SPILL! error in Excel As mentioned above, a #SPILL! error might be caused by various reasons. To know the exact root of the problem, click the warning icon (a yellow diamond with an exclamation point), and read the message in the first line highlighted in grey: ...
Identify what is causing the #SPILL error Fixes to be followed when Spill range isn’t blank Fix to be followed when Spill range has merged cells Fix to be followed when Spill range in the table Fix to be followed when Spill range is out of memory ...
For more details on these error types, see the following help topics: Spill range isn't blank Indeterminate size Extends beyond the worksheet's edge Table formula Out of memory Spill into merged cells Unrecognized/Fallback Need more help? See also You can always ask an expert in the Excel ...
How to remove SPILL error in Excel Follow the steps below to fix these types of #SPILL formula errors in Excel: Spill range is not blank Spill range is too big Extends beyond the worksheet edge Table formula Out of memory Spill into merge cells ...
4. When the #SPILL Range Has Merged Cells 5. When the #SPILL Range is Unknown Frequently Asked Questions What Are the Easiest Ways to Solve #SPILL Errors in Excel? How Do I Turn off SPILL Errors in Excel? How Do I Fix the VLOOKUP #SPILL Error? What Is the #SPILL Error in Excel ...
error will occur. You'll face the error for a similar reason if your spill range includes merged cells, as the data won't be able to fill in appropriately in that case either. The #SPILL! error can also pop up if the array size isn't a fixed value, like if you set the sizeusing...