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
Hi fellow Excel Addict,
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)
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.
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.
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.
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'.
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.
|"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