Home

Merging Two Excel Spreadsheets

%3CLINGO-SUB%20id%3D%22lingo-sub-437554%22%20slang%3D%22en-US%22%3EMerging%20Two%20Excel%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-437554%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20same%20data%20from%20two%20different%20schools%20that%20I%20need%20to%20merge%20into%20one%20spreadsheet.%20I%20have%20previously%20been%20able%20to%20cut%20and%20paste.%20Now%20I%20get%20the%20following%20message%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CEM%3ETo%20paste%20all%20cells%20from%20an%20excel%20worksheet%20into%20the%20current%20worksheet%20you%20must%20paste%20into%20the%20first%20cell%20A1%20or%20R1C1%3C%2FEM%3E.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20with%20this%20is%20that%20it%20replaces%20the%20information%20from%20the%20first%20spreadsheet%20instead%20of%20adding%20to%20it.%20I%20have%20been%20cutting%20and%20pasting%20all%20year%20with%20no%20problems.%20However%2C%20I%20stared%20getting%20this%20message%20this%20week.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-437554%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-438836%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20Two%20Excel%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438836%22%20slang%3D%22en-US%22%3EPerhaps%20you%20have%20copied%20more%20rows%20than%20can%20fit%20in%20the%20target%20sheet%3F%3C%2FLINGO-BODY%3E
KWrightFLEX
Occasional Visitor

I have the same data from two different schools that I need to merge into one spreadsheet. I have previously been able to cut and paste. Now I get the following message:

To paste all cells from an excel worksheet into the current worksheet you must paste into the first cell A1 or R1C1.

 

The problem with this is that it replaces the information from the first spreadsheet instead of adding to it. I have been cutting and pasting all year with no problems. However, I stared getting this message this week.

1 Reply
Perhaps you have copied more rows than can fit in the target sheet?