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.