KEYBOARD SHORTCUTS - Paste Special as Values in Excel
Scroll down to see 4 Excel Paste Special as VALUES keyboard shortcuts, You won't want to miss them!
1. ALT + H + V + V
2. Control +ALT + V + V + Enter (opens the Paste Special dialogue box. Hitting the second V selects "values" in the dialogue box and enter closes the dialogue box)
Mac Version, CTRL+CMD+V, CMD+V, ENTER
3. Hover mouse over border of cells (before or after copying). Cursor turns to four sided arrow. RIGHT click and drag the selected cells somewhere else. When you release, a dialogue box pops up and you'll have the option to paste as values. BTW, you can also use this same strategy when LEFT clicking to copy/drag a group of cells anywhere else.
4. Right Click and Hit V Key (super fast and easy)
Thanks for learning Excel paste special shortcut keys with me. I hope you'll use these Excel tips and practice on your own version of Excel.
Click below to join one of my complete courses.
https://skl.sh/2mND2Sa
Click the above link to join the Complete Microsoft Excel Mastery Course for Beginners on SKILLSHARE.
https://www.udemy.com/course/how-to-u...
Click the above link to join EXCEL at Work - The Complete MS Excel Mastery Beginner to Pro course on UDEMY.
Join the thousands of other students who are learning Excel online in an easy, stress-free way.
Thanks so much for learning with me. I hope to see you in another video or course soon!
Sincerely,
Steve
Other Courses by Steve McDonald:
Microsoft Access Mastery for Beginners
https://www.udemy.com/course/microsof...
Photoshop for Beginners:
https://www.udemy.com/course/photosho...
Excel VBA for Beginners (taught by my co-instructor, and aerospace engineer, Gillian Werner):
https://www.udemy.com/course/vba-mast...