Manipulating Excel 2010's Graphic Objects

Excel 2010 provides many tools that let you 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 by clicking it.

    Selection handles appear around the object.

  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 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 pointer 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.

      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. On the Picture Tools Format tab, click the Crop button in the Size group on the far right.

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

  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.

    You can crop an image to remove undesired areas of a picture.
    You can crop an image to remove undesired areas of a picture.
  6. Continue cropping other edges of the image, as needed.

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

Cropping a picture is a delicate process that can easily go too far. If you accidentally crop out too much of the picture, pressing Ctrl+Z will quickly undo your last cut.

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. On the Picture Tools Format tab, click the Rotate button in the Arrange group.

    A menu of choices appears.

  3. Select from the options.

    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.

Choose More Rotation Options to display the Format Picture 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.