Is there a shortcut key for pasting values only?

Excel doesn’t have a shortcut key for copying and pasting only the values. You can quickly do this by using the Paste Special option. Here’s how:

  1. Select cells that have the values you want to copy and press Ctrl+C.

  2. Click the upper-left cell of the paste area and press Ctrl+Alt+V.

  3. To pick Values press V, and then press Enter.

    Paste Special dialog box with Values option selected

  4. You can also use Ctrl+C > Alt+E+S+V.

For more shortcuts, see Keyboard shortcuts in Excel.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!