keep source format when pasting

%3CLINGO-SUB%20id%3D%22lingo-sub-2182554%22%20slang%3D%22en-US%22%3Ekeep%20source%20format%20when%20pasting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2182554%22%20slang%3D%22en-US%22%3E%3CP%3EWant%20to%20copy%20and%20past%20cells%20and%20keep%20source%20formatting.%20When%20I%20copy%20and%20go%20to%20paste%20nothing%20drops%20down%20in%20the%20paste%20menu...then%20when%20I%20paste%20it%20is%20all%20messed%20up!%20Help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2182554%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Want to copy and past cells and keep source formatting. When I copy and go to paste nothing drops down in the paste menu...then when I paste it is all messed up! Help

4 Replies

@wordent 

On which Excel you are (Android, Mac, Windows) and which edition?

windows

@wordent 

If this menu is not available

image.png

do you see one from right click menu?

image.png