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.