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.