#Chart tools menu in excel 2016 download

All shapes that are completely inside the area you’ve drawn will then be selected. You basically draw an area around the shapes you want to select. You can highlight by clicking at one corner of your desired area, holding the left mouse button down while moving to the opposite corner, and then releasing the button. Once you've turned this mode on, you simply highlight the area around all of the shapes you want to select. This is also found under the Find & Select dropdown menu on the Home tab of the ribbon. If all of our shapes are clustered in the same area, we may want to make use of the Select Objects mode. The pane also gives us the ability to hide and unhide shapes, or to bring forward shapes that are overlapped by other objects. This is especially convenient if our worksheet is large in area and we don’t want to hunt for particular objects. The Selection Pane allows us to see all the shapes on our sheet in list form. You’ll find that option when you right-click on Selection Pane in the dropdown. If you don’t have a shape already selected, the Selection Pane can be found in the ribbon under the Home tab, in the Find & Select dropdown menu.įor ease of use in the future, you can easily add the Selection Pane button to your Quick Access Toolbar. It will appear to the right of the worksheet. If you already have one or more shapes selected, click on the Format tab, and then the Selection Pane button to toggle on the Selection Pane. Because this option selects all of the shapes on our sheet, if there are certain shapes we want to exclude, we would need to use the Ctrl key, as in Option 1, to deselect the shapes we don’t want included. This option saves time if we have many shapes and don’t want to select each of them individually. Keyboard shortcut to Select all Shapes on a Worksheet: Ctrl+ A Hold the Ctrl key, then press the A key to select all of the shapes on the sheet. Option 2: Using the Ctrl + A Keyboard ShortcutĪs with Option 1, you will want to select one shape first, being sure to click on the border of the shape, not one of its components. After the first shape is selected, you can click anywhere on the other shapes to select them (while holding the Ctrl key). Otherwise you might start editing the shape instead of selecting it. When you select the first chart or shape, make sure to click on the border of the shape, not just one of the elements inside it. Using the Shift key instead of Ctrl will produce the same outcome. This allows us to pick and choose which shapes we want to manipulate. Option 1: Using the Ctrl KeyĪfter selecting one shape, we can hold down the Ctrl key while clicking on other shapes we want selected. Which option you choose might depend on whether you want to select just some of the shapes on your worksheet or all of them, or whether you are more comfortable with keyboard shortcuts versus using the ribbon menu. Shapes can include charts, images, slicers, text boxes, photos, callouts, and more.īelow are five ways to quickly select several shapes at once.

Or just moving your images in bulk to another location on your worksheet.Changing the size or properties of shapes.

5 Ways To Select Multiple Shapes.xlsx Download Selecting Multiple Shapesīeing able to select many shapes simultaneously can be a real time-saver when you want to perform the same action on several objects at once.

#Chart tools menu in excel 2016 download