
Tips.Net > ExcelTips Home > Graphics > Creating an AutoShape
Summary: Excel includes some predefined shapes (called AutoShapes) that you can add o your worksheet. It’s easy to do once you discover how to access them through the Drawing toolbar. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
In addition to working with numbers and text within cells of a workbook, Excel allows you to highlight your worksheets by adding simple drawings. One classification of drawing objects you can add are called AutoShapes. In many respects AutoShapes can be considered simple drawing objects because they are very simple to create, even though they appear complex. Excel defines quite a few different AutoShapes (over a hundred), all selectable by clicking on the AutoShapes tool on the Drawing toolbar.
When you click on the AutoShapes tool you actually display a series of menus from which you can pick the shape you want. For instance, let's say you wanted to draw a heart. You would click on the AutoShapes tool, then choose Basic Shapes, and finally choose the heart shape.
Once you select a shape, you draw it by positioning the mouse pointer at one corner of where you want to place the shape, clicking the mouse button, and dragging until you reach the opposite corner. When you release the mouse button the shape appears on the screen.
Tip #2324 applies to Microsoft Excel versions: 97 2000 2002 2003
PivotTables Got You Perplexed? Learn the ins and outs of this powerful data-crunching tool. ExcelTips: PivotTables for the Faint of Heart makes it easy.
Add power to your purpose with Excel. A comprehensive 500+ page e-book explains everything you need to know about macros. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site