bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Graphics > Selecting Drawing Objects

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!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)