Look at your various paste options
How to cut, copy and paste in Excel 2007. Copy cells within worksheets, or to other worksheets.
Clear the contents of cells, the format, contents or comments
