When do you use Paste Special, and which options are most important?

Use Paste Special to control exactly what is pasted. Key options are values, formulas, formats, column widths, transpose, and operations such as add / multiply. In modeling, values are used to break links or freeze outputs, formulas to extend logic, formats to standardize presentation, and transpose for reorienting data.