{"id":23878,"date":"2021-06-07T12:09:25","date_gmt":"2021-06-07T10:09:25","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=23878"},"modified":"2024-06-11T21:26:46","modified_gmt":"2024-06-11T19:26:46","slug":"spill-error","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/spill-error\/","title":{"rendered":"How to fix the #SPILL! error in Excel formulas"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/19.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24176\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/19.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/19.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/19-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/19-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>#SPILL Excel mainly <strong>occurs when the range in which the result of <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> will be displayed<\/strong> is being <strong>obstructed<\/strong> by some other data. It can be <strong>blocked<\/strong> by when the cells in the spilled range contain <strong>some text, space, or are merged<\/strong>.<\/p>\n<p>Once you <strong>know the reason why Excel is producing SPILL<\/strong> errors, you can <strong>simply fix the problem<\/strong> and get rid of this error.<\/p>\n<ul>\n<li><a href=\"#what-is-spill-error-in-excel\"><strong>What does SPILL mean?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-fix-spill-error-in-excel\"><strong>How to fix #SPILL Excel?<\/strong><\/a><\/li>\n<li><a href=\"#conclusion\"><strong>Conclusion<\/strong><\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966\"><strong><a id=\"what-is-spill-error-in-excel\" style=\"color: #339966\"><\/a>What does SPILL mean?<\/strong><\/span><\/h3>\n<p><strong>Dynamic arrays<\/strong> come with a package full of benefits but it also includes the user to a <strong>new error &#8211; SPILL<\/strong>! These <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formulas\" data-wpil-keyword-link=\"linked\">formulas<\/a> produce multiple results and<strong> display them to the neighboring cells<\/strong>.<\/p>\n<p>SPILL error is caused when a<strong> formula with multiple results cannot display its output array<\/strong> as those<strong> cells already contain some data<\/strong>.<\/p>\n<p>A <strong>simple solution<\/strong> to this problem is to<strong> clear contents of the cells<\/strong> in the spill range.<\/p>\n<p>Follow this<strong> detailed tutorial<\/strong> on #SPILL Excel and <strong>download this Excel workbook<\/strong> to practice along and understand better:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/SPILL-error.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Top-20-Common-Excel-Errors.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong> download excel workbook<\/strong> <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">SPILL-error.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<h3><strong><a id=\"how-to-fix-spill-error-in-excel\"><\/a><span style=\"color: #339966\">How to fix #SPILL Excel?<\/span><\/strong><\/h3>\n<p>The <strong>different scenarios<\/strong> when you can encounter this error are:<\/p>\n<ul>\n<li>Spill range isn&#8217;t blank<\/li>\n<li>Spill range contains merged cell<\/li>\n<li>Spill range is too big<\/li>\n<li>Spill range in a table<\/li>\n<\/ul>\n<p>Let&#8217;s look into more detail and <strong>understand the causes and solutions<\/strong> to the #SPILL Excel!<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>Example 1: Spill range isn&#8217;t blank<\/strong><\/span><\/p>\n<p>The spill range where the <strong>result will be displayed is non-empty<\/strong>.<\/p>\n<p>In the example, we have <strong>used the UNIQUE function<\/strong> to extract a unique customer list in column B. Instead of<strong> displaying the result, Excel returns #SPILL!<\/strong> error.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"Top 20 Common Excel Problems Solved\" title=\"Top 20 Common Excel Problems Solved\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-375-Copy.png\" \/><\/p>\n<p>To understand the reason behind this error, click on the<strong> small yellow! warning sign<\/strong> next to the error. Upon clicking this sign, Excel tells you the reason &#8211; <strong>Spill range isn&#8217;t blank<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-377.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 20 Common Excel Problems Solved\" class=\"alignnone size-full wp-image-23776\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-377.png\" alt=\"Top 20 Common Excel Problems Solved\" width=\"346\" height=\"366\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-377.png 346w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-377-284x300.png 284w\" sizes=\"(max-width: 346px) 100vw, 346px\" \/><\/a><\/p>\n<p>Here, <strong>B12 already contains text<\/strong>!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Top 20 Common Excel Problems Solved\" class=\"alignnone\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-375.png\" alt=\"Top 20 Common Excel Problems Solved\" width=\"428\" height=\"514\" \/><\/p>\n<p><b>Solution:<\/b><\/p>\n<p>Simply, clear any contents from the output range and you are good to go!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-376.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 20 Common Excel Problems Solved\" class=\"alignnone size-full wp-image-23775\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-376.png\" alt=\"Top 20 Common Excel Problems Solved\" width=\"420\" height=\"513\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-376.png 420w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-376-246x300.png 246w\" sizes=\"(max-width: 420px) 100vw, 420px\" \/><\/a><\/p>\n<p>There can be times when you get the<strong> SPILL error<\/strong> but you are <strong>unable to spot the cell that contains unwanted data<\/strong>.<\/p>\n<p>Click on <strong>Select Obstructing Cells<\/strong> and it will take you to the cell that is creating the problem.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-411.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24020\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-411.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"384\" height=\"504\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-411.png 384w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-411-229x300.png 229w\" sizes=\"(max-width: 384px) 100vw, 384px\" \/><\/a><\/p>\n<p>This is<strong> useful when you have hidden spaces<\/strong> and you are unable to find them.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-413.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24021\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-413.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"367\" height=\"447\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-413.png 367w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-413-246x300.png 246w\" sizes=\"(max-width: 367px) 100vw, 367px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>Example 2: Spill range contains merged cells<\/strong><\/span><\/p>\n<p>SPILL error can also occur when the result range contains the<strong> merged cells<\/strong>.<\/p>\n<p>In this example, you can see the<strong> spill range i.e. B7:B15 is empty<\/strong> but still, Excel returns <strong>#SPILL error<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-414.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24022\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-414.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"392\" height=\"449\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-414.png 392w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-414-262x300.png 262w\" sizes=\"(max-width: 392px) 100vw, 392px\" \/><\/a><\/p>\n<p>To be sure of the<strong> reason<\/strong>, let&#8217;s click on the<strong> yellow warning sign<\/strong> and see what it says &#8211; Spill range has merged cell.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-418.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24023\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-418.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"392\" height=\"428\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-418.png 392w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-418-275x300.png 275w\" sizes=\"(max-width: 392px) 100vw, 392px\" \/><\/a><\/p>\n<p>Now, click on<strong> Select Obstructing Cells<\/strong> and it will take you there.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-419.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24024\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-419.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"388\" height=\"452\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-419.png 388w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-419-258x300.png 258w\" sizes=\"(max-width: 388px) 100vw, 388px\" \/><\/a><\/p>\n<p>Go to <strong>Home<\/strong> &gt;<strong> Merge &amp; Center<\/strong> to <strong>unmerge the cells<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-420.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24025\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-420.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"959\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-420.png 959w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-420-300x40.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-420-768x103.png 768w\" sizes=\"(max-width: 959px) 100vw, 959px\" \/><\/a><\/p>\n<p>The result is now visible and the error disappears!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-421.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24026\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-421.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"387\" height=\"467\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-421.png 387w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-421-249x300.png 249w\" sizes=\"(max-width: 387px) 100vw, 387px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>Example 3: Spill range is too big<\/strong><\/span><\/p>\n<p>This error occurs when the <strong>output range is too big<\/strong> and the<strong> result goes beyond Excel&#8217;s boundary<\/strong>. There <strong>isn&#8217;t enough space<\/strong> to display the result.<\/p>\n<p>In this example, we are trying to calculate the <strong>discount given to the customers based on the sales amount<\/strong>. Column C is used to get 5% of the sales amount.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-422.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24028\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-422.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"428\" height=\"430\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-422.png 428w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-422-300x300.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-422-150x150.png 150w\" sizes=\"(max-width: 428px) 100vw, 428px\" \/><\/a><\/p>\n<p>As you can see, Excel is again and producing a<strong> SPILL error<\/strong> and this time it is because the<strong> range is too big<\/strong>.<\/p>\n<p>Here, Excel is trying <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-multiply-in-excel\/\" target=\"_blank\" rel=\"noopener\">to multiply each cell in<\/a><strong> Column B by 5%<\/strong> and produce a<strong> million results<\/strong>. It will <strong>spill the result in Column C<\/strong> starting from cell C7 but it will <strong>reach the end of Excel.<\/strong><\/p>\n<p>Hence, the error!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-423.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24029\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-423.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"486\" height=\"438\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-423.png 486w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-423-300x270.png 300w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/a><\/p>\n<p>To solve this, simply <strong>replace the column with the relevant range <\/strong>and <strong>copy the formula<\/strong> to the output range.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-425.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24030\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-425.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"465\" height=\"428\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-425.png 465w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-425-300x276.png 300w\" sizes=\"(max-width: 465px) 100vw, 465px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>Example 4: Spill range in a table<\/strong><\/span><\/p>\n<p>Excel tables <strong>do not support spilled array formulas<\/strong>. If you try to insert an array formula in an Excel table, it will return a #SPILL error.<\/p>\n<p>In this example, we are trying to<strong> sort the amount mentioned in Column A in ascending order<\/strong> using the SORT function. It will <strong>return a dynamic array<\/strong> as a result in column B.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-431.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone wp-image-24032 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-431.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"375\" height=\"408\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-431.png 375w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-431-276x300.png 276w\" sizes=\"(max-width: 375px) 100vw, 375px\" \/><\/a><\/p>\n<p>Unfortunately, we are getting a #SPILL Excel error.\u00a0 This is because<strong> range A7:B15 is in fact saved as a table<\/strong> in Excel and dynamic functions do not work within Excel tables.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-427.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24033\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-427.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"382\" height=\"391\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-427.png 382w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-427-293x300.png 293w\" sizes=\"(max-width: 382px) 100vw, 382px\" \/><\/a><\/p>\n<p>We can easily <strong>convert it into a range<\/strong> for our SORT function to work properly.<\/p>\n<p>To do so:<strong> Right Click<\/strong> on any cell in the Table range &gt; Select <strong>Table<\/strong>\u00a0&gt; Select<strong>\u00a0Convert to Range<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-428.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24034\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-428.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"658\" height=\"501\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-428.png 658w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-428-300x228.png 300w\" sizes=\"(max-width: 658px) 100vw, 658px\" \/><\/a><\/p>\n<p>This will<strong> convert the table to range<\/strong> and now all array <strong>functions will work perfectly<\/strong> as shown below!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-430.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #SPILL! error in Excel formulas\" class=\"alignnone size-full wp-image-24035\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-430.png\" alt=\"How to fix the #SPILL! error in Excel formulas\" width=\"358\" height=\"366\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-430.png 358w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-430-293x300.png 293w\" sizes=\"(max-width: 358px) 100vw, 358px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"conclusion\"><\/a><span style=\"color: #339966\">Conclusion<\/span><\/strong><\/h3>\n<p>Next time when you face <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/run-time-error-1004-in-excel\/\" target=\"_blank\" rel=\"noopener\">#SPILL error in<\/a> Excel, the <strong>best way to deal<\/strong> with it would be to<strong> examine the cause of the problem<\/strong> by clicking on the <strong>exclamation mark icon<\/strong>.<\/p>\n<p>After that, you can easily troubleshoot the problem and fix the error effortlessly!<\/p>\n<p>&nbsp;<\/p>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>#SPILL Excel mainly occurs when the range in which the result of formula will be displayed is being obstructed by some other data. It can be blocked by when the cells in the spilled range contain some text, space, or are merged. Once you know the reason why Excel is producing SPILL errors, you can [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":24176,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to fix the #SPILL! error in Excel formulas","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[36,563],"tags":[735,733,734],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23878"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=23878"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23878\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/24176"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=23878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=23878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=23878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}