5 Quick Keyboard Shortcuts To Paste Values In Excel

Learn 5 different keyboard shortcuts to paste values in Excel. Copy and paste values is probably one of the most common tasks we do in Excel. There are a lot of different ways to perform this action. In this video we look at the following 5 keyboard shortcuts:

1. Alt, E, S, V, Enter
2. Alt, H, V, V
3. Menu Key + V
4. Custom Quick Access Toolbar (QAT) Button
5. Ctrl+V, Ctrl, V
6. Custom shortcut with The Paste Buddy Add-in

Which shortcut is your favorite? Please leave a comment below with the shortcut that you use.

There is no right/wrong answer. Everyone has their own preference. Thank you! :-)

Additional Resources:

00:00 Introduction
00:13 Alt ESV Enter
01:26 Alt H V Enter
01:50 Menu Key V
02:44 Quick Access Toolbar
04:06 Control V
04:45 Paste Buddy

[pmjuliff]

Menu V is great, also like the custom QAT shortcut, thanks so much!

[VineStVideos]

Thanks, Jon, for creating these videos! As an accountant I use Excel all day and the knowledge I learned from your videos has helped me do my job quickly and more efficiently.

I use right click, V. I just realized that I have a Menu Key so my new favorite will now be 3. Menu Key+V!

[partofbeingme]

MENU+ V and ALT+1 were my favorite shortcuts. Thank you so much!!!

[clitz]

YAY!!! Thankyou, you have saved me alot of time with these key shortcuts. Menu + V was the one i needed. :D

[kennykenny]

This a lot for the sharing.. Another eyes opening for keyboard short cut

[MrLinox]

I use number 5 when I'm working on 1 same workbook. When I try to copy and paste from another open workbook I usually ecounter issues, that's why i go with values without formating but I haven't found a shortcut for this process.
Thank you for your videos.

[wayneedmondson]

Hi Jon.. thanks for the various ways to Paste Values. My goto has always been Ctrl+Alt+V, V, Enter, although after watching your video, I like Alt, H, V, V, since it reinforces the Alt key sequence for the ribbon menu and is a little shorter. Note that for people who don't have a menu key on the keyboard, Shift+F10 will activate the right-click shortcut menu. So, Shift+F10, V will work like Menu Key, V. Thanks and thumbs up!

[Metqa]

Thank you So much. This has been on my mind for ages when I have to copy values from one line to another. right click is fine but there has to be a keyboard shortcut. It is a lot more involved that I expected. the fastest one being Menu+V requiring me to relocate my entire hand across the keyboard or move my hand from the mouse, so I guess I'll need to memorize the multi keycombo letters.

[paulsastroutomo]

Jon, thanks for you tutorial, I like custom QAT but better to memorize Ctrl V + Ctrl V so I won't have any problem when moving around to other computers

[abdullahsayed]

Thanks a lot. You saved a lot of time. I will use Menu +V key

[PootLoops]

Probably just saved my fingers, thank you. Was going to crack out my keyboard, but then the alt+1 method makes it a cinch!

[khunkhang]

HI Jon, Thank you for your SC tips. I most prefer the traditinal short cut = Alt + H+V+V

[EricHartwigConsulting]

Awesome video Jon!
I really enjoy all of your tips, tricks, advice and knowledge sharing.

[eddykanhk]

Very good information with clear explanation.

[redstar]

If you have a large spreadsheet, Ctrl+V, Ctrl, V can be very slow. Ctrl+V pastes the formulas and the sheet recalculates. Ctrl, V pastes the original values.

[EricRamsey]

I use the Custom QAT method, but I add Copy as (1) and Paste Values as (2). This way my left thumb can stay at the Alt key, and I can process a lot of data quickly by just pressing it + 1 and 2.

[bmkrishan]

Menu & V is the short way. thank you.