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
Highlighted
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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
205 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies