FREE Excel Tips Newsletter from
Subscribe here to get more tips like this every week

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

December 8, 2015 Quote of the Day
"Tell me and I forget.
Teach me and I remember.
Involve me and I learn."
-- Benjamin Franklin --

Hi fellow Excel Addict,

Today I have another Excel in Seconds tip that I hope will help you. If you find it useful, please share it with others.

Last week I mentioned to you about an impending snow storm that was bearing down on eastern Newfoundland last Thursday. Well, we did get hit with a pretty severe storm. It was enough to close down a lot of roads and businesses but wasn't quite as bad as predicted. Here is what it looked like.

Francis Hayes (

Francis Hayes (

Francis Hayes (

For some people 'bad weather' is something to dread. However, as you can see from these pictures, sometimes 'bad weather' can also be beautiful.

So, getting stressed out about the weather is pointless. You can't change the weather, so accept and appreciate it. I'm hoping wherever you are, you are having an awesome week regardless of the weather.

Take care and we'll talk again soon.

Francis Hayes (The Excel Addict)

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

Excel in Seconds with

How to Apply a Semi-Transparent Color to Text Boxes and

We all know how to create Text Boxes and Shapes and apply a color to them. But here's something that you may not know. There is a 'hidden' feature in Excel that allows you to apply a semi-transparent look to your Text Boxes and Shapes.

This is probably not something that you will use everyday but it is a neat trick and can be useful at times.

To apply a semi-transparent color to your Text box or Shape...

1) Select any Text Box or Shape;
2) Click the Fill tool on the Home tab in the Fonts group and select More Colors...;
3) You'll notice on the bottom of the dialog box there is a Transparency control that allows you to vary the percentage of Transparency from 0% to 100%. I find that around 50% to 80% gives a realistic transparent look

Add Semi Transparent Color To Text Boxes Objects And Shapes in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

FREE Excel Tips Newsletter from
Subscribe here to get more tips like this every week

Thanks for supporting this newsletter and website

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 or send a blank email to theexceladdict(AT)

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit or send a blank email to theexceladdict(AT)
3)  Post a link to 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
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630