keep source format when pasting

Question

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

sergeibaklan · Answer

wordent&nbsp;
On which Excel you are (Android, Mac, Windows) and which edition?

wordent · Answer

windows

cuong · Answer

Does this help? https://support.microsoft.com/en-us/office/move-or-copy-cells-and-cell-contents-803d65eb-6a3e-4534-8c6f-ff12d1c4139e

sergeibaklan · Answer

wordent&nbsp;
If this menu is not available

do you see one from right click menu?

alexmr3 · Answer

SergeiBaklan&nbsp;&nbsp;hi, I know it is an old post, but i am facing a very similar issue.When trying to copy SQL formatted text from Azure, Eclipse... into MS Word (Office 365) it does keep the Target (Word) formatting.So the SQL formatting gets lost:&nbsp;I´ve followed as per suggestions:https://support.microsoft.com/en-us/office/control-the-formatting-when-you-paste-text-20156a41-520e-48a6-8680-fb9ce15bf3d6But still "Paste Special" options still do not appear:&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;Any suggestion ?

Forum Discussion

keep source format when pasting

5 Replies