In this video you will learn how to use special paste in excel in detail. We will cover topic in this video are below. Paste data, Paste formats, Paste formulas, Paste Comments, Paste Validation, Paste all using source theme, Paste all except borders, Paste column width Paste formulas and number formats, paste values and number formats all merging conditional formats use operations use skip blanks use rows and columns transpose