Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

This video is the 2nd part in the series where I explain the macros that automatically align, space, and distribute shapes horizontally or vertically. The VBA macros work on all types of shapes in Excel including charts, slicers, images, etc.
Download the Excel file: https://www.excelcampus.com/vba/align-space-distribute-shapes/

The macros will align all of the selected shapes and create an even gap width space between each shape. This distributes the shapes horizontally or vertically with the click of a button.

The macros are especially useful for slicers. Slicers typically have a cascading layout that overlaps when you add multiple slicers to a sheet. This also happens when you duplicate any shape with the Ctrl+D shortcut.

We then have to take extra steps to align the shapes on the sheet. The macros automate the entire process and align our shapes to perfection.

Other videos in this series:

(Part 1) 2 Ways to Align & Distribute Shapes in Excel + VBA Macro: https://youtu.be/TU65nEnh7yE

(Part 2) Auto Align & Space Macro Explained: https://youtu.be/Wo6j3BJD6vI


Links mentioned in the video:

Video Playlist for Personal Macro Workbook video series: https://www.youtube.com/playlist?list=PLKbOx3gUV_E_tY-0oSzMw4NE0oFy5sI0_

3-Part Video Series on Pivot Tables & Dashboards: https://www.youtube.com/playlist?list=PLKbOx3gUV_E_9EZ_aOZiFJY1DbASEsbu_
00:00 Introduction
00:18 Align & Space Shapes, Charts, or Slicers + VBA Macro
01:21 Step-by-step Guide to Align & Distribute Shapes
06:01 Automatically Align & Space Shapes Macros
08:12 The Macro Code