Can You Align Shapes in Excel? A Practical Guide to Layout

How-to basics · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, select two or more shapes, then choose Shape Format > Align and pick an option such as Align Left, Align Center, or Distribute Horizontally. These commands line up or space the selected objects relative to one another; they do not automatically snap their edges to worksheet cell boundaries.

What shape alignment does in Excel

Excel treats a drawn shape as an object placed over the worksheet grid. Alignment commands adjust the position of selected objects so their edges or centers share a common line. For example, Align Left moves the selected shapes so their left edges match. Align Middle lines up their vertical centers, while Distribute Vertically spaces them evenly from top to bottom.

This is useful for arranging flowcharts, process diagrams, callouts, buttons, icons, and other visual elements. It can make a worksheet easier to scan and more polished, especially when several shapes need to form a row or column. Alignment changes the objects’ positions, not the text inside them, the cells underneath them, or the contents of the worksheet.

Shapes include items drawn from the Insert tab, such as rectangles, arrows, lines, and callouts. Some other objects, including text boxes and pictures, can also be arranged with alignment commands. The precise options available can depend on the types of objects selected and the Excel version.

How to align multiple shapes

Use this sequence in Excel for Microsoft 365 on Windows:

  1. Click the first shape. Hold Ctrl and click each additional shape you want to include. You should see selection handles around each selected object.
  2. Open the contextual Shape Format tab on the ribbon. It appears when a shape is selected; depending on the ribbon layout, it may be labeled Shape Format or shown under drawing tools.
  3. Choose Align in the Arrange group.
  4. Select the desired command, such as Align Left, Align Center, Align Top, or Distribute Horizontally.

For a simple example, imagine three rectangles placed at slightly different heights. Select all three and choose Align Middle to place their vertical centers on the same horizontal line. If you want a neat row with equal gaps, choose Distribute Horizontally after making sure the rectangles are in the intended left-to-right order.

To select a set of nearby objects at once, you can also drag a selection box around them. Take care not to include unrelated shapes. If clicking a shape instead selects a worksheet cell, click near the object’s edge or use the Selection Pane described below.

Choosing the right alignment command

The best command depends on whether you need a shared edge, a shared center, or even spacing. Align commands move objects into a common position; distribute commands adjust the gaps between them. These are related but not interchangeable tasks.

  • Align Left, Align Center, and Align Right position objects by their horizontal edges or centers.
  • Align Top, Align Middle, and Align Bottom position objects by their vertical edges or centers.
  • Distribute Horizontally evens out the horizontal gaps across three or more selected objects.
  • Distribute Vertically evens out the vertical gaps across three or more selected objects.

With only two objects, distributing them may not produce the useful “even spacing” people expect; the two objects simply define the endpoints of the arrangement. For a row of cards, for example, first align their top edges, then distribute them horizontally. Alignment establishes the row, and distribution handles the gaps.

Center and Middle are easy to confuse. Align Center matches objects’ horizontal centers, which creates a vertical line through them. Align Middle matches their vertical centers, which creates a horizontal line through them. Choose based on the direction of the line you want.

Selecting objects reliably

Accurate alignment depends on selecting exactly the objects you intend to move. Ctrl-clicking is convenient when objects are separated. If shapes overlap, are small, or sit behind other objects, Excel’s Selection Pane can make the selection more reliable.

On Windows, open Home > Find & Select > Selection Pane. The pane lists objects on the sheet. Select names in the list to work with the corresponding objects; use Ctrl-click to add or remove individual objects from a selection. The pane can also help identify an object that is hard to click on the worksheet. You can rename objects there to make a complex diagram easier to manage.

After selecting objects, check that each intended shape is included before choosing an alignment command. If a shape disappears from view, it may have been moved behind another object or outside the visible worksheet area. The Selection Pane can help you locate and select it without relying on its position in the drawing.

Shapes and worksheet cells are different

A common misconception is that Align Left will place a shape flush with the left edge of a particular cell. It does not work that way: the command aligns the selected objects with each other. To position one shape against a cell boundary, drag it manually while watching the worksheet grid, or use Excel’s snapping behavior where available. The Align menu also contains grid-related options in many desktop versions, but those options affect positioning relative to the grid rather than replacing alignment among selected objects.

