Changing the Size of a Drawing Object

Summary: Drawing objects are becoming more and more common in worksheets. If you need to change the size of a drawing object, you can do so by utilizing the object's drawing handles according to the techniques in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

You already know that you can use the Drawing toolbar to add graphic objects to your Excel worksheet. As you create and refine your drawings, there will doubtless be times when you need to change the size of objects. You can change the size of most objects by following these steps:

Select the pointer tool from the Drawing toolbar.
Point to the object whose size you want to change, and then select it by clicking the mouse button. Excel displays small boxes called handles around the object.
Point to one of the handles, click on it, and hold down the mouse button.
Drag the mouse. The size of the object will change as you move the mouse.
Release the mouse button when the object is the desired size.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2198) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

More Power! For some people, the prospect of creating macros can be scary. Those who conquer their fears, however, find they become much more confident and productive once they learn how to make Excel do exactly what they want. ExcelTips: The Macros is an invaluable source for learning Excel macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of ExcelTips. Learn at your own pace, exactly the way you want.

Check out ExcelTips: The Macros today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Changing the Size of a Drawing Object