see: Paste Special

ie Copy -> Paste Special -> Values

(you can repeat the Paste Special operation 1+ times for one Copy command... ie to Paste Values & then say Column Widths etc...)