Remove backgrounds from pictures in Excel.
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Excel In Depth chapter 35 - Picture Background Removal!
Well hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Working through the “Excel In Depth” book, one of the cool features they added in Excel 2010 is the Background Removal tool.
It was there in 2007, it didn't work well at all, we 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 choose the picture to 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 limit 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 dog’s on a raft here, I want to make sure to include the raft.
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.
Alright, looks good, Keep Changes, and then we end up with just the picture of the dog and the raft or whatever it is that you want to do.
I can imagine all sorts of cover pages for reports now that will happen.
Now here's the 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 instead, so 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 one of the downsides.
So, the picture background removal tool, nice improvement in Excel 2010, give it a try.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Excel In Depth chapter 35 - Picture Background Removal!
Well hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Working through the “Excel In Depth” book, one of the cool features they added in Excel 2010 is the Background Removal tool.
It was there in 2007, it didn't work well at all, we 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 choose the picture to 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 limit 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 dog’s on a raft here, I want to make sure to include the raft.
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.
Alright, looks good, Keep Changes, and then we end up with just the picture of the dog and the raft or whatever it is that you want to do.
I can imagine all sorts of cover pages for reports now that will happen.
Now here's the 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 instead, so 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 one of the downsides.
So, the picture background removal tool, nice improvement in Excel 2010, give it a try.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
