Paste Special Feature in Excel (Paste Special Options)
You may choose to paste many different aspects of your copied data.
All
pastes all information in the copied cell; this is the default option
pastes all information in the copied cell; this is the default option
Formulas
pastes only the formula from the selected cell
NOTE: Any relative cell references within the formula are changed to reflect its new location.
pastes only the formula from the selected cell
NOTE: Any relative cell references within the formula are changed to reflect its new location.
Values
pastes only the result of the formula from the selected cell
pastes only the result of the formula from the selected cell
Formats
pastes only the formatting applied to the cell (e.g., font or color of the text)
pastes only the formatting applied to the cell (e.g., font or color of the text)
Comments
pastes only annotations that were made to the cell
pastes only annotations that were made to the cell
Validation
pastes any rules about what text can be entered in the cell (e.g., only numbers between 1 and 25)
pastes any rules about what text can be entered in the cell (e.g., only numbers between 1 and 25)
All except borders
pastes the formatting and contents of the cell, excluding any cell borders
pastes the formatting and contents of the cell, excluding any cell borders
Column widths
pastes only the width of the selected column
pastes only the width of the selected column
Formulas and number formats
pastes the formula from the selected cell and any formatting applied to numbers (e.g., number of decimal places displayed)
pastes the formula from the selected cell and any formatting applied to numbers (e.g., number of decimal places displayed)
Values and number formats
pastes the numerical result of the formula from the selected cell, as well as any formatting applied to numbers (e.g., number of decimal places displayed)
pastes the numerical result of the formula from the selected cell, as well as any formatting applied to numbers (e.g., number of decimal places displayed)
None
the values that are being pasted override any data already in the destination cells; this is the default option
the values that are being pasted override any data already in the destination cells; this is the default option
Add
adds the values that were copied to the data in the destination cells
adds the values that were copied to the data in the destination cells
Subtract
subtracts the values that were copied from the data in the destination cells
subtracts the values that were copied from the data in the destination cells
Multiply
multiplies the values that were copied by the data in the destination cells
multiplies the values that were copied by the data in the destination cells
Divide
divides the values that were copied by the data in the destination cells
divides the values that were copied by the data in the destination cells
Skip blanks
pastes the contents of all cells except for empty cells
NOTE: This option is only useful when pasting a range of cells into an area that already contains information. This will ensure that a blank cell will not be pasted in place of information that is already in place.
pastes the contents of all cells except for empty cells
NOTE: This option is only useful when pasting a range of cells into an area that already contains information. This will ensure that a blank cell will not be pasted in place of information that is already in place.
Transpose
causes information that extended down a column to extend across rows and vice versa
NOTE: If you select more space for the information to be pasted into than you have cells to be pasted, the information will be repeated to fill the selected space. For example, if you copy one column and paste it into four rows while using Transpose, the information from the column will be repeated in every row.
causes information that extended down a column to extend across rows and vice versa
NOTE: If you select more space for the information to be pasted into than you have cells to be pasted, the information will be repeated to fill the selected space. For example, if you copy one column and paste it into four rows while using Transpose, the information from the column will be repeated in every row.
Windows Only:
All using Source theme
when using a document theme, pastes all information using formatting from the theme that was applied to the copied cells
when using a document theme, pastes all information using formatting from the theme that was applied to the copied cells
Paste Link
connects the cells that were copied with the pasted cells; if the data in one group changes, so will the data in the other group
connects the cells that were copied with the pasted cells; if the data in one group changes, so will the data in the other group
0 comments:
Post a Comment