Question: how to copy and paste an excel sheet and keep formatting?
Answer: Select the cell or cells whose format you wish to copy. Press Ctrl+C or press Ctrl+Insert. ...  Select the cell or cell range into which you want the formats pasted.