Excel: Aligning Graphics Objects Along a Border

ID: 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 "Microsoft Excel User's Guide" (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,"R10C5",0,0,"R10C5",50,50)


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



Reference(s):

"Microsoft Excel User's Guide," for the Macintosh, version 3.0, pages 514-516

"Microsoft Excel Function Reference," version 3.0, pages 40-41

Additional query words: toolbar 


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 23, 1999