When you draw, resize, or move a shape or other object in Excel, you can set it so that it will align or "snap" to the nearest intersection in the grid (even if the grid is not visible) or snap to other shapes or objects. However, you can control the alignment and snap-to capabilities by turning it off.
Turn on the snap-to options
-
Click the shape or other object, and then on the Shape Format tab, under Arrange, click Align.
-
Do one or both of the following:
-
To snap shapes or other objects to the closest intersection of the grid, click Snap to Grid.
Gray highlighting indicating the option is selected turns on.
-
To snap shapes or other objects to grid lines that go through the vertical and horizontal edges of other shapes or objects, click Snap to Shape.
Gray highlighting indicating the option is selected turns on.
-
Turn off the snap-to options
-
Click the shape or other object, and then on the Shape Format tab, in the Arrange group, click Align.
-
To turn off these options, click Snap to Grid or Snap to Shape.
The gray highlighting indicating the option is selected turns off.
Turn on the snap-to options
-
Click the shape or object in the worksheet.
-
Under Drawing Tools on the Format tab, in the Arrange group, click Align.
If you do not see the Drawing Tools or Format tabs, make sure that you selected a shape or an object. You might have to double-click the shape or object to open the Format tab.
-
Do one or both of the following:
-
To position shapes or objects to the closest intersection of the grid, click Snap to Grid.
-
To position shapes or objects to grid lines that go through the vertical and horizontal edges of other shapes or objects, click Snap to Shape.
-
Note: To temporarily override the snap-to options, hold down ALT while you drag the shape or object.
Turn off the snap-to options
-
Click the shape or object in the worksheet.
-
Under Drawing Tools on the Format tab, in the Arrange group, click Align.
If you do not see the Drawing Tools or Format tabs, make sure that you selected a shape or an object. You might have to double-click the shape or object to open the Format tab.
-
Depending on which options are selected click Snap to Grid or Snap to Shape to disable these options.
No comments:
Post a Comment