Keyboard shortcuts for Paste Values in Excel

Posted on:  09/28/2019
Keyboard shortcuts for Paste Values in Excel
Paste Values in Excel is an excellent feature. It copies only the value of a cell, not the formula. When you copy a cell with a formula and paste, the formula gets pasted. Frequently, you want just the value.
 
Paste Values does not copy formatting or formulas. If you copy and paste, and the destination cells contain formatting, paste values will take the formatting.
 
My two favorites are number 3 and number 5 below, but you have plenty of options if you don't like those two options.

Keyboard shortcuts for paste values

  1. Alt, H, V, V
  2. Alt, E, S, V, Enter (on the Mac this is Ctrl + Cmd + V)
  3. Menu key + V - the Menu key is to the right of the spacebar. Note: not all keyboards have a menu key.
  4. Ctrl + V, Ctrl, V
  5. Create a shortcut on the Quick Access Toolbar (QAT)

The Quick Access Toolbar sits above the ribbon in Excel, Word, PowerPoint, and Outlook. The Quick Access Toolbar is a customizable toolbar that contains a set of commands that are independent of the tab on the ribbon that is currently displayed.

Steps to customize the Quick Access Toolbar

  1. Click File, then click Options.
  2. Click Quick Access Toolbar.
  3. Change from Popular to All Commands.
  4. Click the command you want to add.
  5. Click Add.
  6. Click OK.

YouTube Video on Keyboard Shortcuts for Paste Values

Microsoft Support Articles on Paste Special and Paste Values

Paste Values article

https://support.office.com/en-us/article/paste-values-not-formulas-12687b4d-c79f-4137-b0cc-947c229c55b9
 

Paste Special article

https://support.office.com/en-us/article/keyboard-shortcuts-for-paste-special-options-c31b7c9e-69ce-4b60-8c3a-dc5ea10d872c
Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories