2010 Screen Clipping - 1087 - Learn Excel from MrExcel

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Aug 25, 2009 .
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!
maxresdefault.jpg


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.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,362
Messages
5,641,691
Members
417,229
Latest member
BODYCOTE

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top