Excel Spilled Results and Fixing the SPILL! Error

Learn how Excel can now "spill" results of formulas in Microsoft 365 versions of Excel. You'll also see how to fix the most common reasons for the #spill! error. Watch my entire playlist of Excel tutorials: bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's a link to the practice file for this video (copy/paste it into browser): bit.ly/uniquespilled
#exceltutorial #excel #spill! #spillerror

[@richardtriance5207]

Thanks. watched this in my coffee break. i SPILLED my coffee learning about this.

[@AngelloShongwe]

Thank you for the tutorial. Very helpful.

[@derekcanmexit]

I came across your videos recently and enjoy your teaching methods about Excel - do you offer any courses?

[@RobStephenson-pi2gq]

In your example, What if you were to insert a row below Ulver, below The Killers etc. Then in a blank cell in Sales column do a formula to add up the value, subtotal.

[@Zagor1913]

Are you planning on making some tutorials for Microsoft Access???

[@monachopra4393]

Pls explain in a video how to do mail merge

[@ArcOfTheCovenant]

Could an array alone produce a spill error. Or does it only error on the spilled results. 🤔

[@kimberbearly7909]

class.

[@ArcOfTheCovenant]

I can't get my array to spill. Using the filter function! I'm stuck af..