Excel Basic | Copy Paste | Paste Special | Lesson 8
Cell contents or attributes (formulas, formats, comments, and validation) can be copied from one to another
By default, if you use the Copy and Paste Options button icons (CTRL + C and CTRL + V), all attributes are copied.
To pick a specific paste option, you can either use a Paste menu option or select Paste Special,
and pick an option from the Paste Special box. Attributes other than what you select are excluded when you paste.
Paste:
Formulas: Only the formulas.
Formulas & Number Formatting: Only formulas and number formatting options.
Keep Source Formatting: All cell contents and formatting.
No Borders: All cell contents and formatting except cell borders.
Keep Source Column Widths: Only column widths.
Transpose: Reorients the content of copied cells when pasting. Data in rows is pasted into columns and vice versa.
Paste Values: Only the values as displayed in the cells.
Values & Number Formatting: Only the values and number formatting.
Values & Source Formatting: Only the values and number colour and font size formatting.
Formatting: All cell formatting, including number and source formatting.
Paste Link: Link the pasted data to the original data. When you paste a link to the data that you copied, Excel enters an absolute reference to the copied cell or range of cells in the new location.
Paste as Picture: A copy of the image.
Linked Picture: A copy of the image with a link to the original cells (if you make any changes to the original cells those changes are reflected in the pasted image).
Column widths: Paste the width of one column or range of columns to another column or range of columns.
Merge conditional formatting: Combine conditional formatting from the copied cells with conditional formatting present in the paste area.
Paste Special Options:
All: All cell contents and formatting, including linked data.
Formulas: Only the formulas.
Values: Only the values as displayed in the cells.
Formats: Cell contents and formatting.
Comments: Only comments attached to the cell.
Validation: Only data validation rules.
All using Source theme: All cell contents and formatting using the theme that was applied to the source data.
All except borders: Cell contents and formatting except cell borders.
Column widths: The width of one column or range of columns to another column or range of columns.
Formulas and number formats: Only formulas and number formatting.
Values and number formats: Only values and number formatting options from the selected cells.
All, merge conditional formats: Combine conditional formatting from the copied cells with conditional formatting present in the paste area.
Operation options:
None: Paste the contents of the copy area without a mathematical operation.
Add: Add the values in the copy area to the values in the paste area.
Subtract: Subtract the values in the copy area from the values in the paste area.
Multiply: Multiply the values in the paste area by the values in the copy area.
Divide: Divide the values in the paste area by the values in the copy area.
Skip Blanks: Avoid replacing values or attributes in your paste area when blank cells occur in the copy area.
Transpose: Reorients the content of copied cells when pasting. Data in rows is pasted into columns and vice versa.
Paste Link: If data is a picture, links to the source picture. If the source picture is changed, this one will change too.
I have aim to publish educational videos with maximum amount of knowledge and minimum consumption of time.
#Excel #PasteSpecial #HarisKhan