June 28, 2016
Hi fellow Excel Addict,
You know that Excel is not just for numbers. But you may be pleasantly surprised at the amazing professional-like graphics capabilities that Excel has built in. Today you'll get a chance to try some out for yourself.
If you missed last Thursday's Excel in Minutes' tip, 'Formulas that Put Sheet, Workbook, or Folder Name in a Cell', you can read it here now.
Wishing an awesome week.
Keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
Use Excel to Easily Remove the Background From Portrait Image
(FOR EXCEL 2010 AND HIGHER)
You don't need Photoshop to remove the background from a portrait image. Excel can do that too!
Yes, Excel really is full of surprises.
Here's how to remove the background from a portrait using Excel...
1) For best results, choose a photo that has fairly clear distinction between the portrait and the background (my sample photo);
2) Copy and Paste the image into an Excel worksheet. Excel's Picture Tools/Format tab will appear on the right end of the Ribbon;
3) Click the Format tab then click Remove Background on the left end of the Ribbon;
3) A Background Removal tab will appear on the Ribbon and Excel will automatically attempt to determine the foreground subject and then mask the background areas of the picture;
4) Drag the sizing handles so that just the part of the image you want to keep is included within the box. Excel will re-mask the background;
5) If there are areas of the background still unmasked, click the Mark Areas to Remove button on the Ribbon and click or drag on the part you want to remove;
6) If there are areas of the portrait still masked, click the Mark Areas to Keep button on the Ribbon and click or drag on the part you want to keep;
7) When you're happy with the image, click Keep Changes and the background will be removed.
This is not essential but I recommend that you crop your final image to avoid problems later with image placement. From the Picture Tools/Format tab, click Crop (on far right end of ribbon) and drag the crop handles to include just the visible image.
Now that you have a portrait with no background, you can get creative and paste it anywhere in your worksheet, including in front of or behind other objects.
Give it a try and send me a screenshot of your results.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630