Paste a screenshot of another application into Excel 2010.
Transcript of the video:
MrExcel podcast is sponsored by Excel-XL.
Excel Charts Chapter 12; Screen Clipping.
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen.
One of the cool features that Microsoft added to office 2010 is called the Screen Clipping Tool.
So, we wanna Insert a Screenshot from another application, it will show us all the available Windows, but I have to tell you, I don't like these.
What I really like is Screen Clipping.
Let me show you the best way to do this.
What you want to do is you want to switch to the application that has the picture that you want to grab.
So I want to grab this book cover here.
All right so, I'm here in Internet Explorer, I'm not going to switch directly back to Excel and then go to the Screen Clipping and use the Screen Clipping option at the bottom, this menu item.
And what it does is, it switches me back to the item that I was just at, so I just at this Internet Explorer.
You see it briefly and then it grays the whole thing out and then when it's grayed out, I can take these across here, so... and drag, to grab the image that I want. When I click OK, we go back to Excel and that portion of the screen is now inserted into Excel.
So very cool, if you want to grab data from another Word document, Internet Explorer or OneNote, whatever it is, you can use that new Screen Clipping.
The one thing that frustrates me just a tiny bit because I can't grab data from another Excel worksheet. I can't do that, unless I have a second instance of Excel open.
Let's just talk about that I guess, the best way to do it, let's just put some data in here.
So, then we put RAND, maybe apply a little bit of formatting...
Okay so, if I wanna copy that data as a picture, what I can do is, choose the data, Ctrl+C to copy and then come back to where I want the picture to be and under Paste Special, there's now this paste as a Linked Picture or as a Static Picture.
In this case, I probably want a Static Picture, so if you need to do a Screen Clipping from somewhere in Excel, we can just do Copy and Paste as a picture and you can achieve that.
So there's a couple of different ways to get a screenshot in Excel.
Now just a quick word here, if you're doing a lot of screenshots, I want to give a plug to my friends out at TechSmith, the people that make Snagit as I'm doing Excel Books.
I'm always using Snagit all the time to do my screen captures, much better than using Print Screen, you get to choose exactly the region you want.
You get a control, you know, the way that you copy the data, sizing and all kinds of great things like that.
So if you find yourself doing a lot of screenshots, you might have to take a look at Snagit...
Hey I wanna, I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Excel Charts Chapter 12; Screen Clipping.
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen.
One of the cool features that Microsoft added to office 2010 is called the Screen Clipping Tool.
So, we wanna Insert a Screenshot from another application, it will show us all the available Windows, but I have to tell you, I don't like these.
What I really like is Screen Clipping.
Let me show you the best way to do this.
What you want to do is you want to switch to the application that has the picture that you want to grab.
So I want to grab this book cover here.
All right so, I'm here in Internet Explorer, I'm not going to switch directly back to Excel and then go to the Screen Clipping and use the Screen Clipping option at the bottom, this menu item.
And what it does is, it switches me back to the item that I was just at, so I just at this Internet Explorer.
You see it briefly and then it grays the whole thing out and then when it's grayed out, I can take these across here, so... and drag, to grab the image that I want. When I click OK, we go back to Excel and that portion of the screen is now inserted into Excel.
So very cool, if you want to grab data from another Word document, Internet Explorer or OneNote, whatever it is, you can use that new Screen Clipping.
The one thing that frustrates me just a tiny bit because I can't grab data from another Excel worksheet. I can't do that, unless I have a second instance of Excel open.
Let's just talk about that I guess, the best way to do it, let's just put some data in here.
So, then we put RAND, maybe apply a little bit of formatting...
Okay so, if I wanna copy that data as a picture, what I can do is, choose the data, Ctrl+C to copy and then come back to where I want the picture to be and under Paste Special, there's now this paste as a Linked Picture or as a Static Picture.
In this case, I probably want a Static Picture, so if you need to do a Screen Clipping from somewhere in Excel, we can just do Copy and Paste as a picture and you can achieve that.
So there's a couple of different ways to get a screenshot in Excel.
Now just a quick word here, if you're doing a lot of screenshots, I want to give a plug to my friends out at TechSmith, the people that make Snagit as I'm doing Excel Books.
I'm always using Snagit all the time to do my screen captures, much better than using Print Screen, you get to choose exactly the region you want.
You get a control, you know, the way that you copy the data, sizing and all kinds of great things like that.
So if you find yourself doing a lot of screenshots, you might have to take a look at Snagit...
Hey I wanna, I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
