Question: how to copy and paste in excel with 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., Choose Paste Special from the Edit menu. ... , Choose the Formats radio button., Click on OK.