Question: how to copy and paste a table 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.