FREE Excel Tips Newsletter from TheExcelAddict.com
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

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)
Email: 
fhayes[AT]TheExcelAddict.com


Francis Hayes (TheExcelAddict.com)


TheExcelAddict.com Quote of the Day

 "How far you go in life depends on your
being tender with the young, compassionate with the aged,
sympathetic with the striving, and tolerant with the weak…
because in your life you will have been all of these."

-- George Washington Carver --




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



Excel in Seconds with TheExcelAddict.com

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.


Text Floating Over Image in Microsoft Excel 2007 2010 2013 2016 365

New to Images and Text in Excel?

If this is all new to you and you don't know how to insert images and text in your worksheets, it's pretty easy.

Insert an Image in your Excel Worksheet
You can simply copy an image from just about anywhere and Paste it into your worksheet or you can use Insert, Pictures from the Ribbon.

Add Text on Top of the Image in your Excel Worksheet
To add Text so that it floats above an image, just insert a Text Box (Insert tab, Text Box) or Word Art (Insert tab, Word Art) in your worksheet, then drag it on top of the image.

Notice that when you have the Image or Text Box selected, there is a new Format tab on the Ribbon that allows you to do lots of cool stuff. I cover one of them in the tip below

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.

Glow Text in Microsoft Excel 2007 2010 2013 2016 365

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.

Format Shape No Fill in Microsoft Excel 2007 2010 2013 2016 365
If your text box also has borders, you can remove them by clicking Format, Shape Outline, No Outline.

Text Box No Fill Color in Microsoft Excel 2007 2010 2013 2016 365
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).

Add Glow Color To Text in Microsoft Excel 2007 2010 2013 2016 365
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?

Glow Effect Text Over Picture in Microsoft Excel 2007 2010 2013 2016 365
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. :(


Thanks for supporting this newsletter and website

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

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