Excel Paste Values Shortcut

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on October 19, 2023

This tutorial will demonstrate the shortcuts to Paste Values in Excel.

Paste Values Shortcuts

Pasting Values

  • Pasting Values is useful when you would like to copy a formula and paste just it’s value.
  • This gets rid of the formula and format. It just pastes the text, as shown below.

Pasting Values

Paste Values is found within the Paste Special Menu:

Paste Values Options

Paste Values Shortcut

  1. Click on the cell to copy and use Ctrl + C to copy the cell.

Copy Values

  1. Click where you’d like to paste and use the shortcut:
    PC Shortcut: Ctrl+ALT+V>V>Enter
    Mac Shortcut: Ctrl++V>+V>Return
  • CTRL + ALT + V will display the Paste Special Menu.
  • V will select Values.
  • Enter will perform the paste operation.

Paste Special Opcions

Your final value will be as shown below, with no formula or format.

 

Paste Values Result

AI Formula Generator

Try for Free