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:
Best Keyboards for Excel: www.excelcampus.com/keyboard-...
2 Ways to Assign Keyboard Shortucts to Macros: • How To Assign Keyboard...
The Paste Buddy Add-in: www.excelcampus.com/paste-buddy/
Mouse Shortcut to Paste Values with Right-click & Drag: • Quickly Paste Values I...
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

[@karolinabobrik7953]

Oh dear GOD, menu key+ V just saved me tons of time at work . Thank you so much

[@partofbeingme4579]

MENU+ V and ALT+1 were my favorite shortcuts. Thank you 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!

[@ExcelCampus]

Awesome! Thanks Bobby! 👍

[@clitz1413]

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

[@kennykenny5833]

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

[@ExcelCampus]

Thanks Kenny! 🙂

[@dinceraydin40]

Very comprehensive! Thank you!

[@thevirginmary416]

This has helped me a lot ty Jon

[@marcwert9552]

Menu + V - Love it!

[@jefman88]

Very informative! Thank you!

[@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!

[@do7625]

Thanks for Mac shortcuts!

[@NinjaDav3]

awesome man

[@abdullahsayed5376]

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

[@eddykanhk]

Very good information with clear explanation.

[@biswajitnag910]

Fantastic.

[@random_vids008]

Thank you so much for your help.

[@VE3MDK]

Thanks dude

[@josuegomez3352]

Terrific video! Thank you very much

[@ajitsomaiya]

Thank you Jon - I was looking for a Paste Value shortcut key like google sheet. I liked Menu + V and CTRL+V, CTRL, V the best. I loved your video as it's precise & concise. Alreay liked the video and subscribed to your channel :)

[@ExcelCampus]

Thanks for your feedback! 😀

[@akthammusa3336]

Thank you so much

[@ExcelCampus]

You're welcome, @akthammusa3336! 😀

[@wayneedmondson1065]

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!

[@ExcelCampus]

Thanks Wayne! I forgot to mention the Shift+F10 alternative to the menu key. I appreciate you pointing that out. 🙌

[@EricHartwigConsulting]

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

[@ExcelCampus]

Thanks Eric! I appreciate your support! 🙂

[@kumudjha2122]

Superb 👍

[@khunkhang6118]

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

[@plabonbirohi]

thanks a lot

[@maheshsanghani6380]

very good and useful.Thanks !!!

[@shetkar911]

Thanks a lot, this is very helpful

[@paulsastroutomo4273]

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

[@maheshsanghani6380]

GOOD WAY TO EXPLAIN . THANKS

[@aryancricketclubpartnersof5097]

Terrific and clear explanation

[@josephrichman1624]

Alt 1 was great!

[@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.

[@MrLinox92]

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.

[@stef01885]

REALLY HELPED THANKS

[@vinodkumarkeri7905]

Thank you it helped me a lot

[@tonykomery7991]

thank you

[@muhammadriaz9148]

Thanks very informative tutorial

[@ferdoushasan1534]

Excellent Brother, Your way of presentation is super.

[@Pkp2902]

Good job

[@rajujathar8209]

Great Sir, its too Use Full.

[@prosunmukherjee7005]

Thanks

[@sunilkumar-id5nm]

ctrl v ctrl v is cool,, also alt 1

[@sarakul6119]

Thank you very much for useful explanation ❤

[@ExcelCampus]

You're welcome @sarakul6119 😊

[@bmkrishan400]

Menu & V is the short way. thank you.

[@psualum6379]

#4 or #5 - THANKS for the tips.

[@salimmohammad8575]

Alt+1 method makes my work complete supersonic

[@southeanehem5707]

that’s helps me alot

[@archanarani2439]

amazing

[@Alloverclip]

great and trhanks

[@uscorp7073]

I LOVE YOU

[@MrDadcard]

Awesome I was like just Ctrl v but I see why you just didn't use that but didn't realize that, it was just values

[@gwendolynmoore8324]

NUMBER 1 IS MY FAVORITE

[@bundabergcomputerclub6008]

I will probably end up using 5. Ctrl+V, Ctrl, V as I use a lot of computers and this will be universal. I do like 4. Custom Quick Access Toolbar (QAT) Button very easy to hit Alt 1. 1. Alt, E, S, V, Enter does not work on Office 2021 On a laptop you can at least on my machine hit Shift F10 to bring up the context menu ie the same as hitting the menu key. However as I have the function keys in priority to the F keys, I would have to hit Fn + Shift + F10, V, Enter. (too many keys) As I said I'd rather hit Alt 1 if I always used the same machine or Ctrl+V, Ctrl, V Thank you for your video most helpful. Regards Damien

[@redstar5607]

Thanks for your comment! My keyboard doesn't have a picture of the menu key, but Fn+Shift+F10 works.

[@redstar5607]

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.

[@Shekhar7870]

Thank

[@kylebuggie]

Great video, Jon! Do you have any advice on the SENDKEYS method you mentioned? I am curious if there are any best practices incorporating that in macros. Also, are there other ways to retain clipboard history while using VBA?

[@ExcelCampus]

Thanks Kyle! The SendKeys method can be a bit buggy. I've done extensive testing with it to get it to work fairly reliably in my Paste Buddy Add-in. You have to add a little bit of wait time between the send keys when mimicking Alt, E, S, V, Enter. There is a developer version of Paste Buddy (www.excelcampus.com/paste-buddy/) where you can see all the VBA code that makes it work. I will also add this to my list for future posts and videos. It's a great workaround to retain the undo history for a lot of tasks. There aren't many other ways to retain undo history that I know of with Excel. VBA pretty much clears it on any action that modifies the workbook, due to the complex nature of the formula dependencies and calc engine. I hope that helps. Thanks again and have a nice weekend! :-)

[@kylebuggie]

@@ExcelCampus Thanks Jon! I will check out developer version. Careful with the use of the word "buggy". I am somewhat sensitive to the negative connotation. ;-) Just kidding. Thanks for the great videos!

[@johnmccormick2883]

Control V ctl V for me easiest to remember!

[@VipulKarkar]

Option 5 is 1st favorite and option 3 comes 2nd

[@ClintSevilla]

Menu v is the best

[@simoiyahector-morales3781]

Menu V is my fave and alt esv

[@BGHmariam]

Menu Key +V

[@mianabubakrshuja]

No. 2

[@sabizaidi6519]

Best

[@joem112]

I use 1

[@Trouble1354]

All browsers use control-shift-V as Paste Format-Free text. Microsoft Word can be made to do the same thing. But how can that be done with Excel? Or do we need to install Steve Miller's PureText for Windows?

[@ThePrabhu666]

QAT is best

[@arteogr]

5. Ctrl+V, Ctrl, V

[@yokowasis]

I didn't that see that double ctrl+v coming. The others are history

[@thatslikeadollaranhour]

I have a menu key but it's not working for menu+V. The key says Menu (and Fn), it doesn't look like the key in the video. Is the Fn messing it up? I'm on MS 365.

[@Shippersmallcom]

I like CNRL = SFT = V, I looked at my quick access toolbar and paste values wasn't on the menu. I guess things have changed since 2019

[@vpant]

1st option - alt,e,s,v

[@eduardonozawa1935]

Have you managed the Numlock bug with Sendkeys on VBA? How?

[@nkenyirene1611]

Ctrl V Ctrl V

[@hanesking3078]

Hello sir I lost some paste option how can I bring it back I only have 2 paste option

[@rendalkepanduan6690]

how can i use VBA macro in my excel?

[@JorgePicco]

Or or, after pasting just pres Ctrl key and the menu will be displayed.

[@PankajKumar-yn3lx]

greate is 4

[@ajtarb]

Thanks Jon - love your tutorials. I’m gonna use the number 3 option, menu V. Thanks again

[@waterdamagerestoration4490]

Do: 1. Alt, E, S, V, Enter 2. Alt, H, V, V Still work with excel in 2021. Im not getting the same result as you. I dont have any of the symbols you have on the h, v, v as you have on number 2. And I am not able to paste in the numbers with decimals with number 1. With number 1 I just get the choices; HTML, unicode text and "text".

[@kailash680]

All this might work in your English Excel, but not in mine!

[@chetanchavan7600]

,c,v wow

[@evangelle82]

#3 Menu key + V.... WHAT... I should have checked this a year ago at least... would have saved me time! :/

[@AlanGovan-np4nq]

Anyone else trying to add Paste Values to the Quick Access Toolbar and tearing their hair out because it doesn't appear under "All Commands" will be relieved to find that it's been helpfully renamed by Microsoft as "Values [Paste Values]"

[@JonathanExcels]

just being fussy but menu acceleration and shortcut keys are not the same thing.

[@ExcelCampus]

Thanks Jonathan. I'm used to calling them accelerator keys, as this is what they are called in VBA userforms and Windows forms in general. The underlined letter in the option/control can be programmed with the Accelerator property...

[@JonathanExcels]

@@ExcelCampus As I said, I was just being fussy. your video is great! For people that see how fast I can accomplish tasks and want to learn more efficient methods I teach: 1) one button shortcuts like F5 vs Ctrl+g or F12 2) left handed short cuts like Ctrl+c or Ctrl+x or Ctrl+v because you can navigate with the other hand and arrow keys 3) two handed short cuts like Ctrl+Shift+down arrow 4) menu acceleration like Alt, h, v, v (old school Alt, e, s, v) 5) combinations like the sequence F5, Alt+s, k 6) context menu (with our without mouse) 9) mouse (although the mouse does excel in specific in stances like autofill) Not sure if it was 'Mr Excel' or 'Excel is fun' or someone else that coined the phrase "productivity killer" in reference to the mouse but I agree.

[@p_roduct9211]

@@JonathanExcels love this excel knowledge sharing - it's likely I will never meet anyone to discuss this with in the wild. Thanks for sharing

[@abomohnd9004]

Good job