The Picture Background Removal Tool has returned with more flexibility and a better quality image when your editing is completed. In Episode #1249, Bill shows you how to use the Background Removal feature in Excel 2010 to achieve the result you want!
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Excel in depth, chapter 35.
Picture Background Removal.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Working through the Excel in depth, book.
How one of the cool features they added Excel 2010 is the background removal tool.
It was there in 2007.
It didn't work well at all, you had to choose one color.
It just didn't work.
So, it works much better in Excel 2010.
There's one little tweak, you have to do choose the picture, remove background from the picture tools, and then the very first step that you need to do is you need, to grab this bounding box and adjust the bounding box to truly the limits of what you're trying to focus on.
If you get that down to the limits that really helps the tool find the correct pieces of the picture.
So, the dog's on a raft here, want to make sure to include a raft.
So, here we go! Alright.
So, now that you've done that, they really come much closer.
You only have a few areas to mark So, if there's some areas I want to remove, like we have sections of the pool that are showing up here.
I will click those.
One tiny area right there, and one tiny area right there.
All right! Looks good.
Keep changes, and then we end up with just the picture of the dog at the raft or whatever it is that you want to do.
I can imagine all sorts of cover pages for reports, now.
That will have this.
Now, here's the catch.
If you want to put data or words next to the picture when you go.
Click, on those cells you're going to choose the picture in, stays.
You have to be pretty careful.
You have to click outside the picture, and then use the arrow keys to get in and you can actually change this data in here.
But you can't directly select it with the mouse, it's just the downside.
So, the picture of background removal tool nice and groomed in Excel 2010.
Hey! I want to thank you for stopping by.
See you next time for another, netcast from Mr. Excel.
Excel in depth, chapter 35.
Picture Background Removal.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Working through the Excel in depth, book.
How one of the cool features they added Excel 2010 is the background removal tool.
It was there in 2007.
It didn't work well at all, you had to choose one color.
It just didn't work.
So, it works much better in Excel 2010.
There's one little tweak, you have to do choose the picture, remove background from the picture tools, and then the very first step that you need to do is you need, to grab this bounding box and adjust the bounding box to truly the limits of what you're trying to focus on.
If you get that down to the limits that really helps the tool find the correct pieces of the picture.
So, the dog's on a raft here, want to make sure to include a raft.
So, here we go! Alright.
So, now that you've done that, they really come much closer.
You only have a few areas to mark So, if there's some areas I want to remove, like we have sections of the pool that are showing up here.
I will click those.
One tiny area right there, and one tiny area right there.
All right! Looks good.
Keep changes, and then we end up with just the picture of the dog at the raft or whatever it is that you want to do.
I can imagine all sorts of cover pages for reports, now.
That will have this.
Now, here's the catch.
If you want to put data or words next to the picture when you go.
Click, on those cells you're going to choose the picture in, stays.
You have to be pretty careful.
You have to click outside the picture, and then use the arrow keys to get in and you can actually change this data in here.
But you can't directly select it with the mouse, it's just the downside.
So, the picture of background removal tool nice and groomed in Excel 2010.
Hey! I want to thank you for stopping by.
See you next time for another, netcast from Mr. Excel.
