Query, Share and Manage Excel workbooks on LAN, Internet

Graphics

Adding a Picture
To add a picture:

  • Click the Insert tab
  • Click the Picture button
  • Browse to the picture from your files
  • Click the name of the picture
  • Click Insert
  • To move the graphic, click it and drag it to where you want it

Insert Picture Dialog Box

Adding Clip Art
To add Clip Art:

  • Click the Insert tab
  • Click the Clip Art button
  • Search for the clip art using the search Clip Art dialog box
  • Click the clip art
  • To move the graphic, click it and drag it to where you want it

Insert Clip Art Search Box

Editing Pictures and Clip Art
When you add a graphic to the worksheet, an additional tab appears on the Ribbon.  The Format tab allows you to format the pictures and graphics.  This tab has four groups:

Adjust:  Controls the picture brightness, contrast, and colors
Picture Style:  Allows you to place a frame or border around the picture and add effects
Arrange:  Controls the alignment and rotation of the picture
Size:  Cropping and size of graphic

Format Picture Tab

Adding Shapes
To add Shape:

  • Click the Insert tab
  • Click the Shapes button
  • Click the shape you choose

Shapes Drop Down Menu

  • Click the Worksheet
  • Drag the cursor to expand the Shape

Edit Shape Picture

To format the shapes:

  • Click the Shape
  • Click the Format tab

Format Shapes Tab

Adding SmartArt
SmartArt is a feature in Office 2007 that allows you to choose from a variety of graphics, including flow charts, lists, cycles, and processes.  To add SmartArt:

  • Click the Insert tab
  • Click the SmartArt button
  • Click the SmartArt you choose

Insert Smart Art Dialog Box

  • Select the Smart Art
  • Drag it to the desired location in the worksheet

To format the SmartArt:

  • Select the SmartArt
  • Click either the Design or the Format tab
  • Click the SmartArt to add text and pictures.

Smart Art Tools Tabs