How to add WordArt to a Sheet in Excel 2007

If selecting gazillions of preset shapes available from the Shapes gallery doesn’t provide enough variety for jazzing up your worksheet, you may want to try adding some fancy text using the WordArt gallery opened by clicking the WordArt command button in the Text group of the Insert tab.

You can add this type of "graphic" text to your worksheet by following these steps:

1. Click the WordArt command button on the Ribbons Insert tab or press Alt+NW.
Excel displays the WordArt drop-down gallery dialog box.

2. Click the A thumbnail in the WordArt style you want to use in the WordArt drop-down gallery.

Excel inserts a selected text box containing Your Text Here in the center of the worksheet with this text in the WordArt style you selected in the gallery.

3. Type the text you want to display in the worksheet in the Text text box. As soon as you start typing, Excel replaces the Your Text Here text in the selected text box with the characters you enter.

4. (Optional) To format the background of the text box, use Live Preview in the Shape Styles drop-down gallery on the Format tab to find the style to use and then set it by clicking its thumbnail.

The Format tab under the Drawing Tools contextual tab is automatically added and activated whenever WordArt text is selected in the worksheet.

5. After making any final adjustments to the size, shape, or orientation of the WordArt text with the selection and rotation handles, click a cell somewhere outside of the text to deselect the graphic.

Note that Excel automatically compresses the text to fill the shape and size of its text box. To put more space between the words and the characters in each word, make the text box wider by dragging the sizing handle on either side of the text box.

When you click outside of the WordArt text, Excel deselects the graphic, and the Drawing Tools contextual tab disappears from the Ribbon. (If you ever want this tab to reappear, all you have to do is click somewhere on the WordArt text to select the graphic.)

Remember:
You can change the size of WordArt text and the font it uses after creating it by dragging through the WordArt text to select and then using the Font and Font Size command buttons on the Home tab to make your desired changes. Keep in mind, however, that Excel does not automatically resize the WordArt text box to suit the new font and font size.

This means that you can easily make the WordArt text too small or too large for its text box. If this happens, use the sizing handles around the text box to resize and reshape it as needed
to suit the new text size.





Tags: worksheet,wordart,cell

Related Articles