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

DOWNLOAD EXCEL WORKBOOK

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)

Distribute and Align Shapes in Excel

Distribute and Align Shapes

Distribute and Align Shapes in Excel

Helpful Resource:

728x90

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Filter & Search The Search box within the Filter button is powerful if you know how to use it to your advantage.For example, if you had a list of customers the Search box allows you to find specific customers by typing in a few letters only, allows you to add a selection to your filtered lis...
Lock & Protect Formula Cells If you have a workbook with lots of formulas and you want to protect those formulas from being amended by other people who share your workbook, then you can!You need to follow these steps:1. Press the Go To Special shortcut CTRL+G2. Select the Constants box and press ...
How to Use Flash Fill In Excel  Flash Fill in Excel is a new feature that was introduced in Excel 2013.It is very handy as Excel predicts the rest of your inputs based on the first entry that you have placed. Once its prediction is correct and you confirm it, it will fill the rest of the rows lite...
Dynamic Data Validation List What´s a dynamic data validation drop down list in Excel, you say?Well, as you add new data into your Excel Table, your drop down list automatically gets updated.That is a cool feature and it means that you do not need to update your data validation source reference each ...