MS-Excel / General Formatting

Align Multiple Graphics

  1. Select the first object and then hold down the Ctrl key and select any subsequent objects.
    For assistance in selecting multiple objects, select one object and then choose Drawing Tools Format> Arrange> Selection Pane.
  2. Choose Drawing Tools Format> Arrange> Align. A list of options appears.
  3. Choose a menu option. Some options include:
    • Align Left: Aligns two or more objects so their left edges are the same as the leftmost selected object.
    • 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 Bottom: Aligns two or more objects so their bottom edges are the same as the lowest-selected object.
    • 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.
    • View Gridlines: Turns the gridline display off and on in the Excel worksheet.
[Previous] [Contents] [Next]

In this tutorial:

  1. Excel Graphics, Shapes WordArt and Text Boxes
  2. Using Shapes to Display Cell Contents
  3. Create a Custom Shape
  4. Formatting Shapes
  5. Reshaping Shapes and Printing objects
  6. Adding text boxes
  7. WordArt for Interesting Titles and Headlines
  8. Constructing SmartArt
  9. Add Clip Art
  10. Manipulate Graphics
  11. Adding Pictures to a Worksheet
  12. Crop an Image
  13. Picture Borders, Effects, and Styles
  14. Align Multiple Graphics
  15. Save your Graphic