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

Tips.Net > ExcelTips Home > Graphics > Symmetric Resizing of Graphics

Symmetric Resizing of Graphics

Summary: When you resize graphics by clicking and dragging, you may end up with a distorted image. That is, unless you use the shortcut in this tip that allows symmetric resizing of your graphics. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

When you click on a graphic placed in your worksheet, eight selection handles appear around the object. These handles allow you to resize and crop the graphic in ways previously detailed in ExcelTips.

One cool resizing feature is implemented if you hold down the Ctrl key while dragging one of the handles. Doing so causes Excel to symmetrically resize the image, adjusting not only the handle selected, but the handle opposite the one selected.

For instance, if you hold down the Ctrl key and drag the handle at the center of the right edge of the graphic inward by a half inch, then Excel also moves the left edge of the graphic inward by a half inch.

Tip #2493 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007


Got the Time? If you work with either times or dates in Excel, you really need ExcelTips: Times and Dates. Everything you need to know about slicing, dicing, and generally working with times and dates.

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 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.)