Align objects

Microsoft Office Excel 2003

Aligning objects may cause them to stack on top of each other. Make sure objects are positioned relative to one another the way you want before executing the command.

  1. Select the objects you want to align.

    To select multiple objects, hold down shift while you click each object.

  2. On the Drawing toolbar, click Draw, point to Align or Distribute, and then click one of the following options:
    • Align Top Button image
    • Align Bottom Button image
    • Align Left Button image
    • Align Right Button image

ShowAlign objects horizontally or vertically

The Align Middle command aligns objects horizontally through the middle of the objects. The Align Center command aligns objects vertically through the centers of the objects.

  1. Select the objects you want to align.
  2. On the Drawing toolbar, click Draw, point to Align or Distribute, and then click Align Middle Button image or Align Center Button image.

ShowAlign objects with cells

  1. On the Drawing toolbar, click Draw, and then point to Snap.
  2. To automatically align objects with the cell grid when you move or draw them, click To Grid.

    To automatically align objects with the vertical and horizontal edges of other shapes when you move or draw them, click To Shape.

ShowTip

You can also snap the object to the cell grid by holding down ALT while you move, draw, or resize a drawing object.