Microsoft KB Archive/80010

= Excel: Aligning Graphics Objects Along a Border =

PSS ID Number: 80010

Article Last Modified on 2/11/2002



This article was previously published under Q80010



SUMMARY
Multiple graphic objects can be aligned with each other along any side by using one of the following methods.

The first method uses worksheet borders to align objects:


 * 1) Drag the objects to an edge of the worksheet (be sure they touch the edge).
 * 2) Use the selection tool in the tool bar or hold down SHIFT and click to select all the objects.
 * 3) While the objects are still selected, drag the group to its final position. The objects will maintain their alignment.

The second method uses a layout grid as shown on pages 514-516 in the &quot;Microsoft Excel User's Guide&quot; (Macintosh) version 3.0 manual.

The third method (Macintosh only) uses the COMMAND key to drag objects:


 * 1) Hold down COMMAND and drag an object to the desired row and column. The object will be placed in the upper-left corner of a cell.
 * 2) Drag subsequent objects while holding down COMMAND to align them with the same row or column border.

The fourth method involves writing a macro that creates the objects relative to cells in the same row or column. This macro will use X_offset1 and Y_offset1 parameters of 0. For example:

  =CREATE.OBJECT(6,&quot;R10C5&quot;,0,0,&quot;R10C5&quot;,50,50)

For more information on the CREATE.OBJECT macro function, refer to pages pages 40-41 in the &quot;Microsoft Excel Function Reference&quot; version 3.0 manual.

