Special Paste (Values) not working with merges cells

%3CLINGO-SUB%20id%3D%22lingo-sub-3239235%22%20slang%3D%22en-US%22%3ESpecial%20Paste%20(Values)%20not%20working%20with%20merges%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3239235%22%20slang%3D%22en-US%22%3EI%20have%20two%20workbooks.%20We%E2%80%99ll%20call%20them%20%E2%80%9CFacility%20Production%20-%20Date%E2%80%9D%20and%20%E2%80%9CCorporate%20Report%20-%20Weekly%E2%80%9D.%3CBR%20%2F%3E%3CBR%20%2F%3EData%20is%20input%20to%20Facility%20Production-Date%20on%20sheet1%2C%20that%20data%20is%20pre%20populated%20on%20sheet2%20using%20%3DSheet1!A1%2C%20etc%20etc.%20sheet2%20is%20formatted%20exactly%20the%20same%20as%20corporate%20report%20-%20weekly%20sheet1.%20However%20when%20I%20try%20to%20copy%20and%20paste%20the%20information%20it%20says%20all%20merged%20cells%20must%20be%20the%20same%20size.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%2C%3CBR%20%2F%3EPq%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3239235%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3239946%22%20slang%3D%22en-US%22%3ERe%3A%20Special%20Paste%20(Values)%20not%20working%20with%20merges%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3239946%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1321080%22%20target%3D%22_blank%22%3E%40pq10182%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20afraid%20there%20is%20no%20way%20around%20the%20error%20message%20that%20you%20get.%20Paste%20special%20%2F%20paste%20values%20does%20work%20only%20on%20cells%20that%20are%20not%20merged.%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20you%20have%20either%20to%20unmerge%20all%20the%20cells%20in%20the%20source%20and%20target%20sheets.%20Or%20you%20could%20just%20use%20standard%20full%20paste.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
I have two workbooks. We’ll call them “Facility Production - Date” and “Corporate Report - Weekly”.

Data is input to Facility Production-Date on sheet1, that data is pre populated on sheet2 using =Sheet1!A1, etc etc. sheet2 is formatted exactly the same as corporate report - weekly sheet1. However when I try to copy and paste the information it says all merged cells must be the same size.

Thanks,
Pq
1 Reply

Hi @pq10182 

 

I'm afraid there is no way around the error message that you get. Paste special / paste values does work only on cells that are not merged. 

So you have either to unmerge all the cells in the source and target sheets. Or you could just use standard full paste.