Microsoft KB Archive/178599

= XL98: Drawing Objects Don't Snap to Gridlines When You Press COMMAND =

Article ID: 178599

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q178599



SYMPTOMS
In Microsoft Excel 98 Macintosh Edition, if you hold down the COMMAND key and drag a drawing object in a worksheet, the drawing object does not snap to the gridlines in the worksheet. Instead, the shortcut menu for the drawing object appears.

This problem does not occur in Microsoft Excel for the Macintosh, version 5.x.



CAUSE
This problem occurs because, in Microsoft Excel 98 Macintosh Edition, the COMMAND key is used to display shortcut menus for drawing objects and AutoShapes.



WORKAROUND
There are two methods you can use to prevent this problem from occurring.

Method One
Instead of holding down the COMMAND key and then dragging the drawing object, start dragging the drawing object and then, while still holding the mouse button down, press and hold down the COMMAND key. When you do this, the drawing object will snap to the gridlines, and you can move it with the mouse. After the drawing object is in place, release the mouse button, and then release the COMMAND key.

Method Two
You can force Microsoft Excel 98 Macintosh Edition to snap all drawing objects to the gridlines by following these steps:


 * 1) On the Drawing toolbar, click the Draw menu, point to Snap, and click To Grid.
 * 2) Move a drawing object.

When you move a drawing object, it automatically snaps to the gridlines in the worksheet. To turn the feature off, click the Draw menu on the Drawing toolbar, point to Snap, and click To Grid again.



STATUS
This behavior is by design of Microsoft Excel 98 Macintosh Edition.



MORE INFORMATION
In Microsoft Excel for the Macintosh version 5.x, you can force a drawing object to snap to the gridlines when it is moved by holding down the COMMAND key while you move the object.

In Microsoft Excel 98 Macintosh Edition, however, this method may not work, depending on when exactly you press the COMMAND key. If you press the COMMAND key before moving the drawing object, the shortcut menu for the object appears. If you press the COMMAND key after beginning to move the drawing object, it moves and snaps to the gridlines in the worksheet.

Additional query words: XL98

Keywords: kbprb KB178599

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.