Hi fellow Excel Addict,
Thanks 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)
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.
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.
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.
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.
Once you insert a Shape, a new Drawing Tools/Format tab appears on the Ribbon.
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.
|"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