Excel 2010 Just the Steps For Dummies
Book image
Explore Book Buy On Amazon

When you're working with multiple objects or shapes in Excel 2010, you may 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. On the Drawing Tools Format tab, click the Align button in the Arrange group.

    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 after choosing Align Bottom and Distribute Horizontally.
      Three arrow objects aligned after choosing Align Bottom and Distribute Horizontally.

About This Article

This article is from the book:

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

This article can be found in the category: