How to Align a Flow Chart in Excel with Shape Tools

Charts & pivot tables · Updated November 20, 2026

To align a flow chart in Excel, select the shapes you want to arrange, then use Shape Format > Align to line up their edges or centers; use Distribute Horizontally or Distribute Vertically to space three or more shapes evenly. Work in the desktop version of Excel for Microsoft 365 on Windows, and save a copy first if the diagram is important. Aligning the boxes creates a cleaner, easier-to-follow chart, while careful connector placement keeps the process flow clear.

What You’ll Need

  • An Excel workbook with a flow chart made from shapes. To add one, use Insert > Shapes and choose shapes from the Flowchart section.
  • A mouse or trackpad for selecting and moving shapes. A keyboard is helpful for selecting multiple objects precisely.
  • A little space around the diagram so you can move boxes without covering worksheet content. You can zoom in or out with the control at the bottom-right of the Excel window.
  • Optional: a saved copy of the workbook, especially if you plan to reposition many connected shapes at once.

Step-by-Step

  1. Show the whole flow chart. Open the worksheet and adjust the zoom until you can see all the shapes and connectors you intend to arrange. If the diagram is spread over a large area, note its current layout before making changes. Use the worksheet’s View tab to turn on Gridlines if seeing cell boundaries helps you judge spacing; these are worksheet gridlines, not printed lines around the shapes.
  2. Select the shapes for one alignment task. Click the first shape, then hold Ctrl and click each additional shape you want to include. On a Mac, hold Command instead of Ctrl. Select only the boxes that should share an edge or center: for example, select the process boxes in one vertical column, not every shape in the entire chart. Avoid selecting connectors for this step. If shapes overlap or are difficult to click, use Home > Find & Select > Selection Pane and select the relevant objects from the list. In the Selection Pane, object names may be generic, so click an entry to identify which shape it represents.
  3. Open the alignment commands. Once at least two shapes are selected, Excel displays the Shape Format tab on the ribbon. Choose Shape Format > Align. If the tab is hidden because the ribbon is narrow, widen the Excel window or look for the Shape Format tab among the contextual tabs. The Align menu contains commands for lining up object edges and centers, as well as commands for distributing objects.
  4. Choose an alignment that matches the layout. For a vertical column of process boxes, choose Align Center to put their horizontal centers on the same line. For boxes in a horizontal row, choose Align Middle to put their vertical centers on the same line. Align Left, Align Right, Align Top, and Align Bottom line up the corresponding edges. Choose based on the visual structure you want; for example, Align Left is useful when the left edges of a set of decision boxes should form a straight boundary. Look at the result before moving on, because alignment can shift several shapes at once.
  5. Make the gaps even when needed. Select at least three shapes in the same row or column, then choose Shape Format > Align > Distribute Horizontally or Distribute Vertically. Use horizontal distribution for a row and vertical distribution for a column. Excel spreads the selected shapes across the distance between the outermost objects; it does not automatically create a particular gap you specify. For a simple vertical sequence, first align the centers, then distribute vertically. With only two shapes, there is no intermediate gap to even out, so distribution is useful mainly when three or more objects are selected.
  6. Make box sizes consistent if the chart needs it. Select the boxes that should have matching dimensions. On Shape Format, use the Height and Width fields in the Size group to enter the same measurements for the selected boxes. Depending on the ribbon width, these fields may be compact or tucked into the Size group. Resizing a shape can change how its text fits, so check each label afterward. Keep a decision diamond or start/end symbol at its intended size if it should look different from process boxes.
  7. Reconnect and tidy the flow lines. Click a connector and check that its ends still meet the intended shapes. When creating or repairing a connection, use Insert > Shapes and select an appropriate connector from the Lines section, such as a straight or elbow connector. Drag an endpoint to a connection point on a shape until Excel indicates that it will attach. A connector attached to shapes generally follows them when moved, whereas a plain line can be left behind. Route lines so arrows are visible and do not cross labels where possible.
  8. Review the result at normal viewing size. Click a blank cell to clear the selection and inspect the chart. Check that the order of the steps is obvious, the boxes are readable, and connectors meet the correct shapes. If one box needs a small adjustment, select it and use the arrow keys for a small nudge; use the mouse for larger moves. Recheck the connectors after nudging. Save the workbook once the layout is right.

