Page 215 - Excel Workbook for Dummies

21_798452 ch15.qxp 3/13/06 7:41 PM Page 198
198 Part III: Working with Graphics
to accept text because it contains the insertion point and the outline of the text
box uses a single, diagonal cross-hatched pattern.
2. Enter the following text on three lines inside the selected text box:
• Type CG Media and press Enter to start a second line
• Type 2006 Sales by and press Enter again to start a third line
• Type Category & Quarter on the third line
3. Click the border of the text box and then press Ctrl+1 to open Format Text Box
dialog box and then use its options to make the following changes:
• On the Color and Lines tab, select No Fill for the Color setting in the Fill
area and No Line for the Color setting in the Line area
• On the Font tab, select Bold for the Font Style and 10 for the Size
• On the Alignment tab, select Center for the Horizontal setting
4. Hold down the Ctrl key as you click somewhere on the Horizontal Scroll
AutoShape outside of the boundary of the selected text box.

Excel selects the AutoShape along with the text box.
5. Right-click the Horizontal Scroll AutoShape and then Grouping➪Group on the
shortcut menu.
Excel groups the text box and scroll banner as one graphic object (indicated by
the single set of sizing handles).
6. Click the I-beam mouse pointer in the text on the banner after the a in Media in
the first line and then type a , (comma) followed by Inc. (period).
Even though the text box is now combined with the banner, you can still edit and
format its text. Remember that you can also separate the text box from the
banner AutoShape by ungrouping the joined graphic objects, if need be.
7. Click somewhere in background area outside of the chart to deselect it.
Check your text-box-plus-banner graphic object against the one shown on the
3-D Chart sheet in the Solved15-5.xls workbook in your Chapter 15 folder. When
everything checks out, proceed to step 8.
8. Save your work in a new workbook called Solved15-5-mine.xls in your
Chapter 15 folder in the My Practice Spreadsheets folder and then close this
workbook file.

Constructing WordArt

The WordArt button on the Drawing toolbar enables you to insert super-fancy text in
your worksheets. However, because WordArt text characters are all essentially graph-
ics, you can’t edit them directly as you can the characters you enter in a text box. Also,
WordArt styles are only intended for large font sizes (36 points being the default) and
many styles don’t really work well with regular text font sizes (say those below about
24 points in size).

To insert a WordArt graphic object in your worksheet, you first click the WordArt
button on the Drawing toolbar to open the WordArt Gallery dialog box. The WordArt
Gallery contains a wide variety of different styles at different angles with some styles
that even run the text down in a vertical line.

After selecting a WordArt style by clicking its thumbnail in the WordArt Gallery dialog
box and then selecting OK, Excel opens the Edit WordArt Text dialog box, where you