Align objects

ShowAlign objects by their edges

Aligning objects (object: A table, chart, graphic, equation, or other form of information. Objects created in one application, for example spreadsheets, and linked or embedded in another application are OLE 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.

  1. On the Drawing toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), 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 (object: A table, chart, graphic, equation, or other form of information. Objects created in one application, for example spreadsheets, and linked or embedded in another application are OLE 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 (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), 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 (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), 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.

 
 
Applies to:
Excel 2003