Paste Special Option in Excel | Part-2
![Paste Special Option in Excel | Part-2](https://mrcodings.com/wp-content/uploads/2023/06/MS-EXCEL-47-Paste-Special-Option-in-Excel-Part-2-Useful-Technique-for-Data-Entry-Data-Cleaning.jpg)
How to utilize various Paste Special Options such as All, Formula, Values, Formats, Comments, Data Validation, All using source theme, All except borders, Column width, Formulas and number formats, Values and number formats, Add, Subtract, Multiply, Divide, Skip blanks, Transpose, and Link.