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

Converting to Octal

Filtering Columns for Unique Values

Printing Multiple Worksheets on a Single Page

Changing the Default Font

Creating a Drawing Object

Determining a Value of a Cell

Understanding Macros

 

Specifying a Font in WordArt

Summary: Do you use WordArt to place graphics in your Excel workbooks? If so, you may want to modify the font used by the program to display your graphic creation. (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 in your worksheet. It may seem weird to talk about a tool normally associated with Word when discussing Excel, but WordArt works just as well in Excel as it does in Word.

Once you have a WordArt object in your worksheet, you may want to modify it to give it more "pizzazz." By changing the font used by WordArt, you can greatly change the appearance of your WordArt object. To change fonts, follow these general steps:

  1. Select the WordArt object by clicking on it. In versions of Excel prior to Excel 2007, the WordArt toolbar should appear. In Excel 2007 the Format tab should appear on the ribbon (make sure it is selected).
  2. Click on the Edit Text tool. WordArt displays the Edit WordArt Text dialog box. (Click here to see a related figure.)
  3. Use the Font pull-down list to select a font to use.
  4. Change the font size, as desired.
  5. Use Bold or Italics, as desired.
  6. Click on OK. WordArt updates your WordArt object.

You should understand that WordArt in Excel 2007 is different than in previous versions of Excel. In this version, the WordArt tool on the Insert tab of the ribbon allows you to pick from some predefined text treatments. If you create WordArt using the Excel 2007 tool, then all you need to do is select the text that makes up the WordArt. As you move the mouse pointer over the selected text you should see a small formatting palette appear. Use the controls in the palette to select the typeface and font size for your WordArt.

It is possible, however, that if you have WordArt in a workbook created in a previous version of Excel, and you are now working on it in Excel 2007, that you will need to follow the steps for changing fonts as described earlier in this tip. The method for changing depends on the version of WordArt used to create the WordArt object in the first place.

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

Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions.
 
Check out Excel Conditional Formatting today!