Question: how to copy and paste in excel keeping 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. Choose the Formats radio button.