Uncle Jim's Web Designs
Development Tools for the Internet and Your Computer

Microsoft Excel Tutorial


Sorting and Filling Graphics Charts
Adding Clip Art

To add a clip art image to the worksheet, follow these steps:

  1. Select Insert|Picture|Clip Art from the menu bar.
    [Insert ClipArt dialog box]
  2. To find an image, click in the white box following Search for clips. Delete the words "Type one or more words. . ." and enter keywords describing the image you want to use.
    - OR -
    Click one of the category icons.
  3. Click once on the image you want to add to the worksheet and the following popup menu will appear:
    [Insert Image menu]

    • Insert Clip to add the image to the worksheet.
    • Preview Clip to view the image full-size before adding it to the worksheet. Drag the bottom, right corner of the preview window to resize the image and click the "x" close button to end the preview.
      [Preview Image window]
    • Add Clip to Favorites will add the selected image to your favorites directory that can be chosen from the Insert ClipArt dialog box.
    • Find Similar Clips will retrieve images similar to the one you have chosen.
  4. Continue selecting images to add to the worksheet and click the Close button in the top, right corner of the Insert ClipArt window to stop adding clip art to the worksheet.

Add an Image from a File

Follow these steps to add a photo or graphic from an existing file:

  1. Select Insert|Picture|From File on the menu bar.
  2. Click the down arrow button on the right of the Look in: window to find the image on your computer.
  3. Highlight the file name from the list and click the Insert button.
    [Insert Picture dialog box]

Editing a Graphic

Activate the image you wish to edit by clicking on it once with the mouse. Nine handles will appear around the graphic. Click and drag these handles to resize the image. The handles on the corners will resize proportionally while the handles on the straight lines will stretch the image. More picture effects can be changed using the Picture toolbar. The Picture toolbar should appear when you click on the image. Otherwise, select View|Toolbars|Picture from the menu bar to activate it.

[Picture toolbar]

  • Insert Picture will display the image selection window and allows you to change the image.

  • Image Control allows to to make the image gray scale, black and white, or a watermark.

  • More/Less Contrast modifies the contrast between the colors of the image.

  • More/Less Brightness will darken or brighten the image.

  • Click Crop and drag the handles on the activated image to delete outer portions of the image.

  • Line Style will add a variety of borders to the graphic.

  • Text Wrapping will modify the way the worksheet text wraps around the graphic.

  • Format Picture displays all the image properties in a separate window.

  • Reset Picture will delete all the modifications made to the image.


The AutoShapes toolbar will allow you to draw a number of geometrical shapes, arrows, flow chart elements, stars, and more on the worksheet. Activate the AutoShapes toolbar by selecting Insert|Picture|AutoShapes or View|Toolbars|AutoShapes from the menu bar. Click the button on the toolbar to view the options for drawing the shape.

[AutoShapes toolbar]

  • Lines - After clicking the Lines button on the AutoShapes toolbar, draw a straight line, arrow, or double-ended arrow from the first row of options by clicking the respective button. Click in the worksheet where you would like the line to begin and click again where it should end. To draw a curved line or freeform shape, select curved lines from the menu (first and second buttons of second row), click in the worksheet where the line should appear, and click the mouse every time a curve should begin. End creating the graphic by clicking on the starting end or pressing the ESC key. To scribble, click the last button in the second row, click the mouse in the worksheet and hold down the left button while you draw the design. Let go of the mouse button to stop drawing.

  • Connectors - Draw these lines to connect flow chart elements.
  • Basic Shapes - Click the Basic Shapes button on the AutoShapes toolbar to select from many two- and three-dimensional shapes, icons, braces, and brackets. Use the drag-and-drop method to draw the shape in the worksheet. When the shape has been made, it can be resized using the open box handles and other adjustments specific to each shape can be modified using the yellow diamond handles.
    [Octagon AutoShape]

  • Block Arrows - Select Block Arrows to choose from many types of two- and three-dimensional arrows. Drag-and-drop the arrow in the worksheet and use the open box and yellow diamond handles to adjust the arrowheads. Each AutoShape can also be rotated by first clicking the Free Rotate button on the drawing toolbar [Free Rotate button]. Click and drag the green handles around the image to rotate it. The tree image below was created from an arrow rotated 90 degrees.
    ["Tree" autoshape]

  • Flow Chart - Choose from the flow chart menu to add flow chart elements to the worksheet and use the line menu to draw connections between the elements.

  • Stars and Banners - Click the button to select stars, bursts, banners, and scrolls.

  • Call Outs - Select from the speech and thought bubbles, and line call outs. Enter the call out text in the text box that is made.

  • More AutoShapes - Click this button to choose from a list of clip art categories.

Each of the submenus on the AutoShapes toolbar can become a separate toolbar. Just click and drag the gray bar across the top of the submenus off of the toolbar and it will become a separate floating toolbar.

[AutoShapes] [AutoShapes]

Sorting and Filling Graphics Charts