![]() ![]() Note: “Paste special” option available only once data is copied.ġ- Copy the source cells or range. The Following screenshot demonstrates all the option available in Paste Specials. When standard copy/paste do not give appropriate results, Excel’s Paste special give a wide range of options in which we choose specials elements and mathematical elements.įor Example, if we do any calculation in to the cells and wanted to paste only it’s value in the same cell or somewhere in another sheet or we want to paste only the column width or paste only comments or wants to transpose the data or we can create a link between cells or between the sheets etc. ![]() Paste specials give you an opportunity to choose what we want to paste in cells. Do you know apart from only copy and pasting the whole content with formatting in Excel, we can paste a certain attribute such as Value only, Column Width, Formula only, formatting or comment in Excel.
0 Comments
Leave a Reply. |