As an example, you might have a list of product costs and want to increase the values to add a profit margin without creating a new column of data. Excel's Paste Special function can do just that ...