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.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Excel doesn't limit you to only numbers and text in your worksheets. You can also add different types of shapes. Here's ...
Discover MoreWant to add some spice to the graphics in your worksheets? There are many colors and effects in Excel that allow you take ...
Discover MoreFilling one of Excel's drawing shapes with a picture of your choosing is a neat trick. Here's how to do it.
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