Links the pasted data from the copied cell or range to the new cell or range.Д¬opying Between Cells, Worksheets and WorkbooksДepending on what is on the clipboard and where it was copied from will influence what dialog box is displayed. If you don't want the formulas adjusted then make sure your formulas are absolute references. If you want to transpose cells containing formulas, then the formulas and cell references and adjusted. The paste area must be outside the copy area. Copy the cell range you wish to transpose and before pasting choose (Edit > Paste Special) and select the Transpose check box. Transposing your rows and columns can be easily done. If you transpose cells that contain formulas then the formulas are automatically adjusted. This is useful as it allows you to overwrite selected cells without overwriting all the cells. This prevents you from pasting in a blank value over a cell that already contains something. If you are copying data onto existing data then any blank cells in the copy range will not be pasted. This will ignore any blank cells that have been included in the copied range. Divides the current selection by the value (or values) that have been copied. Multiplies the current selection by the value (or values) that have been copied.Дivide - (I). Subtracts the value (or values) that have been copied from the current selection. Adds the value (or values) that have been copied to the current selection. None - This is the default and no mathematical operations are performed on the current selection.ДЄdd - (D). The data is not overwritten but is combined to produce new values. These four operations allow you to combined the contents of the copy area and the paste area. This does not copy the formulas.ДЄll merging conditional formats - (Added in 2010). Pastes only the values and their number formats.

This is useful when copying values to cells that are already formatted. Pastes only the formulas and their number formats. Pastes only the column widths from the copied range of cells.ДЇormulas and Number Formats - (R). Pastes only the data, the borders or formatting are not changed.Д¬olumn Widths - (W). Pastes all cell contents in the document theme formatting that is applied to the copied data.ДЄll Except Borders - (X). Pastes only the Data Validation rules attached to the copied range of cells.ДЄll Using Source Theme - (L). Pastes only the comments attached to the copied range of cells. Pastes only the format attached to the copied cells.Д¬omments - (C). Pastes only the static values and text or the displayed values resulting from formulas.ДЇormats - (T). Pastes only the formulas, any relative references are adjusted automatically. This is the same as just using the Paste command.ДЇormulas - (F).

Pastes all aspects of the cell, values, formulas, formats, formatting etc.

You can also use the shortcut key (Alt + E, S).ДЄll - (A). If you want to quickly access this dialog box using a shortcut key, press (Ctrl + Alt + V) followed by the letter in parentheses. The most useful feature is probably the ability to copy the values of cells without copying the formulas or formatting. The Paste Special dialog box is extremely useful.

Paste and transpose excel shortcut