Paste Special in MS-Excel
Paste Special in MS-Excel Paste Special in MS-Excel provides many options. When we copy any data and simply paste it to some other cell it is copied with all its settings such as formula, font size, comments, etc. which are in it. But Paste Special provides us the facility to not to copy things which we don't want. Here I would try to describe all basic points. First of all we will see how Paste Special looks like when we copy any data and open the Paste Special Window. It may differ from the type of data copied. Here we can see under paste many things are written. I have already described all above. Formulas: When we copy a cell which contains formula and we want to only paste that formula on a particular cell we use this. Value: When we want to copy the value in cell to any other place than we have to use this. Formats: This is used to copy the formatting of a cell to another cell. For example if we have changed the font size of a cell or change the forma...
Comments
Post a Comment