Paste Special in Microsoft Excel
Excel Tips and Tricks

Paste Special in Microsoft Excel

In this article, we have explained how to use Paste Special in Microsoft Excel. You will learn below features of Paste special in Excel

Paste as:

  1. All
  2. Formulas
  3. Values
  4. Formats
  5. Comments and Notes
  6. Validation
  7. All using Source theme
  8. All except borders
  9. Column widths
  10. Formulas and number formats
  11. All merging conditional formats

Operation:

  1. None
  2. Add
  3. Subtract
  4. Multiply
  5. Divide

Others:

  1. Skip blanks
  2. Transpose
  3. Paste Link
Paste Special in Microsoft Excel
Paste Special in Microsoft Excel

 

Watch the step-by-step video tutorial:

Click here to download the practice file

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com