How to Align and Distribute Shapes and Objects Evenly in Excel

You have inserted shapes, icons, or text boxes into an Excel worksheet, but they look messy and unprofessional. The objects are scattered at different positions and have uneven spacing between them. Excel provides built-in alignment and distribution tools to arrange objects precisely. This article explains how to use these tools to create clean, organized diagrams and layouts.

Understanding Excel’s Alignment and Distribution Tools

Excel’s alignment features are part of the Drawing Tools Format tab, which appears when you select any shape, text box, icon, or picture. These tools work on multiple selected objects at once. Alignment changes the position of objects relative to each other or the worksheet. Distribution adjusts the spacing between three or more objects so the gaps are equal.

Before you start, you need to insert objects from the Insert tab. Common objects include shapes from the Shapes gallery, icons from the Icons gallery, and text boxes. You must select all the objects you want to arrange before the alignment commands become active. A crucial prerequisite is setting the correct object properties. This controls whether your carefully aligned objects will stay in place if you filter data or adjust column widths.

Object Positioning Properties

By default, objects in Excel are set to move and size with cells. This means if you insert a column, the shape may shift. For stable alignment, you should often change this. Right-click the object, select Format Shape, and open the Size & Properties section. Under Properties, choose “Don’t move or size with cells” to lock the object’s position on the sheet.

Steps to Align and Distribute Objects

The core process involves selecting objects and then choosing commands from the Align menu. Follow these steps to arrange objects neatly.

1. Insert and select your objects
   Go to Insert > Illustrations and add your shapes, icons, or text boxes. Click the first object, then hold down the Ctrl key and click each additional object you want to include in the arrangement. You will see selection handles around all chosen items.
2. Open the Drawing Tools Format tab
   With the objects selected, the Drawing Tools Format tab appears on the ribbon. Click it to reveal the formatting commands. If you are using pictures, the Picture Tools Format tab appears instead, but it has the same Align button.
3. Align objects to a common edge or center
   In the Arrange group, click the Align button. From the dropdown menu, choose an alignment. Select Align Left to line up objects by their left edges. Choose Align Top to line them up by their top edges. Use Align Center or Align Middle to center the objects vertically or horizontally relative to each other.
4. Distribute objects for even spacing
   Keep the objects selected. Click Align again. To space objects evenly side-to-side, select Distribute Horizontally. To space them evenly top-to-bottom, select Distribute Vertically. You must have at least three objects selected for these commands to work.
5. Align to the sheet or margin
   For precise placement relative to the entire worksheet, use the Align to options. Click Align > Align to Margin. Now, when you choose Align Left, objects will snap to the left page margin instead of aligning to each other. Use Align > Align Selected Objects to return to aligning objects relative to one another.

Using the Selection Pane for Complex Layouts

When objects overlap or are hard to click, use the Selection Pane. Go to Drawing Tools Format > Arrange > Selection Pane. This pane lists all objects on the sheet. You can select items from the list, hide them, or change their order. This makes it easier to manage many objects before alignment.

Common Mistakes and Limitations to Avoid

Users often encounter specific issues when trying to align objects. Knowing these pitfalls helps you achieve perfect results every time.

Alignment Commands Are Grayed Out

If the Align button is inactive, you likely have only one object selected, or no objects are selected. You can also not align charts or embedded objects like WordArt with standard shapes using these tools. Ensure you have selected two or more compatible objects from the Shapes, Icons, or Text Box categories.

Objects Move After Alignment When Scrolling

This happens because the object properties are set to move with cells. To fix it, right-click the object, select Format Shape, and go to Size & Properties > Properties. Change the option to “Don’t move or size with cells”. This locks the object’s position on the printed page layout.

Distribution Creates Unexpected Gaps

The Distribute commands equalize the space between the outermost edges of the first and last selected objects. If your objects are very different sizes, the visual spacing might still look uneven. For a uniform look, make objects the same size first using the Height and Width boxes on the Format tab before distributing them.

Alignment Methods Comparison

Item	Align Objects	Distribute Objects
Primary Purpose	Line up edges or centers of objects	Create equal space between objects
Minimum Objects Required	Two	Three
Key Menu Path	Drawing Tools Format > Align > [Left, Center, etc]	Drawing Tools Format > Align > Distribute Horizontally/Vertically
Relative To	Each other or the worksheet margins	The outermost selected objects
Best For	Creating straight lines of shapes	Making consistent gaps in a row or column

You can now create professional-looking flowcharts, diagrams, and layouts in your worksheets. Use the Align and Distribute tools to quickly tidy up any group of shapes or icons. For more control, try using the gridlines and snap to grid feature under View > Show. An advanced tip is to group your aligned objects by selecting them and pressing Ctrl+G. This lets you move the entire arrangement as one single object.