Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Reordering and Grouping Graphic Objects in Excel 2007

In Excel 2007, you may find the need to reorder objects in a worksheet or group multiple objects together so that they act as one unit. Reorder objects if you want to move an object in front of or behind other objects. When you group objects, you combine them; therefore, any changes you make affect the entire object. Changes include move, resize, flip, rotate, crop, and any style, shadow, or color changes. You can also create groups within groups to help you build complex drawings.

Reordering graphic objects

Follow these steps to control the order of graphic objects in a worksheet:

  1. Select the object you want to move.

  2. Click the arrow beside one of the following buttons in the Arrange group on the Drawing Tools tab:

    • Bring to Front: Includes Bring to Front, which places the selected object on top of all objects; and Bring Forward, which moves the selected object up one level.

    • Send to Back: Includes Send to Back, which places the selected object behind all objects; and Send Backward, which moves the selected object down one level.

  3. Select the desired option.

    The selected object moves to the new position.

    Rearranging the objects so the triangle is on top of the circle.
    Rearranging the objects so the triangle is on top of the circle.

Creating groups of objects

To group two or more objects together in a worksheet, follow these steps:

  1. Select two or more objects.

    Remember to hold down the Shift key or the Ctrl key to select multiple objects.

  2. On the Drawing Tool Format tab, choose Group→Group in the Arrange group.

    The selected objects become one object with a single boundary box around it. With grouped objects, any changes you make affect the entire object.

    A rectangle, circle, and triangle grouped together as one object.
    A rectangle, circle, and triangle grouped together as one object.

You can ungroup a group of objects at any time and then regroup them later. To ungroup the object, select the group and choose Group→Ungroup on the Drawing Tools Format tab. To regroup objects that have been previously grouped, select any object from the group and choose Group→Regroup on the Drawing Tools Format tab.

blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!