Paste Special | Most powerful command in excel | You must watch | Excel Tutorial in Hindi - 9
Paste Special can paste only Values, Formats, Validation, Border, Column Width, Formula differently from copied contents.
In this video I have described that how to use Paste Special. You can paste different elements from copied contents. For example, if you want to paste only formats from any part of sheets and don't want to paste its value, formula or any other elements then Paste Special can paste only Formats. In the same way you can paste only Values, Validation, Formula, Borders differently. Paste Special can also Skip the Blanks, Transpose the data, and create links between source and target ranges. So, Paste Special is a very powerful function of Excel and it enhance the normal Paste command.
Watch video Paste Special | Most powerful command in excel | You must watch | Excel Tutorial in Hindi - 9 online without registration, duration hours minute second in high quality. This video was added by user Excel & VBA Expert Online 05 November 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9 once and liked it 0 people.