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


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


  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

My Name is PK. I am founder of 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.