Turn the snap to grid and snap to object options on or off in Excel

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

  1. Click the shape or other object, and then under Drawing Tools, on the Format tab, click Align.

    Align

  2. Do one or both of the following:

    • To snap shapes or other objects to the closest intersection of the grid, click Snap to Grid.

      Snap to grid or shape

    • 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.

      Snap to Shape

Turn off the snap-to options

  1. Click the shape or other object, and then under Drawing Tools , on the Format tab, click Align.

    Align

  2. To turn off these options, uncheck Snap to Grid or Snap to Shape.

Top of Page

Turn on the snap-to options

  1. Click the shape or object in the worksheet.

  2. Under Drawing Tools on the Format tab, in the Arrange group, click Align.

    The Format tab under Drawing Tools

    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.

  3. 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

  1. Click the shape or object in the worksheet.

  2. Under Drawing Tools on the Format tab, in the Arrange group, click Align.

    The Format tab under Drawing Tools

    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.

  3. Depending on which options are selected click Snap to Grid or Snap to Shape to disable these options.

Top of Page

See Also

Show or hide gridlines in Word, PowerPoint, or Excel

Draw or delete a line, connector, or freeform shape

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×