How to Manipulate Excel 2007’s Graphic Objects

Excel 2007 provides many tools that enable you to manipulate graphic objects in your worksheets. You can delete, move, resize, rotate, flip, and crop objects, for example. Cropping an image or picture allows you to remove unwanted portions of the picture.

Manipulating graphics

To manipulate graphic objects in the worksheet, follow these steps:

  1. Select the object you want to modify.

    Selection handles appear around the object.

    A selected object with eight selection handles and a rotation handle.
    A selected object with eight selection handles and a rotation handle.
  2. Perform any of the following actions on the object:

    • Delete: Press the Delete key on the keyboard.

    • Move: Position the mouse pointer over the object, but not on the handles. Click and drag the object to the desired location. Optionally, nudge a selected object using the up, down, left, or right arrow keys. To move a text box, position the cursor on one of the edges, between two selection handles.

    • Resize: To resize an object, position the mouse pointer over one of the white selection handles and click and drag the handle until the object reaches the desired size. Use the top or bottom middle handles to resize the object height. Use the middle left or right handles to resize the object width. Use a corner handle to resize both the height and width. If you want to maintain proportions when resizing an object, hold down the Shift key.

    • Rotate Shape: Position the mouse over the green rotation handle until the pointer turns into a circle. Then, drag the green rotation handle until the object rotates to the desired angle. This does not apply to arrows.

      Use the rotation handle to rotate shapes or other objects.
      Use the rotation handle to rotate shapes or other objects.

Cropping an image

Follow these steps to crop an image and remove unwanted portions:

  1. Select the image.

  2. Click the Crop button on the Picture Tools Format tab.

  3. Position the mouse pointer over one of the crop handles that surround the image.

    You can crop an image to remove undesired areas of a picture.
    You can crop an image to remove undesired areas of a picture.
  4. Click and drag a crop handle inward to crop out an area of the image.

  5. Release the mouse button.

    Excel crops the image.

  6. Continue cropping other edges of the image, as needed.

  7. Click the Crop button again to turn off the Crop tool.

Rotating or flipping an object

Use the following steps to rotate or flip an object:

  1. Select the object you want to rotate or flip.

  2. Click the Rotate button in the Arrange group on the Picture Tools Format tab.

    A menu of choices appears. As you pause your mouse over a menu option, Excel previews the effect on the picture.

    An image before and after flipping the object horizontally.
    An image before and after flipping the object horizontally.
  3. Select from the following options:

    • Rotate Right 90°

    • Rotate Left 90°

    • Flip Vertical

    • Flip Horizontal

Choose More Rotation Options to display the Size and Properties dialog box, where you can set many options precisely, including size, rotation, and cropping.

blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.