Скачать или смотреть 5 Ways to Select Multiple Shapes for Excel Dashboards

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/se...


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):    • 2 Ways to Align & Distribute Shapes in Exc...  

The Auto Align & Space Shapes Macros Explained (Part 2):    • The Auto Align & Space Shapes Macros Expla...  

How to Layout Panel Charts or Shape Grids with a VBA Macro in Excel (Part 3):    • Vba Macro: How To Layout Panel Charts Or S...  

Align & Size Excel Dashboard Elements with Snap to Shape:    • Align & Size Excel Dashboard Elements with...  

I also explain more about working with shapes in part 3 of my video series on Pivot Tables & Dashboards.    • How to Create a Dashboard Using Pivot Tabl...  

Pivot Tables & Dashboards Playlist:    • Excel Pivot Tables  
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