Learn 5 ways to select multiple shapes in Excel dashboards. Shapes can include charts, slicers, images, shapes, annotations, icons, timelines, etc.
Download the example file: https://www.excelcampus.com/charts/select-multiple-shapes/


When copying or modifying multiple shapes, we first need to select them. In this video you will learn different techniques to select some or all of the shapes on the sheet.

I also explain how to use the Selection Pane to see a list of the shapes on the sheet. The Selection Pane allows you to select, rename, hide/unhide, and re-order the shapes.

You will also learn how to use the Select Objects tool to draw an area around the shapes you want to select. This is similar to the behavior of selecting shapes in PowerPoint slides.

You can use these techniques in combination with my previous videos on how to quickly align and distribute shapes. Here are the links to those videos.

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

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

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

Align & Size Excel Dashboard Elements with Snap to Shape: https://youtu.be/q1So06P1Xzc

I also explain more about working with shapes in part 3 of my video series on Pivot Tables & Dashboards. https://youtu.be/FyggutiBKvU

Pivot Tables & Dashboards Playlist: https://www.youtube.com/playlist?list=PLKbOx3gUV_E_9EZ_aOZiFJY1DbASEsbu_
00:00 Introduction
00:10 5 Ways to Select Multiple Shapes
00:26 Using the Ctrl Key
01:01 Using the Ctrl + A Keyboard Shortcut
01:54 Using the Selection Pane
03:16 Using the Select Objects Mode
05:36 Using the Go To Special Menu