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?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies