About This Shortcut
Display the Paste Special dialogue box – In Microsoft Office, pressing Ctrl + Alt + V activates the Paste Special dialogue box. A dialogue box appears from which you can select the method by which the clipboard’s contents will be pasted. Formats that are available for selection include plain text as well as RTF, HTML, and Unicode.
Keybord shortcut key:
- Window: Ctrl + Alt + V
- Mac: cmd+Ctrl+V
The following option you can select with the Paste Special Dialog box as shown below.
A = All
F = Formula
V = Values
T = Formats
C = Comments
N = Validation
H = All using source theme
X = All except borders
W = Column widths
R = Formulas and number formats
U = Values and number formats
D = Add
S = Subtract
M = Multiply
I = Divide
B = Skip blanks
E = Transpose