Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Recording a Macro

Adding a Little Animation to Your Life

Converting a Range of URLs to Hyperlinks

Making the Formula Bar Persistent

Engineering Calculations

Digital Signatures for Macros

Fixing the Decimal Point

 

Using WordArt in Excel

Summary: The WordArt program has been available in Office for a long, long time. It allows you to (dare I say it) create art from words. Here's how you can add WordArt images to your worksheets. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

WordArt is a program that allows you to treat text as a graphic. You can use the program to add special effects and flourishes to text, and then insert the text—as a graphic—in your worksheet. It is useful for creating special text elements such as logos, mastheads, or titles. Don’t confuse the program name (WordArt) with Microsoft Word; these are two entirely different programs, and you can use WordArt with Excel as easily as you can use it with Word. How you access WordArt depends on the version of Excel you are using. Excel 97 includes WordArt 2.0, although it is not automatically installed when you install Word. You can tell if WordArt is installed by trying to access WordArt. If it is not installed, then you can run the Excel Setup program again and install WordArt on your system. You access WordArt using either of these methods in Excel 97: • Double-click on a graphic originally created with WordArt. • Choose Object from the Insert menu. You will see the Object dialog box. Choose Microsoft WordArt 2.0 from the Object Type list and click on OK. You will see the WordArt dialog box. When WordArt if running, you see the WordArt dialog box, and most of your Excel 97 menus and toolbars are hidden. When you are through using WordArt, you can exit the program simply by using the mouse to click somewhere else in your worksheet. (You can also press ESC to exit WordArt.) Excel 2000 and later versions include a more integrated approach to WordArt. If you are using Excel 2000, Excel 2002, or Excel 2003 you should follow these steps: 1. Make sure the Drawing toolbar is displayed. 2. On the Drawing toolbar, click on the Insert WordArt tool. You then see the WordArt Gallery. (Click here to see a related figure.) The WordArt Gallery. 3. Select a general appearance that you want used for your text, and then click on OK. You then see the Edit WordArt Text dialog box. (Click here to see a related figure.) The Edit WordArt Text dialog box. 4. Enter the text you want used by WordArt, and click on OK. At this point, the WordArt graphic is created and added to your worksheet. You should also see the WordArt toolbar, which includes commands specific to working with WordArt objects. To hide the toolbar, simply click a different place in your document, so that the WordArt object isn’t selected. To add WordArt to an Excel worksheet in Excel 2007, follow these steps: 1. Display the Insert tab of the ribbon.. 2. In the Text group, click the WordArt tool. You then see the WordArt Gallery. 3. Select a general appearance that you want used for your text, and then click on OK. You then see some default text appear in the worksheet. 4. Enter the text you want used by WordArt, and click on OK. It should be pointed out that the WordArt in Excel 2007 is markedly different than WordArt in earlier versions of Excel. In Excel 2007 WordArt consists of straight text, with different types of color, fill, and shadow formatting applied. In earlier versions there were actual changes made to the fonts and paths followed by the fonts; not so any more.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3408) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Remove Some Stress at Tax Time! Doing your personal income taxes can be a royal pain. Why not make the process just a bit less stressful with our 101-question checklist. You can prepare for filing your taxes with confidence, knowing you've covered all your bases.
 
Check out Filing Your Income Taxes Checklist today!