excel shortcut keys for paste special values

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.

Excel shortcut keys for paste special values