Excel Intermediate Paste Special Options
INTERMEDIATE Paste Special Options
Learn to use Paste Special for Add Subtract Multiply Divide Values and Transpose operations in Excel.
Paste Special Options Overview
Paste Special provides options for controlling how copied worksheet content is pasted and for performing selected operations during the paste.
Using Paste Special to Add Subtract Multiply and Divide using Paste Special Values and using the Paste Special Transpose option.
Operations
Use Paste Special to Add Subtract Multiply or Divide.
Values
Paste the resulting values rather than the original formulas.
Transpose
Paste copied data with rows and columns switched.
Essential Terms
Review the terminology used with Paste Special options.
Paste Special Operations
Paste Special can perform arithmetic operations on copied values and destination cells during the paste process.
Add Subtract Multiply and Divide
Choose the required Paste Special operation according to how the copied value should affect the destination values.
Add
Add the copied value to the destination value.
Subtract
Subtract the copied value as part of the Paste Special operation.
Multiply
Multiply destination values using the copied value.
Divide
Divide destination values using the copied value.
Paste Special Values
The Values option pastes the displayed result of copied cells without carrying over the original formulas.
Copy the Source
Copy the cells whose resulting values are required.
Paste Values
Use Paste Special Values when the destination should contain the copied results rather than the source formulas.
Paste Special Transpose
The Transpose option changes the orientation of copied data by switching rows and columns when the data is pasted.
Interactive Paste Special Explorer
Compare the Paste Special options included in this topic.
Key Takeaways
Paste Special can perform arithmetic operations paste results as values and transpose copied data.
Select an operation when copied data should mathematically affect destination values.
Use Values when you need the copied results without the original formulas.
Use Transpose when copied rows should become columns or copied columns should become rows.
Knowledge Check
Test your understanding of Paste Special operations Values and Transpose.