Microsoft Excel 2003, 2007, 2010, 2013 Tips
The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
September 17, 2015

Greetings from The Excel Addict
Hi fellow Excel Addict,

Francis Hayes - The Excel Addict - www.TheExcelAddict.comThanks for joining me today for another Excel tip.

I hope you're going to like getting the two separate tips per week. From the emails I've received so far, most like this new approach. And it works better for me as well.

Although today's tip is not earth shattering, it is something that I believe many Excel users will find useful.

Give it a try and let me know what you think.

If you find today's tip helpful, consider sharing it with someone else you know who could use it.

Enjoy the rest of your week,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com



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

You can access even more tips on my website by going to my members' page



If you have a favourite quote, send it to me and I may post it in my newsletter.
SIMPLICITY is the ultimate form of SOPHISTOCATION -- Leonardo Da Vinci


Today's Microsoft Excel Tip

Easily Add Text To Excel Shapes

I love using Shapes in Excel. They are great for creating user guides and tutorials, and also great for drawing attention to important information in your worksheets.

Use Shapes To Draw Attention in Microsoft Excel 2003, 2007, 2010, 2013, 365

Over the years, many people have asked me how to they can create shapes like mine. I sometimes see people using shapes and then overlaying them with text boxes. But there's no need to use both shapes and text boxes.

When you insert a Text Box, you'll notice that you are automatically put into Edit Mode with a blinking cursor ready for you to start typing some text. However, when you insert a Shape, such as a rectangle, a block arrow, a flowchart symbol and most other shapes, you do not go into Edit Mode. Even when you click in the Shape, there's no blinking cursor...nothing happens. It appears that you cannot enter text in these Shapes.

How To Enter Text In An Autoshape in Microsoft Excel 2003, 2007, 2010, 2013, 365 

But if you right-click on most Shapes, you'll see an Edit Text option on the menu. That will allow you to add text. However, an even easier option is to simply just start typing after you have drawn or selected the Shape.

This Is How You Enter Text In An Auto Shape in Microsoft Excel 2003, 2007, 2010, 2013, 365

Once you insert a Shape, a new Drawing Tools/Format tab appears on the Ribbon.

Design Cool Stuff With Drawing Tools Tab in Microsoft Excel 2003, 2007, 2010, 2013, 365

On this tab, in the Word Art Styles group, you can find some some cool commands for formatting your text. In the Shape Styles group you'll find commands to 'pimp your shapes'. Play around a little in here. Some of the effects you can create here will make you look like a pro. You can also use the Font commands on the Home tab for formatting the text in your Shapes.

Create Text And Cool Graphics in Microsoft Excel 2003, 2007, 2010, 2013, 365



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

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

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" 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