Question: how do you 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. Excel displays the Paste Special dialog box. (See Figure 1.)
Make sure the Formulas radio button is selected.
Click on OK.