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.

Highlighted

@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.

@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
How to copy or duplicate an existing forms quiz
Olaf Nennker in Microsoft Forms on
2 Replies
Reporting on Project Online (PWA) Timesheets
Andy Dennis in Project on
3 Replies
Add, Edit, Delete Project Online data using Excel
MonteStJohns in Project on
5 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Migrate from Project Server 2013 to Project Online
Adullah_Ismail in Project on
1 Replies