Question: how to copy and paste in excel and keep destination formatting?
Answer: Now when you copy a cell or range, you can just use Alt+4 (assuming the new button is the fourth in the Quick Access Toolbar) to paste wherever you want and keep the destination formatting. In Excel 2013, use the ordinary Ctrl+V shortcut, then press Ctrl, then press M.