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

Tips.Net > ExcelTips Home > Graphics > Changing an AutoShape

Changing an AutoShape

Summary: One type of graphic you can insert in a workbook is an AutoShape. Once placed, AutoShapes can be easily changed to any of the other AutoShapes for the desired effect. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

If you are using AutoShapes in your workbooks, there may be times when you want to completely change an AutoShape from one to another. For instance, you may want to change one banner shape to another. While you can simply delete your original AutoShape and then draw a new one, Excel makes it easy to change AutoShapes by following these steps:

  1. Make sure the Drawing toolbar is displayed.
  2. Select the AutoShape you want to change. Handles should appear around the outside of the shape.
  3. Click your mouse on Draw on the Drawing toolbar, and then choose Change AutoShape. The familiar AutoShape categories appear.
  4. Select the AutoShape you want to use.

Excel changes the AutoShape used, without changing the overall size or shape of the bounding rectangle that contains the AutoShape. You can then proceed to edit the new AutoShape, as desired.

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


PivotTables Got You Perplexed? ExcelTips: PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of the PivotTable Wizard, how to edit PivotTables, how to format them, how to customize them, and much more.
 
Check out ExcelTips: PivotTables for the Faint of Heart today!

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.)