Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021. 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.
Written by Allen Wyatt (last updated July 23, 2022)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021
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, 2016, 2019, Excel in Microsoft 365, and 2021. 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!
Drawing objects can be layered over each other in almost any manner you desire. If you want to change the order in which ...
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 a worksheet and chances are good you'll need to move it in some way. Here's how to use the mouse ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2022-07-30 09:41:20
Alex Blakenburg
Thanks Peter
2022-07-30 08:36:23
Peter Atherton
Alex,
That's really interesting, I've allways used the mouse but I will try this next time.
Peter
2022-07-29 09:21:13
Alex Blakenburg
Another option is to open the Selection Pane using Alt+F10. You can then select the object or objects using the list of items in the pane.
Also after selecting 1 object using either method, ctrl+A will select all the objects.
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 © 2024 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021. 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