Question: how to copy and paste in excel without losing formatting?
Answer: Select the cells whose contents you want to copy. Press Ctrl+C to copy them to the Clipboard. Select the cell where you want to paste the contents. Choose Paste Special from the Edit menu. ...  Make sure the Formulas radio button is selected. Click on OK.