Learn How to Display Paste Special Dialogue Box With Shortcut in Microsoft Excel

Display Paste Special Dialogue Box With Shortcut in Microsoft Excel

Here we will show you how to display paste special dialogue box in Microsoft Excel. Like many other programs Microsoft Excel also uses similar key combinations while using the shortcut.

You can use the key combinations given below to paste content from the clipboard using the shortcut. You can use this shortcut to display the Paste Special dialog box. Paste Special is the gateway into many other powerful operations, that includes - paste Values, which you probably use every day. It should be noted that this shortcut only works when data has been copied to the clipboard.

For Windows users, once you have the Paste Special Dialog open, you can type a letter to select the particular command you want, as given below:

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

So here we go:

How to Display Paste Special Dialogue With Shortcut in Microsoft Excel?

You can use this shortcut to display the Paste Special dialog box. Paste Special is the gateway into many other powerful operations, that includes - paste Values, which you probably use every day. It should be noted that this shortcut only works when data has been copied to the clipboard. This way you can easily paste content from the clipboard using a shortcut.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel