The Paste Special command is in most Office applications, but Excel users probably benefit from it the most. Using this basic feature — as well as assorted Paste options — you can make short work of a few common tasks and some rather complex problems. These tricks are so easy to implement that you’ll probably find yourself using the paste features a lot more than you used to.
In Excel 2007 and 2010, Paste is in the Clipboard group on the Home tab. In Excel 2003, Paste Special is on the Edit menu. For the shortcut enthusiasts, we’ve included a table at the end that contains keyboard shortcuts for most of these operations.
To Read More Vist the following link :– http://www.techrepublic.com/blog/10-things/10-powerful-ways-to-use-excels-paste-features/2902/