
Tips.Net > ExcelTips Home > Graphics > Selecting Drawing Objects
Summary: Excel allows you to add all sorts of drawing objects to your worksheets. Using the tools in the Drawing toolbar, you can easily select individual drawing objects so that you can take some action on them. This tip explains how you can perform the selection of both individual and groups of objects. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
When you create a drawing in Excel, that drawing is made up of objects. The tools on the Drawing toolbar 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.
Tip #2194 applies to Microsoft Excel versions: 97 2000 2002 2003
Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.
Check out ExcelTips Premium today!
Have thousands of ExcelTips at your fingertips, on your own system. Answer your own questions or help support others. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips
Advertise on the
ExcelTips Site