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

Remove Duplicates in an Excel Table When you have duplicates values within your Excel Table there is a quick and easy way to remove those values.The duplicate values could be all over your Excel Table and sometimes it takes valuable time trying to locate those duplicates and then deleting them.Not to worry,...
Excel’s Subtotal Feature Excel´s Subtotal feature is a great way to automatically insert a Sum/Count/Average/Max/Min subtotal to your data set with a press of a button.This feature is located under the Excel Data tools menu: Data > Subtotal.  To insert this feature you need to follow these quick s...
Extract Numbers Using Flash Fill In Excel  Flash Fill in Excel is a new feature that was introduced in Excel 2013.  Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column.One of the cool uses of Flash Fill is extracting the numbers from your text au...
Data Bars, Color Scales & Icon Sets Conditional Formatting has improved in Excel 2010 with the introduction of Data Bars, Color Scales & Icon Sets.Data Bars: Includes graphic bars in a cell, proportional to the cell’s value - Good for Financial AnalysisColor Scales: Includes a background color, proporti...