ClipArt Finding ClipArt Inserting ClipArt Manipulating ClipArt Inserting a Photographic Image ClipArt can be described as small cartoons, sketches, or other artistic images that are used to draw attention to, or indicate significance for, a spreadsheet or a particular region in a spreadsheet. These images are included with the installation of Office, and thousands more are available at the Office Online Web site. In this lesson, you will learn how to find ClipArt, how to insert ClipArt into your spreadsheet, and how to format ClipArt once it is inserted. You will also learn how to insert an image file into your spreadsheet. Finding ClipArt The first step in finding ClipArt is to click the ClipArt button on the Insert Ribbon. When you click this button, you will see the ClipArt task pane. At the top of the pane, you can see a text field followed by a Go button. If you type a search term into this search field and click the Go button, Excel will look for ClipArt pertaining to the word or phrase that you typed. As an example, if you typed the word Cars into the search field and then clicked the Go button, your task pane would probably look like the following. As you can see, Excel found a variety of ClipArt graphics that involve cars. You can refine where Excel looks for ClipArt and what type of results it finds by configuring the options in the “Search in” and “Results should be” drop down menus. You can specify a specific collection or category to search in by clicking the checkboxes in the Search In drop menu. You can clear the checkboxes of any collections that you do not want results from, and you can expand categories by clicking the (+) sign in front of a particular collection. You can specify what type of results to display by using the Results Should Be drop menu. Once again, if you clear a checkbox, the particular type of file in question will not be returned as a result. If you click the ClipArt on Office Online link near the bottom of the task pane, your default web browser will open with a page of links to various ClipArt categories on the Office Online website. Inserting ClipArt Once you find a piece of ClipArt that you like, you can simply double click on its preview image in the task pane to insert it into your spreadsheet. The ClipArt will be inserted at the active cell. If you right click on a ClipArt preview image in the task pane, you will display a menu of options relating to the ClipArt. You can choose to insert the ClipArt, copy it, copy it to a collection, and more from the options on this menu. If you click the Insert option, the ClipArt in question will be inserted at the location of the active cell. Manipulating ClipArt After you insert a piece of ClipArt into your worksheet, it will be surrounded by a perimeter of small circles (very much like a text box). If you drag the small circles on the sides, top, or bottom with your mouse, you can increase or decrease the length and width of the ClipArt. If you drag one of the circles at the corners of the ClipArt, you can increase or decrease the image in two dimensions at once (grow or shrink the image). You can drag the green circle with your mouse to rotate the image around its center. You can also put your mouse pointer on the image itself, press your left mouse button, and drag the image to another location in the spreadsheet. To remove the ClipArt from your spreadsheet, click on it so that the perimeter circles appear, and then press your Backspace or Delete button. Inserting a Photographic Image To insert a photographic image into your worksheet, first click the Picture button on the Insert Ribbon. When you click this button, you will see the Insert Picture dialogue as shown in the following image. This dialogue will normally open to your My Pictures folder, but you can use the navigation controls in the toolbar on the left of the dialogue to browse to any folder on your system. When you find a photo that you like, click on the file to select it, and then click the Insert button on the lower right of the dialogue (next to the Cancel button). This action will insert the photo into your spreadsheet. Once again, you will see small circles and squares around the outside perimeter of the inserted object. As before, you can drag these circles and squares with your mouse to resize the photo. If you drag the green circle, you can rotate the photo to any angle. You can also relocate the photo in the spreadsheet by dragging one of the edges of the photo (top, bottom, or side). You can also move the photo incrementally by using the arrow buttons. When you click on the photo to select it, a Format tab will appear at the top of the ribbon. If you click this tab, you will display a Format Ribbon for photographic images. You can choose from a variety of preset picture styles and apply a number of effects using the controls in the Picture Styles button group. The Format Ribbon also contains controls that will help you arrange multiple pictures, crop pictures, and modify the picture’s border/outline. At the far left of the Format Ribbon, you will see a button called Reset Picture. If you click this button, any modifications you have made (effects, styles, and so on) will be abandoned, and the picture will return to its original form before it was modified. Also at the far left of the Format Ribbon, you will see a button called Compress Pictures. This will compress the size of any pictures that you have inserted into your workbook. Because picture files can be quite large, compressing them can reduce the file size of your document. The following spreadsheet contains a picture that was modified with a preset style and a reflection. These modifications were made with the controls on the Format Ribbon. To remove a picture from your spreadsheet, click on it to select it, and then hit the Backspace or Delete key to remove it.