Display the Paste Special Box

Using the Display the Paste Special Box Shortcut

Windows keyboard shortcut

 
Mac keyboard shortcut

This Excel shortcut opens the paste special dialog box for advanced paste options. Data must already be copied to the clipboard for this shortcut to work.

On Windows, the following Paste Special options are available. Pressing the corresponding letter will execute the command.

F = Formulas

V = Values

T = Formats

C = Comments

N = Validation

H = Use source theme for all

X = Everything except the border

W = Column widths

R = Formulas & number formats

U = Values & number formats

D = Add

S = Subtract

M = Multiply

I = Divide

B = Skip blanks

E = Transpose
Other useful General keyboard shortcuts