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

Aligning Multiple Graphic Objects in Excel 2007

When you're working with multiple objects or shapes in Excel 2007, you may occasionally need to align the objects in certain ways to improve their appearance in the worksheet. Excel provides several alignment options through the Align menu on the Drawing Tools Format tab.

Follow these steps to align graphic objects in a worksheet:

  1. Select the first object and then hold down the Ctrl key and select the other objects.

    For assistance in selecting multiple objects, select one object, click the Drawing Tools Format tab, and then click the Selection Pane button in the Arrange group. You can Ctrl+click multiple graphics in the pane that appears on the right.

  2. Click the Align button in the Arrange group on the Drawing Tools Format tab.

    A list of options appears.

    Select an alignment option from the Align drop-down menu.
    Select an alignment option from the Align drop-down menu.
  3. Choose a menu option:

    • Align Left: Aligns two or more objects so their left edges are the same as the leftmost selected object.

    • Align Center: Aligns two or more objects vertically through their centers.

    • Align Right: Aligns two or more objects so their right edges are the same as the rightmost-selected object.

    • Align Top: Aligns two or more objects so their top edges are the same as the highest-selected object.

    • Align Middle: Aligns two or more objects horizontally through their middles.

    • Align Bottom: Aligns two or more objects so their bottom edges are the same as the lowest-selected object.

    • Distribute Horizontally: Aligns three or more objects so they are equally spaced horizontally.

    • Distribute Vertically: Aligns three or more objects so they are equally spaced vertically.

    • Snap to Grid: When active, using any of the align options aligns the objects to the closest grid intersection. When Snap to Grid is turned on, nudging an object with the arrow keys moves the object one gridline at a time. With Snap to Grid turned off, nudging an object moves it one pixel at a time.

    • Snap to Shape: When active, aligns objects to gridlines that go through the horizontal and vertical edges of other objects.

    • View Gridlines: Turns the gridline display off and on in the Excel worksheet.

      Three arrow objects aligned center and middle.
      Three arrow objects aligned center and middle.
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.