The fastest way to cut, copy and paste is by using the keyboard shortcuts Ctr+X, Ctr+C and Ctr+V. Ctrl+V performs the basic paste operation — and includes the formulas and formatting, if any. But sometimes you want to do more — or less — when pasting. And pasting can be used in ways you’ve never imagined. Enter Paste Special.
The animation below shows some of the neat things Paste Special can do in Excel: pasting just values (no formatting or formulas), pasting a picture (that you can move around) and pasting formatting onto other numbers.