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

In this video I share 2 ways to align and evenly distribute shapes in Excel. This includes charts, slicers, images, and any other shape on a worksheet.
Download the example file here: https://www.excelcampus.com/vba/align-space-distribute-shapes/

The first way is a manual approach using the Alignment tools that are built into Excel. The second way uses a set of macros to quickly align the shapes and distribute the shapes to create an even space/gap between them. These macros will save you a lot of time, especially when working on dashboard reports that contain a lot of slicers or charts.

Other videos in this series:

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

(Part 3) How to Layout Panel Charts or Shape Grids with a VBA Macro in Excel: https://youtu.be/8C1sCqLE1-c


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:23 Align & Space Shapes, Charts, or Slicers + VBA Macro
01:37 Step-by-step Guide to Align & Distribute Shapes
02:23 Automatically Align & Space Shapes Macros
05:49 The Macro Code