Keyboard shortcuts for Paste Special options

If you want to paste only a specific aspect of the copied data like its formatting or value, you would use one of the Paste Special options. After you’ve copied the data, press Ctrl+Alt+V, or Alt+E+S to open the Paste Special dialog.

Paste Special Dialog box

Tip:  You can also click Home > Paste > Paste Special.

To pick an option, press the underlined letter for that option. For example, press the letter C to pick the Comments option.

Pick this option

To

Keyboard shortcut

All

Paste all cell contents and formatting.

Press A

Formulas

Paste only the formulas as entered in the formula bar.

Press F

Values

Paste only the values (not the formulas).

Press V

Formats

Paste only the copied formatting.

Press T

Comments

Paste only comments attached to the cell.

Press C

Validation

Paste only the data validation settings from copied cells.

Press N

All using Source theme

Paste all cell contents and formatting from copied cells.

Press H

All except borders

Paste all cell contents without borders.

Press X

Column widths

Paste only column widths from copied cells.

Press W

Formulas and number formats

Paste only formulas and number formats from copied cells.

Press R

Values and number formats

Paste only the values (not formulas) and number formats from copied cells.

Press U

More on keyboard shortcuts

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×