Microsoft Excel 2003, 2007, 2010, 2013 Tips
The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
June 10, 2015
If the images in this message are a little misaligned in your email program,
you can go here
to read the online version of this newsletter
Greetings from The Excel Addict
NOTICE OF TEMPORARY CHANGES TO MY NEWSLETTER - PLEASE READ
As you may already know, I publish this newsletter every week, maintain my website and answer a lot of questions from Excel Addict members, all in my 'spare' time. Yes, I do have a full-time day job as well, so every week it's a challenge for me to find the time to write and publish my newsletter.

Over the next two months I will be updating my website, something I have been wanting to do for years. This is going to take up a significant amount of my time but I definitely don't want you to miss out on these valuable tips completely. So, what I have decided to do for the next while is to continue publishing my newsletter weekly, but in order to free up some time, I will be scaling back to just one tip each week. I hope that will be enough to keep you learning and loving Excel until I get my new and improved website up and running.

Thanks in advance for your patience and understanding.
Francis

Hi fellow Excel Addict,


Francis Hayes (The Excel Addict) - I want to help you EXCEL !!Thanks for joining me this week. I'll keep my message brief as I am trying to free up as much time as possible to work on my website project.

I hope you'll find this week's tip useful and that it helps make your work a little easier. If you do, please be kind and share it with others who could use a little help as well.

I hope you have a fantastic week.

Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com


To view this week's newsletter online click here.

If you missed last week's newsletter, you can click here to view it online.

You can access even more tips on my website by going to my members' page



If you have a favourite quote, send it to me and I may post it in my newsletter.
Fear less, hope more; whine less, breathe more; talk less, say more; hate less, love more; and all good things are yours—Swedish Proverb
Microsoft Excel Tip #1
How to Remove a Background Color From A Logo or Image

Do you have a logo or image that you want to add to your worksheets? Maybe it would look better without that background color?

Removing a background color from an image is not something you would typically associate with a spreadsheet program but, surprisingly, Excel has treasure chest full of amazing graphics capabilities**. Making an image's background transparent is easy for Excel.

Make Image Background Transparent in Microsoft Excel 2003, 2007, 2010, 2013, 365


This works only if the color that you want to make transparent is a solid color.

1) Select the logo or picture;

2) Click Picture Tools-Format tab;

3) Click Color;

4) Select Set Transparent Color;

5) Point and click the (solid) background color in the picture and magically, the background color disappears.
Steps To Make Image Background Transparent in Microsoft Excel 2003, 2007, 2010, 2013, 365
If this is something that you will be using regularly, you can make this process even easier by right-clicking on the 'Set Transparent Color' option and clicking 'Add to Quick Access Toolbar'.

Add Set Transparent Color Command To Quick Access Toolbar in Microsoft Excel 2003, 2007, 2010, 2013, 365

If the background color of your logo or image isn't a solid color, only some of the background will be made transparent. There's no easy way to fix this other than to find another image with a solid background color.

If there are other parts of the image that contain the same color as the background, those colors will also be made transparent. A workaround that I use for this situation is to copy the image to Paint and use the Bucket tool to fill the background with a unique color, then copy the image back to Excel and use the Set Transparent Color option.

** Many of Excel's graphics capabilities are as good or better than some professional graphics software. Honestly! In fact, almost all of the images I use in my newsletter and on my website, I create with Excel. I'll share some of my 'Excel graphics' secrets with you in upcoming newsletters.

Create Awesome Graphics in Microsoft Excel 2003, 2007, 2010, 2013, 365

Thanks for supporting this newsletter and website




My goal: To teach One Million Excel Users




Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com

 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.

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" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630