Paste Special is a wonderful resource in Excel. There are so many options other than the standard paste ( Ctrl + V ), as you can see here:
The trick has always been launching the Paste Special dialog box. You would need to grab your mouse, right-click on the destination cell, and choose Paste Special:
Ah, but there’s a better, easier way. Instead of using your mouse, just use the keyboard shortcut:
This will bring up the Paste Special dialog box with all the various options at your finger tips!