How to Edit Shape Vertices in Excel to Create Custom Arrows and Freeform Graphics

Excel’s standard shapes may not fit your specific design needs for diagrams or illustrations. You need to modify a shape’s outline to create a custom arrow or a unique graphic element. The Edit Points feature allows you to manipulate the vertices of any shape. This article explains how to use this tool to reshape objects for professional visuals.

Understanding the Edit Points Feature for Shapes

Every shape in Excel is defined by a series of points called vertices. Lines connect these vertices to form the shape’s outline. The Edit Points command makes this underlying structure visible and editable. You can access this mode for most shapes you insert from the Illustrations group on the Insert tab.

This feature is essential for creating graphics not available in the standard gallery. You can start with a basic rectangle and edit its points to design a unique arrowhead. You can also modify a freeform shape to match a specific logo or diagram component. The tool provides control over both straight lines and Bezier curves for smooth edges.

Types of Points and Segments

When you enter Edit Points mode, you will see two main elements. Vertices appear as small black squares. These are the corner points of the shape. Segments are the lines connecting the vertices. A straight segment is a simple line. A curved segment uses control handles to define its arc. You can right-click any segment to change its type.

Steps to Edit Shape Vertices and Create Custom Graphics

Follow these steps to modify a shape’s points. Start by inserting a basic shape as your starting template.

1. Insert and select your base shape
   Go to Insert > Illustrations > Shapes. Choose a shape like a Block Arrow or a Rectangle. Click and drag on your worksheet to draw it. Click once on the shape to select it. A bounding box with sizing handles will appear.
2. Open the Edit Points mode
   Go to the Shape Format tab that appears on the ribbon. In the Insert Shapes group, click the Edit Shape button. From the dropdown menu, select Edit Points. The shape’s outline will turn red, and its vertices will appear as small black squares.
3. Move an existing vertex
   Move your cursor over a black vertex square. The pointer will change to a four-directional arrow. Click and drag the vertex to a new location. The connected segments will stretch and move with it. This is the primary method for altering the shape’s form.
4. Add a new point to a segment
   Move your cursor over a red segment line where you want a new corner. Right-click on the line. From the context menu, select Add Point. A new black vertex will appear at that spot. You can now drag this new point to create a more complex outline.
5. Convert a segment to a curve
   Right-click on a straight segment line. From the menu, select Curved Segment. The line will become a smooth arc. White square control handles will appear. Drag these handles to adjust the curve’s depth and direction without moving the vertices.
6. Delete an unwanted vertex
   Right-click on the black vertex square you want to remove. Select Delete Point from the menu. The point is removed, and the shape’s outline redraws itself using the remaining vertices. This simplifies the shape.
7. Exit Edit Points mode
   Click anywhere on the worksheet outside the shape’s red outline. The vertices and red lines will disappear. Your shape will now display its new, custom form with the standard sizing handles.

Method for Drawing a Freeform Shape from Scratch

You can also create a completely custom shape without a base template.

1. Start the Freeform tool
   Go to Insert > Illustrations > Shapes. In the Lines group, click the Freeform icon. Your cursor will change to a crosshair.
2. Draw the shape
   Click on the worksheet to place your first vertex. Move the mouse and click again to place the next vertex, creating a straight line. For a curved line, click and drag instead of just clicking. Continue clicking to add points until the shape is nearly complete.
3. Close the shape
   To finish, move your cursor near the starting vertex. A small circle appears next to the cursor. Click on the first point to close the shape. The shape will fill with color, and you can then use Edit Points to refine it further.

Common Mistakes and Limitations When Editing Points

Shape Loses Fill Color or Formatting

Dragging a vertex too far can cause the shape’s outline to cross over itself. This creates an invalid polygon. Excel may then remove the fill color or apply unexpected formatting. To fix this, press Ctrl+Z to undo the last point move. Edit the vertices more gradually to avoid creating a self-intersecting shape.

Cannot Edit Points on Certain Shapes

The Edit Points command is not available for all object types. You cannot edit the points of a chart, a SmartArt graphic, or an icon from the Icons library. The feature works only with shapes from the Shapes gallery and lines. If the Edit Shape button is grayed out, you have selected an incompatible object type.

Curves Are Difficult to Control

The white control handles for curved segments move in opposite directions by default. This creates a smooth, continuous curve. To adjust one side of the curve independently, hold the Alt key while dragging a control handle. This breaks the linkage and allows you to create sharp corners or asymmetrical curves.

Edit Points vs. Merge Shapes: Key Differences

Item	Edit Points	Merge Shapes (Combine)
Primary Use	Alter the outline of a single shape	Combine or subtract multiple shapes to form one
Best For	Fine-tuning curves, creating custom arrows	Creating complex silhouettes, cut-out effects
Point Control	Direct manipulation of individual vertices	No direct vertex control after merging
Resulting Object	One editable shape with modified points	One new shape that cannot be unmerged
Access Path	Shape Format > Edit Shape > Edit Points	Shape Format > Insert Shapes > Merge Shapes

You can now design precise arrows and unique graphics directly within your Excel worksheet. Start by modifying a standard arrow shape to have a sharper or wider head. For your next project, try using the Freeform tool to trace a simple logo. Remember that holding Shift while dragging a vertex constrains its movement to horizontal, vertical, or 45-degree angles for cleaner designs.