At my Fort Myers Florida Power Excel seminar, someone showed me a new way to Paste Values. Does this video show all possible ways?
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel from MrExcel podcast, episode, 1814.
Paste Values.
So, hey! As I mentioned us down in Fort Myers last week, and I learned this new way to paste as values.
So, let's just run through them, all right!
All of these methods over here.
we're going to use [ ctrl C ], first [ ctrl C ] and then typically you open the paste, hover and figure out which one is values there.
But there are faster ways to go, [ ctrl C ] and then [ alt E S B ].
[ Enter ] will do it, but the one that I learned in Fort Myers [ ctrl C ] and then [ ctrl alt V ], open space values, to [ V enter ].
I'm always been accused of never right-clicking, but if you right click then you have paste values right there.
My favorite one, the one that I use all the time [ ctrl C ] and then press the [ program ] key, [ V ].
Program key is to the right of the space bar, usually have the alt and then ctrl and then in between is the little key with the mouse symbol or if you want to do [ ctrl C ] and then [ ctrl V ] and then just [ ctrl ] alone and press [ V ], that will do it or hey, if you're not a mouse person at all.
Let's add some things to the quick access toolbar.
So, I right clicked here, instead add the quick access toolbar, to get the paste values though, I had a right click, customize, quick access toolbar and say all commands, scroll down to paste values and then click the [ add ] button, to bring it over here, so that method then becomes select everything and just hit the copy and then hit the paste values or here my favorite one.
Especially, if you're a person that uses the mouse a lot, select everything you don't even have to copy in this one, just go to the right edge, hold down the right mouse button, drag right, drag left, let go, copy here's values only, call the alternate.
Drag and drop menus, there you go.
Lots of different ways to paste values.
I bet you have one, how it's not here.
Go ahead and post that in the YouTube comments and a complete collection of, how to paste values.
Hey! I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
Learn Excel from MrExcel podcast, episode, 1814.
Paste Values.
So, hey! As I mentioned us down in Fort Myers last week, and I learned this new way to paste as values.
So, let's just run through them, all right!
All of these methods over here.
we're going to use [ ctrl C ], first [ ctrl C ] and then typically you open the paste, hover and figure out which one is values there.
But there are faster ways to go, [ ctrl C ] and then [ alt E S B ].
[ Enter ] will do it, but the one that I learned in Fort Myers [ ctrl C ] and then [ ctrl alt V ], open space values, to [ V enter ].
I'm always been accused of never right-clicking, but if you right click then you have paste values right there.
My favorite one, the one that I use all the time [ ctrl C ] and then press the [ program ] key, [ V ].
Program key is to the right of the space bar, usually have the alt and then ctrl and then in between is the little key with the mouse symbol or if you want to do [ ctrl C ] and then [ ctrl V ] and then just [ ctrl ] alone and press [ V ], that will do it or hey, if you're not a mouse person at all.
Let's add some things to the quick access toolbar.
So, I right clicked here, instead add the quick access toolbar, to get the paste values though, I had a right click, customize, quick access toolbar and say all commands, scroll down to paste values and then click the [ add ] button, to bring it over here, so that method then becomes select everything and just hit the copy and then hit the paste values or here my favorite one.
Especially, if you're a person that uses the mouse a lot, select everything you don't even have to copy in this one, just go to the right edge, hold down the right mouse button, drag right, drag left, let go, copy here's values only, call the alternate.
Drag and drop menus, there you go.
Lots of different ways to paste values.
I bet you have one, how it's not here.
Go ahead and post that in the YouTube comments and a complete collection of, how to paste values.
Hey! I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
