Question: how to copy excel sheet without losing formatting?
Answer: Display a source worksheet that has non-default formatting for rows and columns. Select a row or range of rows in the worksheet. ...  Click on the Format Painter in the Clipboard group. Display a target worksheet. Select the rows to which you want the formats applied.