Shapes are anchored to worksheet locations, and their behavior can be configured if rows or columns change size. Right-click a shape and choose Format Shape; in the pane, open Size & Properties > Properties. Depending on the object and version, you can choose whether it moves or resizes with cells, moves without resizing, or does not move or resize with cells. This setting affects how the object responds when the sheet changes; it is separate from aligning several shapes.

For example, a label placed over a table may need to move with its row when rows are inserted. A decorative title above the table may be better kept independent of cell resizing. Choose the property based on how the worksheet is expected to change, then check the layout after inserting or resizing rows and columns.

Aligning, distributing, and grouping a diagram

For a diagram with repeated elements, it often helps to align first and distribute second. Suppose a process map has four boxes connected in a horizontal sequence. Select the boxes, use Align Middle to put them on one horizontal line, and then use Distribute Horizontally to regularize the gaps. Add or adjust connector lines afterward, because moving boxes can leave connectors at awkward angles or positions.

Grouping is useful once a set of objects has its internal layout. Select the relevant shapes and choose Shape Format > Group > Group. Excel then treats the group as one object when you move or align it alongside other objects. Grouping does not replace careful alignment inside the group: if the individual components are uneven before grouping, they remain uneven afterward.

If you need to adjust one shape in a group, select the group and then select the individual object, or ungroup the objects, make the change, and group them again. Avoid grouping unrelated items simply to make selection easier if you expect to align those items individually later.

Common problems and how to fix them

  • Align is unavailable or an option is disabled: Confirm that you selected multiple compatible objects, rather than just a cell or one shape. Some commands, particularly distribution, may require three or more objects to be useful or enabled.
  • The wrong object moves: Check the selection handles or use the Selection Pane to confirm which shapes are selected. A shape behind another object can be difficult to target directly.
  • Shapes line up but the gaps look uneven: Use a distribution command after aligning their edges or centers. Alignment alone does not make spaces equal.
  • A shape shifts after changing row height or column width: Review its cell-related behavior under Format Shape > Size & Properties > Properties. The chosen setting determines whether it moves or resizes with cells.
  • The layout changes when printed: Alignment on the sheet does not guarantee that all objects fit within a printed page. Check print preview and the page layout, especially if the worksheet is scaled or split across pages.

Also distinguish aligning objects from aligning text inside a shape. To change the text’s position within a box, select the shape and use the text alignment controls on the Home tab or the formatting options for the shape. Shape alignment changes where the box sits on the worksheet; text alignment changes where the words sit inside that box.

Excel for Mac and Excel for the web

In Excel for Mac, select the objects and look for the Shape Format tab and its Align menu. The ribbon may be arranged differently from Windows. To add separate objects to a selection, use Command-click rather than Ctrl-click. The names or availability of some controls can vary by release.

Excel for the web supports many everyday worksheet and object tasks, but drawing and arrangement controls can differ from the desktop app. If an alignment option is missing or the selection is difficult to manage in a browser, open the workbook in the desktop version of Excel and use the Shape Format ribbon there. Keep in mind that collaborators may see layout changes when they open the file in a different Excel version.

Frequently Asked Questions

Can I align shapes to cells in Excel?
Not with the usual Align Left or Align Center commands; those align selected objects with one another. For cell-relative placement, position the shape against the grid and set how it behaves when cells move or resize under Format Shape > Size & Properties > Properties.

Can I align shapes without moving them individually by hand?
Yes. Select the objects together and use Shape Format > Align. Excel applies the chosen alignment to the selected set, so you do not need to drag each shape into position separately.

Why can’t I distribute two shapes evenly?
Distribution is intended to space a series of objects between endpoints. With only two shapes, there is no intermediate gap pattern to even out. Add another object if you need an evenly spaced series, or position the two objects manually.

Can I align shapes and pictures together?
Often, yes. Select the picture and shapes together and check the Align menu. Available commands can depend on the object types and Excel version. If an option is unavailable, arrange compatible objects separately or use the desktop app.

Does grouping shapes keep them aligned?
Grouping keeps the objects together when you move or resize the group, but it does not automatically correct their existing positions. Align the individual shapes first if you want their internal edges or centers to match.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.