Paste Special Option in Excel | Part-2
MS-EXCEL-47-Paste Special Option in Excel | Part-2 | Useful Technique for Data Entry & Data Cleaning
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.