Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Selecting Drawing Objects.
When you create a drawing in Excel, that drawing is made up of objects. The tools on the Insert tab of the ribbon allow you to create both text and graphics objects, which can be moved and arranged in virtually any manner desired.
The first step is selecting an object. Selecting an object is virtually the same as in many other Windows programs. All you need to do is point at the object with the mouse and then click the mouse button. You can tell when an object has been selected because it is surrounded by small squares called handles.
You can also build selection sets of objects. You do this by selecting the first object in the set, and then holding down the Shift key as you select each additional object. If you find you want to remove an object from your selection set, just hold down the Shift key and click your mouse on the object again.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12274) applies to Microsoft Excel 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Excel here: Selecting Drawing Objects.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Want to add some spice to the graphics in your worksheets? There are many colors and effects in Excel that allow you take ...
Discover MoreExcel doesn't limit you to only numbers and text in your worksheets. You can also add different types of shapes. Here's ...
Discover MoreAdd a drawing object to your worksheet, and at some point, you may want to change that object's size. You can easily ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2016-10-22 12:14:01
Jerry
When the drawing consists of a number of overlapping objects, it can be difficult to select the object(s) you want. In that case, the Selection Pane can be helpful. You can display it from either the Home tab, Editing group, Find & Select, Selection Pane... or, if an object is already selected, the Drawing Tools Format tab, Arrangement group, Selection Pane. To select multiple objects in the selection Pane, you must hold down the Ctrl key and click on the names of the objects. (Ctrl-click also works to select/deselect multiple objects directly on the worksheet.)
Another technique is to use a selection box to surround the objects you want to select. Turn on the Select Objects cursor (arrow) from the Home tab, Editing group, Find & Select, Select Objects. Then click and drag a box around the object(s) to be selected. All objects that are completely inside the selection box will be selected. To get out of selection mode, double-click anywhere.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments