Question: how do you copy and paste and keep formatting in excel?
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.