What does Paste Special as values do?
This article is based on legacy software. Show Excel allows you to paste only specific aspects of cell data by using the Paste Special feature. For example, if you want the results of a formula but no longer need the formula itself, you can choose to paste only the value found as a result of the formula. The Paste Special option does not apply to cut data; a cell must be copied in order to take advantage of this feature. A variety of data aspects can be pasted using the Paste Specialcommand. Using the Paste Special Dialog BoxThe Paste Special dialog box allows you to select which aspects of the copied data you would like to paste.
Paste Special OptionsYou may choose to paste many different aspects of your copied data. All Formulas Values Formats Comments Validation All except borders Column widths Formulas and number formats Values and number formats None Add Subtract Multiply Divide Skip blanks Transpose Windows Only: All using Source theme Paste Link What does Paste Special values mean?Paste Special is a feature gives you more control of how the content is displayed or functions when pasted from the clipboard. Paste special is a common feature in productivity software such as Microsoft Office and OpenOffice.
What is the use of Paste Special?When you copy text that has different formatting into an Office program, the program, such as PowerPoint or Word, automatically reformats that text to match the text of the destination. However, you can use Paste Special to maintain the original formatting or paste it as a link or a picture, for example.
What are Paste Special options?These options enable you to paste selectively. For example, you can choose to only paste formulas, or values, or formats, or comments, etc. To use these, simply copy the cells, go the cell where you want to paste it, open the paste special dialogue box, and select the desired option.
|