New in Excel 2010, stolen from OneNote 2007 - the ability to insert a screen clipping into your worksheet. Episode 1087 shows you the two ways to use this new functionality.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen.
Basically you start out with massive amounts of data.
So how we're gonna analyze as well let's fire up a pivot table and see if you can solve this problem.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen another 2010 tip this is one that they picked up from probably from OneNote. OneNote added this function all way back in excel 2007.
I have a nice little spreadsheet here.
I'd like to dress this up a little bit add some eye-catching pictures or something like that.
So I'm going to come back to insert, and if I go to insert "Screenshot" open the drop-down.
It's going to show me all of the available windows that I have opened right now.
You'll see here that I have a internet explorer page and so I choose that and it's going to actually take a screenshot of the internet explorer page bring it into excel and you know so now we can resize this a little bit. Use the crop tool to recrop if we want to.
Now a cooler way to use this and this is actually the way that OneNote, originally introduced.
It is not to just allow excel to bring the whole screenshot in.
There's a better way to go.
So let me click delete to get rid of this and to set this up you want to make sure that you are at the other application first, so there's my web page.
I kind of get it centered so that way the section that I want is in the visible part of the page and now we'll go back to excel and I'll go to insert and not choose one of the the thumbnails, but come down here to "Screen Clipping" "Screen Clipping" there we go And it actually gets rid of excel for a second, brings me back to the last used application, and gives me this crosshair, where I can get to draw exactly where I want it to go, so I choose the section of the the screen that I want and it's now going to insert that so no need to have snagit or to use print screen.
You now get to very easily come in and choose the section of the last application that you want to grab and put it right there in excel. Great little trick.
Faster ways to add pictures to your excel spreadsheets now.
I want to thank you for stopping by. Will see you next time for another netcast from MrExcel.
Basically you start out with massive amounts of data.
So how we're gonna analyze as well let's fire up a pivot table and see if you can solve this problem.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen another 2010 tip this is one that they picked up from probably from OneNote. OneNote added this function all way back in excel 2007.
I have a nice little spreadsheet here.
I'd like to dress this up a little bit add some eye-catching pictures or something like that.
So I'm going to come back to insert, and if I go to insert "Screenshot" open the drop-down.
It's going to show me all of the available windows that I have opened right now.
You'll see here that I have a internet explorer page and so I choose that and it's going to actually take a screenshot of the internet explorer page bring it into excel and you know so now we can resize this a little bit. Use the crop tool to recrop if we want to.
Now a cooler way to use this and this is actually the way that OneNote, originally introduced.
It is not to just allow excel to bring the whole screenshot in.
There's a better way to go.
So let me click delete to get rid of this and to set this up you want to make sure that you are at the other application first, so there's my web page.
I kind of get it centered so that way the section that I want is in the visible part of the page and now we'll go back to excel and I'll go to insert and not choose one of the the thumbnails, but come down here to "Screen Clipping" "Screen Clipping" there we go And it actually gets rid of excel for a second, brings me back to the last used application, and gives me this crosshair, where I can get to draw exactly where I want it to go, so I choose the section of the the screen that I want and it's now going to insert that so no need to have snagit or to use print screen.
You now get to very easily come in and choose the section of the last application that you want to grab and put it right there in excel. Great little trick.
Faster ways to add pictures to your excel spreadsheets now.
I want to thank you for stopping by. Will see you next time for another netcast from MrExcel.
