How to use Paste Special Effectively in Excel
There might be question in your mind: “What is the difference between Paste and Paste Special?” If you really had this question then you are reading perfect blog. This blog will help you to answer your question. Also we will see how we can use each and every option from Paste Special to reduce our time and efforts. We can say that Paste Special is subset of Paste. Both the Paste and Paste Special does the same thing (to paste the data) but “Paste Special” paste the data in a special way. So let’s see what these special options available in it are. YouTube Video Where we can find “Paste Special”? There are two ways by which we can reach up to Paste Special options. But for this we have to copy the data first which we want to paste. After we copy the data we can follow any of the below steps: 1. Click on the small downward arrow below “Paste” command in Clipboard group under Home Tab, we will see one option called as “Paste Special”. 2. Right click on any cell ...