Welcome toExcel2007.Tips.Net
Helpful Links
ExcelTips
Money Tips
Pet Tips
Wedding Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Changing a Shape
Summary: Insert a graphic shape into a worksheet and at some time you may decide to change it to a different shape. You don't need to delete the shape; you can simply pick a different one that Excel should use, as described here.Excel allows you to work with predefined shapes. In Excel 2007 these are called (oddly enough) shapes. There may be times when you want to completely change a shape from one to another. For instance, you may want to change one banner shape to another. While you can simply delete your original shape and then draw a new one, Excel makes it easy to change shapes.
- Select the shape you want to change. Handles appear around the outside of the shape.
- Make sure the Format tab of the ribbon is displayed.
- In the Insert Shapes group, click Edit Shape tool and then click Change Shape. The familiar palette of shapes appears.
- Select the shape you want to use.
Excel changes the shape used, without changing the overall size or shape of the bounding rectangle that contains the shape. You can then proceed to edit the new shape, as desired.
Related Tips:
Add a Professional Finishing Touch! Word includes great tools that allow you to add professional-grade finishing touches to your documents. You can add indexes, tables of contents, and other special tables by using the detailed information available in this volume. Check out WordTips: Indexes and Special Tables today!