SPILL!

%3CLINGO-SUB%20id%3D%22lingo-sub-2709267%22%20slang%3D%22en-US%22%3ESPILL!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2709267%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20get%20rid%20of%20the%20SPILL%20error%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2709267%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2709297%22%20slang%3D%22en-US%22%3ERe%3A%20SPILL!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2709297%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1143914%22%20target%3D%22_blank%22%3E%40Crambone%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhow-to-correct-a-spill-error-ffe0f555-b479-4a17-a6e2-ef9cc9ad4023%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhow-to-correct-a-spill-error-ffe0f555-b479-4a17-a6e2-ef9cc9ad4023%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How do I get rid of the SPILL error?

2 Replies
If you're getting a spill error, your formula in B1 for example is =A1:A5, will return a 5 row long result pulled from A1:A5 that will fill down B1:B5. If anything is within that range, you'll get the spill error. Same thing for horizontal spills.