Unable to Paste Data

%3CLINGO-SUB%20id%3D%22lingo-sub-1491966%22%20slang%3D%22en-US%22%3EUnable%20to%20Paste%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491966%22%20slang%3D%22en-US%22%3E%3CP%3EWhenever%20i%20try%20to%20paste%20data%20copied%20from%20another%20worksheet%2C%20i%20get%20the%20error%20message%20%22You%20can't%20paste%20this%20here%20because%20the%20copy%20and%20paste%20area%20are%20not%20the%20same%20size%22%20Please%20how%20do%20i%20fix%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1491966%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492309%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20Paste%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492309%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F711246%22%20target%3D%22_blank%22%3E%40Faith_Elijah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20usually%20happens%20when%20you%20copy%20data%20from%20CSV%20file%20(which%20can%20save%20data%20in%20more%20rows)%20to%20Excel%20file%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20you%20could%20do%20is%2C%20save%20the%20same%20file%2C%20%22Save%20as%22%20in%20excel%20format%2C%20and%20try%20to%20open%20the%20new%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20works%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1493595%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20Paste%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493595%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F711246%22%20target%3D%22_blank%22%3E%40Faith_Elijah%3C%2FA%3E%26nbsp%3BThe%20error%20message%20occurs%20when%20you%20are%20copying%20an%20entire%20row%20(or%20range%20of%20rows)%20and%20then%20try%20to%20paste%20it%20to%20a%20cell%20that%20is%20NOT%20the%20first%20cell%20of%20another%20row.%20This%20is%20similar%20for%20columns.%20So%2C%20if%20you%2C%20for%20instance%2C%20want%20to%20copy%20row%201%2C%20you%20can%20paste%20it%20to%20any%20cell%20on%20any%20sheet%20as%20long%20as%20the%20the%20destination%20cell%20is%20in%20column%20A.%20Similarly%2C%20when%20you%20copy%20the%20entire%20column%20A%2C%20you%20can%20only%20paste%20to%20a%20cell%20on%20row%201.%20And%20if%20you%20copy%20an%20entire%20sheet%2C%20you%20can%20only%20copy%20to%20cell%20A1.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Whenever i try to paste data copied from another worksheet, i get the error message "You can't paste this here because the copy and paste area are not the same size" Please how do i fix this?

2 Replies
Highlighted

@Faith_Elijah 

 

Hi

This usually happens when you copy data from CSV file (which can save data in more rows) to Excel file,

 

What you could do is, save the same file, "Save as" in excel format, and try to open the new file.

 

Hope this works

 

Highlighted

@Faith_Elijah The error message occurs when you are copying an entire row (or range of rows) and then try to paste it to a cell that is NOT the first cell of another row. This is similar for columns. So, if you, for instance, want to copy row 1, you can paste it to any cell on any sheet as long as the the destination cell is in column A. Similarly, when you copy the entire column A, you can only paste to a cell on row 1. And if you copy an entire sheet, you can only copy to cell A1.