Page 207 - Excel Workbook for Dummies
P. 207
21_798452 ch15.qxp 3/13/06 7:41 PM Page 190
190 Part III: Working with Graphics
for the type of clips you want to use. The first time that you use the Clip Art button,
Excel opens the Add Clips to Gallery dialog box that prompts you to collect and cata-
log all the media files on your computer system (including sound, pictures, digital
movies, and Clip Art). Click the Now button to have Excel catalog your media files.
When you do so, the program opens an Auto Import Settings dialog box, where you
can indicate which folders to search for the media files on your computer. Once you
finish indicating which folders to search, click the Catalog button to have the Microsoft
Media Gallery catalog the media clips on your system.
Try It
Exercise 15-2: Adding Clip Art to a Spreadsheet
Open the Exercise15-2.xls workbook file in your Chapter 15 folder in the My Practice
Spreadsheets folder on your hard disk or in the Excel Workbook folder on the work-
book CD-ROM. This workbook contains the ITB Invoice worksheet with a copy of an
invoice template for a store called Into the Blue that sells kites and accessories. In this
exercise, you get to practice finding and adding clip art by sprucing up the otherwise
dull invoice heading with an image of a kite:
1. Display the Drawing toolbar by choosing View➪Toolbars➪Drawing.
Excel docks the Drawing toolbar at the bottom of the Excel program window.
2. Click the Insert Clip Art button on the Drawing toolbar.
Excel displays the Clip Art task pane. If this is the first time you opened this task
pane, the program displays the Add Clips to Gallery dialog box, which prompts
you to collect and catalog all the media files on your computer system (including
sound, pictures, digital movies, and Clip Art). Go ahead and have the program
catalog the media files on your computer by clicking the Now button.
3. Enter kites as the search text in the Search For text box at the top of the Clip Art
task pane and then select the Go button.
Depending upon your version of Excel, the program may locate several kite
images including a single clip art image of a pink kite (which does not go very
well with the blue background of the invoice header). If you have access to
the Internet, go ahead and follow steps 4 to 9 to find and download other, better-
suited kite images from Microsoft’s Clip Art Web site. If you don’t have Internet
access, go ahead and use the pink kite image and skip ahead to step 10.
4. Click the Clip Art on Office Online hyperlink near the bottom of the Clip Art task
pane.
Excel launches your Web browser, which goes online and opens the Microsoft
Office Clip Art and Media Home Page.
5. At the top of Microsoft Office Clip Art and Media Home Page, select Clip Art on
the Search drop-down list and then type kite in the Search text box before select-
ing its Go button.
The first of eight Web pages of kite images appears.
6. Search through the first few pages of kite images, selecting the check boxes for
a few clip art images whose colors and kite drawing seem best suited to the
background color and type style in the Into the Blue invoice header.
Note that the Download link in the pane on the left of the Web page keeps tabs
on the number of images you select.
7. Click the Download link to open the Download page and then click the Download
Now button (also, if a File Download security alert dialog box appears, click its
Open button to proceed with the image downloading).