Excel: Aligning Graphics Objects Along a Border

 Last reviewed: November 30, 1994
Article 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

KBCategory: kbother
KBSubcategory:

Additional reference words: 3.00 toolbar

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.