If you want to preserve the formatting then right-click and choose Paste
Special then choose Values...(or Formulas if you also want to copy formulas)

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...

"Deriv001" wrote:

Occasionally when pasting between two 2007 spreadsheets, I will lose all the
formating on the spreadsheet I am pasting to. Is there a way to recover the
formats that are lost? (in this case, both files are open in the same Excel
2007 window)
Thank you