Common Mistakes

  • Selecting the whole chart when only one lane needs alignment. Aligning every object together can pull branches, labels, and decision symbols into an unintended line. Select one meaningful row or column at a time, and repeat the process for other parts of the chart.
  • Using the wrong alignment direction. Align Center lines up horizontal centers; it does not put shapes in a vertical row by itself. For a horizontal row, Align Middle is usually the relevant center command. If the boxes look aligned but the chart is still lopsided, check whether you chose the edge or center that suits the layout.
  • Expecting distribution to set a custom gap. Distribute commands even out the spaces among selected objects within the span they occupy. They do not let you type a gap measurement. Move the outer shapes to define the overall span before distributing the intermediate shapes.
  • Including connectors in the selection. A connector is an object too, and including it with boxes can produce an unexpected result. Align the shapes first, then inspect and adjust the connectors separately.
  • Dragging a line rather than an attached connector. Plain lines may not remain linked when boxes move. If a line separates from a box, replace it with a connector and attach its endpoint to a visible connection point.
  • Resizing after spacing without checking the layout again. Changing box width or height can alter the apparent gaps and may cause text to wrap. Set consistent sizes first when practical, then align and distribute, and review the final result.

Tips

  • Work in small groups. Arrange a main vertical path, then align the branches coming out of each decision separately. This keeps the chart’s logic intact and makes unintended shifts easier to undo.
  • Choose a clear reference edge. If boxes have different widths, Align Left can create a crisp left boundary, while Align Center can make the column feel balanced. Use the same principle consistently within each section.
  • Use the Selection Pane for crowded diagrams. Home > Find & Select > Selection Pane helps you locate and select shapes that overlap or sit behind other objects. It can also help identify objects before you change their position.
  • Keep connector routes simple. Prefer a straight connector for a direct link and an elbow connector when the path needs a right-angle turn. Leave enough space around decision shapes for branch labels and arrowheads.
  • Use small nudges for final polishing. After aligning and distributing, a minor position change may improve the chart’s balance. Make one adjustment at a time and check that the connector remains attached.
  • Remember that the worksheet grid is a visual aid. Gridlines help you compare positions with nearby cells, but the Align commands work on selected drawing objects. They do not align shapes to cell contents or change cell alignment.

Troubleshooting

The Align command is missing or disabled: Click a shape, then Ctrl-click another shape on Windows or Command-click on Mac. Excel shows Shape Format when drawing objects are selected. If you selected only cells, the shape alignment commands will not appear. If the objects are difficult to reach, use the Selection Pane to select them.

The shapes moved to an unexpected position: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then select a smaller, more relevant group. Check which alignment command you chose and whether a connector or an unrelated label was included. If the selection was correct but the result still looks wrong, try aligning the centers instead of the edges, or the other way around.

Distribution did not make the spacing look even: Confirm that three or more shapes are selected and that they belong in the same row or column. Distribution uses the outermost selected shapes as boundaries. If one selected shape is far away, it stretches the interval and can make the other gaps appear too large. Undo, remove that object from the selection, and distribute the intended group.

A connector no longer meets a box: Select the connector and move its endpoint back to a connection point on the shape. If it does not attach, it may be a plain line rather than a connector. Insert a connector using Insert > Shapes, then reconnect both ends. Check the line again after moving the boxes.

The boxes align but the text looks uneven: The shapes may have different sizes, internal text margins, or line breaks. Make the intended boxes the same height and width using the Shape Format Size fields, then review the text and adjust wrapping or wording where needed. Do not force a decision symbol to match a process box if that would make the chart harder to read.

The ribbon labels differ on Mac or Excel for the web: On current desktop Excel for Mac, select the objects and look for the contextual Shape Format tab; use Command-click to add objects to a selection. Ribbon placement can vary with window size. Excel for the web has more limited drawing-object editing, so if the Align commands are unavailable or behave differently, open the workbook in the desktop app to arrange the diagram.

Frequently Asked Questions

How do I align all flow chart boxes in Excel at once?
Select the boxes you want to align, then choose Shape Format > Align and select an edge or center command. For a complex chart, align one row or column at a time so branches are not pulled out of place.

How do I space flowchart shapes evenly?
Select at least three shapes in one row or column. Choose Shape Format > Align > Distribute Horizontally for a row or Distribute Vertically for a column. Position the outer shapes first because they define the area in which Excel distributes the others.

Can I align shapes to worksheet cells?
The Align commands arrange drawing objects relative to the other selected objects; they do not align a shape to text or values in cells. You can use worksheet gridlines as a visual reference, or move and resize the shapes manually to fit the cell layout.

Will connectors move when I align the boxes?
Connectors attached to shape connection points are designed to follow the connected shapes, though their routes may change. Inspect them after alignment. Plain lines are not necessarily attached and may need to be replaced with connectors.

Can I align shapes with different sizes?
Yes. Excel can align their edges or centers even when their dimensions differ. If the chart needs a consistent column of process boxes, set those boxes to the same height and width before distributing them; keep different shape types distinct when that improves meaning.

Why can’t I select a box that is behind another object?
Open Home > Find & Select > Selection Pane and choose the object from its list. You can also move the front object temporarily, select the box, and restore the front object afterward. The pane is usually the safer choice in a crowded diagram.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.