One of the best features in Office 2010 is the new Paste Options flyout menu. This episode takes a look at how to leverage the Paste Options menu.
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Excel 2010 In Depth chapter 3 – The Paste Options Flyout!
-Back to the MrExcel netcast, I'm Bill Jelen.
Again, down here in Trinidad, working on podcasts for the new “Excel 2010 In Depth” book.
This little feature is one that Microsoft probably would never talk about, but it is one of my favorite features, and almost becomes the one feature in Excel 2010 that I don’t think I can live without.
Alright, so here’s what I’m going to do, Ctrl+C to copy, and Ctrl+V to paste, and that little menu there has popped up before, but now they say “Hey, you could open it using Ctrl.” I’ve never opened it before because you had to reach for the mouse, but now that I can open it using Ctrl, I see that there's good stuff in there, like Paste Values has a shortcut key of V!
And, you know, some other ones, like Paste Transpose has a shortcut key of T.
So I actually built myself a table of what all of these shortcut keys do, and then came through- Basically my new favorite shortcut is Ctrl+C to copy, Ctrl+V to paste, Ctrl alone to open that drop-down, and then V to Paste values, very fast way to change to values. OK now, let me undo that. If you’re a mouse person, the good thing about using a mouse, it will do a Ctrl+C to copy.
And then when we right-click, the Paste Options, there’s 6 of them there, and we get to see what each looks like as we hover, so that’s the Transpose, and so on You get to see the live preview of what it would look like in those various options, fairly cool, and then if we go down to Paste Special, and then, more options appear and we can choose those options.
The reason that they added this, is that they did a study of the Undo key.
What is the command that was most frequently undone?
So they looked at when someone did Undo, what did they undone, it was usually a paste.
And so people weren’t happy with the look of their paste, and they had to undo.
I’m going to do something interesting here, I’m going to do Ctrl+C in Excel, and then I’m going to go over to this other little add-in that Microsoft produced. It’s for people that can’t seem to type their letters in Excel, it’s called Microsoft Word, you might have heard of it.
And so I’m going to go to the Paste menu there, and as I hover I get to see what the table’s going to look like before I paste it. So am I keeping the destination, am I pasting as a picture, and so on.
So very nice in all of the various- Oh, like that one would look horrible, Keep Text Only, I know that’s not the one I want. So, at least I can see what it’s going to look like before I paste, very, very cool option.
OK, going back… Even newer my favorite shortcut key, and you’re going to have to look into your computer screen, or look at your computer keyboard. Look at the spacebar, to the right of the spacebar there’s an Alt key, and there’s an Ctrl key. Now, on my keyboard there’s another key between those two keys, it’s a little cursor pointing down to a drop-down menu, basically.
And I found an even faster way to convert formulas to values is, Ctrl+C to do the copy.
And then that menu key, let’s call it the context key. Context+V will invoke the shortcut to convert those formulas to values. So I’m always looking for faster ways, faster than Ctrl+C and Alt E S V to convert formulas to values. So Ctrl+C, and then Context+V, very, very cool way to go.
Alright, well there you have it, everything about the Paste Options flyout menu, thanks for stopping by, we’ll see you next time for another netcast
Excel 2010 In Depth chapter 3 – The Paste Options Flyout!
-Back to the MrExcel netcast, I'm Bill Jelen.
Again, down here in Trinidad, working on podcasts for the new “Excel 2010 In Depth” book.
This little feature is one that Microsoft probably would never talk about, but it is one of my favorite features, and almost becomes the one feature in Excel 2010 that I don’t think I can live without.
Alright, so here’s what I’m going to do, Ctrl+C to copy, and Ctrl+V to paste, and that little menu there has popped up before, but now they say “Hey, you could open it using Ctrl.” I’ve never opened it before because you had to reach for the mouse, but now that I can open it using Ctrl, I see that there's good stuff in there, like Paste Values has a shortcut key of V!
And, you know, some other ones, like Paste Transpose has a shortcut key of T.
So I actually built myself a table of what all of these shortcut keys do, and then came through- Basically my new favorite shortcut is Ctrl+C to copy, Ctrl+V to paste, Ctrl alone to open that drop-down, and then V to Paste values, very fast way to change to values. OK now, let me undo that. If you’re a mouse person, the good thing about using a mouse, it will do a Ctrl+C to copy.
And then when we right-click, the Paste Options, there’s 6 of them there, and we get to see what each looks like as we hover, so that’s the Transpose, and so on You get to see the live preview of what it would look like in those various options, fairly cool, and then if we go down to Paste Special, and then, more options appear and we can choose those options.
The reason that they added this, is that they did a study of the Undo key.
What is the command that was most frequently undone?
So they looked at when someone did Undo, what did they undone, it was usually a paste.
And so people weren’t happy with the look of their paste, and they had to undo.
I’m going to do something interesting here, I’m going to do Ctrl+C in Excel, and then I’m going to go over to this other little add-in that Microsoft produced. It’s for people that can’t seem to type their letters in Excel, it’s called Microsoft Word, you might have heard of it.
And so I’m going to go to the Paste menu there, and as I hover I get to see what the table’s going to look like before I paste it. So am I keeping the destination, am I pasting as a picture, and so on.
So very nice in all of the various- Oh, like that one would look horrible, Keep Text Only, I know that’s not the one I want. So, at least I can see what it’s going to look like before I paste, very, very cool option.
OK, going back… Even newer my favorite shortcut key, and you’re going to have to look into your computer screen, or look at your computer keyboard. Look at the spacebar, to the right of the spacebar there’s an Alt key, and there’s an Ctrl key. Now, on my keyboard there’s another key between those two keys, it’s a little cursor pointing down to a drop-down menu, basically.
And I found an even faster way to convert formulas to values is, Ctrl+C to do the copy.
And then that menu key, let’s call it the context key. Context+V will invoke the shortcut to convert those formulas to values. So I’m always looking for faster ways, faster than Ctrl+C and Alt E S V to convert formulas to values. So Ctrl+C, and then Context+V, very, very cool way to go.
Alright, well there you have it, everything about the Paste Options flyout menu, thanks for stopping by, we’ll see you next time for another netcast
