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.