Microsoft Excel 2003, 2007, 2010, 2013 Tips

Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

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)
Email: 
fhayes[AT]TheExcelAddict.com

Francis Hayes (TheExcelAddict.com)


TheExcelAddict.com Quote of the Day

"There are two ways to live your life.
One is as though nothing is a miracle.
The other is as though everything is a miracle—"

-- Albert Einstein --




If you missed my last newsletter, you can click here to view it online.



Excel in Seconds with TheExcelAddict.com

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;

Portrait Image With Background in Microsoft Excel 2007 2010 2013 2016 365
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;
Excel'S Background Removal Tab in Microsoft Excel 2007 2010 2013 2016 365
Background Areas Marked On Portrait Image in Microsoft Excel 2007 2010 2013 2016 365
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;
Marked Background To Be Removed On Portrait Image in Microsoft Excel 2007 2010 2013 2016 365
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.

Photo With Background Removed in Microsoft Excel 2007 2010 2013 2016 365

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.

Recrop Image Background Removal in Microsoft Excel 2007 2010 2013 2016 365
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.

Combine Photo With Background Removed With Other Objects And Text in Microsoft Excel 2007 2010 2013 2016 365
Give it a try and send me a screenshot of your results.




Thanks for supporting this newsletter and website


 If you would like to share this newsletter with others...
1) Forward this newsletter by email, but first delete the unsubscribe link at the very bottom so you don't get accidentally unsubscribed
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630