Walk through how to use Paste Special to customize the data, values, and format of the area you copied in Excel.