Changing the Size of a Graphic

Summary: Adding a graphic to a worksheet is easy. Getting that graphic to just the right size may take a little bit of trial and error. Here's how to adjust the size easily. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Excel allows you to easily resize a graphic you have placed in your workbook by following these steps:

Click on the graphic. A box appears around the object (this is designated by eight squares, or frame handles, around the outside of the graphic).
Use the mouse to point to one of the frame handles. Click on the left mouse button.
Drag the frame handle to resize the graphic.
Release the mouse button when the graphic is the size you want.

If you click and drag any of the four corner handles, then the proportions of the picture stay the same as you resize it. If you click and drag any of the other handles, the proportions of the picture are distorted.

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

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 Graphic