December 8, 2015
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.
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.
How to Apply a Semi-Transparent Color to Text Boxes and Shapes
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.
| '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