Home

Copy from one spreadsheet online to another

%3CLINGO-SUB%20id%3D%22lingo-sub-618557%22%20slang%3D%22en-US%22%3ECopy%20from%20one%20spreadsheet%20online%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-618557%22%20slang%3D%22en-US%22%3E%3CP%3EAll%20I%20want%20to%20do%20is%20copy%20from%20one%20Excel%20spreadsheet%20to%20another%20and%20the%20values%20remain%20instead%20of%20having%20to%20copy%20and%20literally%20manually%20rewrite%20over%20every%20single%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20like%20the%20most%20rudimentary%20Excel%20function.%20Why%20is%20it%20so%20hard%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-618557%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-618937%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20from%20one%20spreadsheet%20online%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-618937%22%20slang%3D%22en-US%22%3E%3CP%3EAlso%2C%20why%20can't%20you%20select%20more%20than%20one%20cell%20and%20just%20press%20delete%3F%20Why%20does%20Excel%20not%20wok%20online%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-619238%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20from%20one%20spreadsheet%20online%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-619238%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F345288%22%20target%3D%22_blank%22%3E%40georgia_Halston%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20mean%20to%20select%20non-adjacent%20cells%20-%20yes%2C%20that%20doesn't%20work.%20If%20continuous%20range%20-%20no%20problem%20with%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-619262%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20from%20one%20spreadsheet%20online%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-619262%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bnope%2C%20I%20mean%20any%20cells%20the%20attached%20for%20example.%20When%20you%20paste%20it%20into%20another%20workbook%2C%20non%20of%20the%20formulas%20work%2C%20they%20don't%20see%20them%20as%20real%20numbers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-619492%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20from%20one%20spreadsheet%20online%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-619492%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F345288%22%20target%3D%22_blank%22%3E%40georgia_Halston%3C%2FA%3E%26nbsp%3B%2C%20strange%2C%20no%20problems%20with%20Ctrl%2BC%2FCtrl%2BV%20of%20numbers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-619516%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20from%20one%20spreadsheet%20online%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-619516%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bthat's%20what%20I'm%20doing%2C%20but%20from%20one%20workbook%20to%20another%2C%20it%20doesn't%20understand%20numbers%2C%20the%20same%20if%20you%20copy%20from%20an%20Excel%20sheet%20on%20desktop.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-625929%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20from%20one%20spreadsheet%20online%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-625929%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F345288%22%20target%3D%22_blank%22%3E%40georgia_Halston%3C%2FA%3E%26nbsp%3B%2C%20could%20you%20attache%20small%20sample%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
georgia_Halston
New Contributor

All I want to do is copy from one Excel spreadsheet to another and the values remain instead of having to copy and literally manually rewrite over every single value.

 

It's like the most rudimentary Excel function. Why is it so hard?

6 Replies

Also, why can't you select more than one cell and just press delete? Why does Excel not wok online?

@georgia_Halston , if you mean to select non-adjacent cells - yes, that doesn't work. If continuous range - no problem with that.

@Sergei Baklan nope, I mean any cells the attached for example. When you paste it into another workbook, non of the formulas work, they don't see them as real numbers.

@georgia_Halston , strange, no problems with Ctrl+C/Ctrl+V of numbers.

Highlighted

@Sergei Baklan that's what I'm doing, but from one workbook to another, it doesn't understand numbers, the same if you copy from an Excel sheet on desktop.

@georgia_Halston , could you attache small sample file?

Related Conversations
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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies