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.