5 Quick Keyboard Shortcuts To Paste Values In Excel

Подписаться 572 тыс.

Просмотров 153 тыс.

50% 1

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

Опубликовано:

20 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 105

@pmjuliff 9 дней назад

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

@partofbeingme4579 3 года назад

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

@karolinabobrik7953 4 года назад

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

@VineStVideos 5 лет назад

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 5 лет назад

Awesome! Thanks Bobby! 👍

@clitz1413 3 года назад

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

@PootLoops 4 года назад

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

@dinceraydin40 Год назад

Very comprehensive! Thank you!

@thevirginmary416 4 года назад

This has helped me a lot ty Jon

@Metqa 8 месяцев назад

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.

@abdullahsayed5376 3 года назад

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

@paulsastroutomo4273 4 года назад

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

@jefman88 3 года назад

Very informative! Thank you!

@EricHartwigConsulting 5 лет назад

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

@ExcelCampus 5 лет назад

Thanks Eric! I appreciate your support! 🙂

@kennykenny5833 5 лет назад

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

@ExcelCampus 5 лет назад

Thanks Kenny! 🙂

@MrLinox92 5 лет назад

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.

@josuegomez3352 4 года назад

Terrific video! Thank you very much

@VidFusion_008 2 года назад

Thank you so much for your help.

@khunkhang6118 2 года назад

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

@wayneedmondson1065 5 лет назад

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 5 лет назад

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

@eddykanhk 2 года назад

Very good information with clear explanation.

@do7625 3 года назад

Thanks for Mac shortcuts!

@shetkar911 2 года назад

Thanks a lot, this is very helpful

@ferdoushasan1534 4 года назад

Excellent Brother, Your way of presentation is super.

@maheshsanghani6380 2 года назад

very good and useful.Thanks !!!

@user-jk5en4qg1s 11 дней назад

thank u for sharing these ideas

@aryancricketclubpartnersof5097 2 года назад

Terrific and clear explanation

@maheshsanghani6380 3 года назад

GOOD WAY TO EXPLAIN . THANKS

@vinodkumarkeri7905 3 года назад

Thank you it helped me a lot

@stef01885 5 лет назад

REALLY HELPED THANKS

@muhammadriaz9148 2 года назад

Thanks very informative tutorial

@marcwert9552 7 месяцев назад

Menu + V - Love it!

@rajujathar8209 3 года назад

Great Sir, its too Use Full.

@psualum6379 4 года назад

#4 or #5 - THANKS for the tips.

@josephrichman1624 5 лет назад

Alt 1 was great!

@sarakul6119 9 месяцев назад

Thank you very much for useful explanation ❤

@ExcelCampus 9 месяцев назад

You're welcome @sarakul6119 😊

@EricRamsey 3 года назад

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.

@biswajitnag910 3 года назад

Fantastic.

@NinjaDav3 2 года назад

awesome man

@VE3MDK 2 года назад

Thanks dude

@MrDadcard 5 лет назад

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

@salimmohammad8575 4 года назад

Alt+1 method makes my work complete supersonic

@ajitsomaiya 2 месяца назад

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 2 месяца назад

Thanks for your feedback! 😀

@plabonbirohi 2 года назад

thanks a lot

@redstar5607 9 месяцев назад

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.

@bmkrishan400 Год назад

Menu & V is the short way. thank you.

@southeanehem5707 5 лет назад

that’s helps me alot

@Alloverclip 4 года назад

great and trhanks

@tonykomery7991 4 года назад

thank you

@abomohnd9004 5 лет назад

Good job

@kylebuggie 5 лет назад

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 5 лет назад

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 5 лет назад

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

@kumudjha2122 3 года назад

Superb 👍

@prosunmukherjee7005 4 года назад

Thanks

@sunilkumar-id5nm 3 года назад

ctrl v ctrl v is cool,, also alt 1

@archanarani2439 2 года назад

amazing

@akthammusa3336 Год назад

Thank you so much

@ExcelCampus Год назад

You're welcome, @akthammusa3336! 😀

@gwendolynmoore8324 2 года назад

NUMBER 1 IS MY FAVORITE

@Shekhar7870 2 года назад

Thank

@bundabergcomputerclub6008 2 года назад

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 9 месяцев назад

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

@johnmccormick2883 2 года назад

Control V ctl V for me easiest to remember!

@VipulKarkar 5 лет назад

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

@Trouble1354 2 года назад

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?

@simoiyahector-morales3781 5 лет назад

Menu V is my fave and alt esv

@uscorp7073 3 года назад

I LOVE YOU

@Shippersmallcom 2 года назад

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

@eduardonozawa1935 3 года назад

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

@ClintSevilla 3 года назад

Menu v is the best

@thatslikeadollaranhour 8 месяцев назад

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.

@rendalkepanduan6690 3 года назад

how can i use VBA macro in my excel?

@mianabubakrshuja 5 лет назад

No. 2

@hanesking3078 2 года назад

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

@joem112 5 лет назад

I use 1

@BGHmariam 5 лет назад

Menu Key +V

@yokowasis 5 лет назад

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

@sabizaidi6519 Год назад

Best

@JorgePicco 4 года назад

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

@waterdamagerestoration4490 3 года назад

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".

@arteogr 5 лет назад

5. Ctrl+V, Ctrl, V

@ThePrabhu666 3 года назад

QAT is best

@nkenyirene1611 5 лет назад

Ctrl V Ctrl V

@vpant 5 лет назад

1st option - alt,e,s,v

@evangelle82 4 месяца назад

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

@kailash680 5 лет назад

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

@PankajKumar-yn3lx 5 лет назад

greate is 4

@ajtarb 5 лет назад

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

@chetanchavan7600 2 года назад

,c,v wow

@AlanGovan-np4nq 3 месяца назад

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 5 лет назад

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

@ExcelCampus 5 лет назад

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 5 лет назад

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