Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
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
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
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:
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.