Excel for Microsoft 365 for Mac - copy/paste issue

%3CLINGO-SUB%20id%3D%22lingo-sub-1804411%22%20slang%3D%22en-US%22%3EExcel%20for%20Microsoft%20365%20for%20Mac%20-%20copy%2Fpaste%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1804411%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20on%20a%20Macbook%2016%22%20using%26nbsp%3BExcel%20for%20Microsoft%20365%20for%20Mac%20version%2016.42%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20recently%20I%20am%20unable%20to%20copy-paste%20while%20keeping%20formulas%2C%20merged%20cells%2C%20cell%20colors%20and%20general%20formatting%20when%20pasting%20into%20the%20same%20sheet.%20I%20can%20still%20create%20a%20copy%20of%20the%20whole%20sheet%2C%20but%20I%20need%20to%20compare%20the%20data%20on%202%20versions%20of%20the%20same%20information.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20see%20in%20my%20sample%20doc%20that%20formatting%20does%20not%20paste%20correctly%20and%20the%20pic%20shows%20that%20I%20don't%20seem%20to%20have%20as%20many%20special%20options%20as%20I%20remember%20in%20the%20past.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20so%20grateful%20if%20someone%20could%20help.%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%26nbsp%3B%3CBR%20%2F%3EKSinKC%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1804411%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1804823%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Microsoft%20365%20for%20Mac%20-%20copy%2Fpaste%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1804823%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F840865%22%20target%3D%22_blank%22%3E%40KSinKC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20if%20you%20use%20Copy....and%20then%2C%20from%20the%20main%20Edit%20menu%2C%20%3CSTRONG%3EPaste%20Special%3C%2FSTRONG%3E%20and%20make%20sure%20%3CSTRONG%3EALL%3C%2FSTRONG%3E%20is%20selected%2C%20then%20you'll%20get%20the%20result%20you%20want.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1603300207239.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F228317iD09A25FB08C4D0E2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mathetes_0-1603300207239.png%22%20alt%3D%22mathetes_0-1603300207239.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESee%20the%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello, 

I am on a Macbook 16" using Excel for Microsoft 365 for Mac version 16.42

 

Just recently I am unable to copy-paste while keeping formulas, merged cells, cell colors and general formatting when pasting into the same sheet. I can still create a copy of the whole sheet, but I need to compare the data on 2 versions of the same information. 

 

You can see in my sample doc that formatting does not paste correctly and the pic shows that I don't seem to have as many special options as I remember in the past. 

 

I would be so grateful if someone could help. 

Thank you, 
KSinKC

1 Reply
Highlighted

@KSinKC 

 

I think if you use Copy....and then, from the main Edit menu, Paste Special and make sure ALL is selected, then you'll get the result you want.

mathetes_0-1603300207239.png

See the attached