April 19, 2016
Hi fellow Excel Addict,
Most of us Excel addicts love working with numbers and formulas but once in a while it's nice to try something different and fun. Do you have a creative side? In today's newsletter I'm going to help you unleash your artistic abilities.
If you missed last Thursday's 'Excel in Minutes' newsletter, I showed how to 'Format An Entire Row Using Conditional Formatting'. You can read it here.
If you have a favourite tip that you'd like to share, or a problem that you've been trying to solve, that I could possibly include in my newsletter, please send it along to me.
Wishing you an AWESOME week,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
Get a Glow On
If you sometimes use images in your Excel spreadsheets, you may find that when you place text over an image that has both light and dark areas, the text is often difficult to see.
You could try using an in-between color to fix this but often it may not be the color you want or that particular color may not look good in your worksheet. An option that I use that works well is Glow Text.
You can use Word Art (Insert, Word Art) to place floating text in your worksheet but most people use Text Boxes. If you float a Text Box on top of an image, you may want the background to be invisible. To remove the background color, select the text box, then on the Format tab, click the Shape Fill dropdown and select No Fill.
If your text box also has borders, you can remove them by clicking Format, Shape Outline, No Outline.
With the background removed, your text may difficult to see. Try applying a glow effect to the text. With the text box selected, from the Format tab, click Text Effects and point to Glow. Choose one of the Glow Variation from the gallery or click More Glow Colors to pick another glow color (e.g. white).
Sometimes adding an outline to your text (Format, Text Outline) can help it stand out as well.
Now, even in Excel, you can add floating text above an image that looks like it was created professionally.
Who would believe you could make a cool poster like this in Excel?
Now PLEASE, PLEASE, PLEASE!!!! Don't go trying to make your management reports and dashboards all fancy and stuff with your cool new text formatting skills. That may get you noticed...but probably not in a good way.
Save those artistic skills for making posters for birthday parties or maybe if you have a Lamborghini you need to sell.
And No, that's not my car. :(
| '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