Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later 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 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.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2194) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Selecting Drawing Objects.
Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!
Not only can you place drawing objects in your worksheets, but you can organize those objects so some are in front and ...
Discover MoreWhen adding AutoShapes to a worksheet, it can be bothersome to continually work with the menu structure to place them. It ...
Discover MoreOne way to make your text boxes "stand off" the page is to add a drop shadow to them. This tip shows just how easy it is ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2018 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: 
Comments