Question: how to copy and paste on excel and keep same format?
Answer: Select the cell or cell range into which you want the formats pasted. Choose Paste Special from the Edit menu. Excel displays the Paste Special dialog box.