Pinterest Pixel

Distribute and Align Shapes in Excel

Imagine you have a lot of shapes in your Excel file and the shapes are all over... read more

Download Excel Workbook
Bryan
Posted on

Overview

Distribute and Align Shapes in Excel | MyExcelOnline Distribute and Align Shapes in Excel | MyExcelOnline

Imagine you have a lot of shapes in your Excel file and the shapes are all over the place!

You want to organize the shapes but it seems a pain to move them one by one!

What would you do?

Thankfully, Excel allows you to distribute and align shapes!

This is our initial layout of shapes:

Distribute and Align Shapes in Excel

Distribute and Align Shapes in Excel | MyExcelOnline

Download excel workbookDistribute-and-Align-Shapes.xlsx

STEP 1: Hold the CTRL key and select all of the shapes you want to move:

Distribute and Align Shapes in Excel

 

STEP 2: Go to Format > Arrange > Align > Align Bottom

You can Align the shapes to the direction that you want (i.e. Left, Center, Right, Top, Middle, Bottom)

Distribute and Align Shapes in Excel

 

STEP 3: Go to Format > Arrange > Align > Distribute Horizontally

You can Distribute the shapes either Horizontally or Vertically.

This will ensure the distance between the shapes are equally distributed.

Distribute and Align Shapes in Excel

 

Your shapes are now in good shape! (Pun intended)

See also  Excel Lineweaver Burk Plot - Step by Step Guide for Biochemists

Distribute and Align Shapes in Excel

Distribute and Align Shapes

 

Helpful Resource:

728x90

 

If you like this Excel tip, please share it
Distribute and Align Shapes in Excel | MyExcelOnline Distribute and Align Shapes in Excel | MyExcelOnline
Distribute and Align Shapes in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...