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: https://www.excelcampus.com/keyboard-shortcuts/best-keyboards-for-excel-keyboard-shortcuts/
2 Ways to Assign Keyboard Shortucts to Macros: https://youtu.be/w_d6HzylJ3Q
The Paste Buddy Add-in: https://www.excelcampus.com/paste-buddy/
Mouse Shortcut to Paste Values with Right-click & Drag: https://youtu.be/sVagS3j1ryI
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