Keyboard Shortcuts for Paste Values, not formulas, in Excel by Chris Menard

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.
Here are several keyboard shortcuts for paste value:
1) Alt, H, V, V
2) Alt, E, S, V, Enter on the Mac this is Ctrl + Cmd + V
3) Menu key + V
4) Ctrl + V, Ctrl, V
5) Create a shortcut on the Quick Access Toolbar (QAT)
Chris Menard's Blog Post on Past Values Keyboard Shortcuts
chrismenardtraining.com/post/...
Microsoft Support Articles on Paste Special and Paste Values
Paste Values article
support.office.com/en-us/arti...
Paste Special article
support.office.com/en-us/arti...
Chris Menard's website:
chrismenardtraining.com
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ KZbin keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[@ovskihouse5278]

Big thanks 🙏

[@ChrisMenardTraining]

Welcome 👍

[@waterstraiter]

In some newer version it called "Keep Text Only"

[@kelikupafui3411]

You are amazing thank you

[@ChrisMenardTraining]

You are so welcome

[@chipdodge104]

Good info ! How about clicking on the Quick Toolbar Icon you created to 'Paste Values' ?

[@ChrisMenardTraining]

That would work! Thanks, Chip!

[@amit12000]

nice video

[@ChrisMenardTraining]

Amit, thank you. I appreciate it.

[@ggggg5657]

Nice

[@ChrisMenardTraining]

Thanks

[@charalamposkounes5071]

is there an automated way to do that? A formula maybe?

[@tomfarrar5091]

How about Control>Alt>V? That is another option.

[@ChrisMenardTraining]

Tom, that is a good one.