![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |