TechTutor TV: Use Paste Special in Excel 2007
The paste special command in Excel 2007 is a quick way that you can paste Excel data to get it to look exactly how you want - showing the formulas, values, formatting or anything in between. In this tutorial, you will learn how to copy and then paste the information special in an Excel 2007 worksheet.