Excel Formula Errors: "merged cells & Spill Over

%3CLINGO-SUB%20id%3D%22lingo-sub-2843599%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Errors%3A%20%22merged%20cells%20%26amp%3B%20Spill%20Over%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2843599%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20working%20on%20a%20client%20project%20and%20am%20having%20trouble%20getting%20my%20formula%20to%20work%20due%20to%20a%20merged%20cells%20error.%20So%20I%20unmerged%20the%20cells%20which%20I%20don't%20want%20to%20do%20for%20my%20form%20template%20and%20then%20I%20got%20a%20spillover%20error%20which%20I%20don't%20know%20how%20to%20fix.%20my%20formula%20is%3A%3C%2FP%3E%3CTABLE%20width%3D%22258%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22258%22%3E%3DMASTERNOTES!C21%3AJ26%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EI%20have%20two%20templates%20I%20need%20to%20add%20this%20formula%20to%20before%20I%20can%20continue%20on%20this%20project.%20Please%20help.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2843599%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2843662%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Errors%3A%20%22merged%20cells%20%26amp%3B%20Spill%20Over%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2843662%22%20slang%3D%22en-US%22%3Eyour%20formula%20is%20a%20range%20of%20cells%20(6%20rows%20and%208%20columns).%20If%20there%20is%20anything%20(even%20a%20space%20%22%20%22)%20in%20any%20of%20the%20cells%20upto%206%20down%20and%208%20to%20the%20right%20of%20the%20cell%20that%20you%20put%20that%20formula%20you%20will%20get%20that%20!Spill%20error.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2844370%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Errors%3A%20%22merged%20cells%20%26amp%3B%20Spill%20Over%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2844370%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570951%22%20target%3D%22_blank%22%3E%40mtarler%3C%2FA%3E%26nbsp%3BThank%20you.%20I%20think%20I%20almost%20have%20it%20sorted.%20I%20am%20now%20just%20trying%20to%20figure%20out%20how%20to%20get%20the%20cell%20that%20receives%20the%20data%20to%20wrap%20text%20I%20have%20it%20set%20up%20to%20wrap%20the%20text%20but%20it%20won't%20actually%20perform%20that%20action.%20Thoughts%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, I am working on a client project and am having trouble getting my formula to work due to a merged cells error. So I unmerged the cells which I don't want to do for my form template and then I got a spillover error which I don't know how to fix. my formula is:

=MASTERNOTES!C21:J26

I have two templates I need to add this formula to before I can continue on this project. Please help. 

 

Thank you. 

4 Replies
your formula is a range of cells (6 rows and 8 columns). If there is anything (even a space " ") in any of the cells upto 6 down and 8 to the right of the cell that you put that formula you will get that !Spill error.

@mtarler Thank you. I think I almost have it sorted. I am now just trying to figure out how to get the cell that receives the data to wrap text I have it set up to wrap the text but it won't actually perform that action. Thoughts?

 

I don't know why that would happen. Try selecting those cells and re-applying the word-wrap option. In my test it worked fine but if it was applied before adding the formula I had to change the row size but if I applied it after then the row height auto changed
Thank you so much yeah I figured it out just changing the cell height made it work. Excel is not the greatest tool for blocks of text lol. Thanks again!