Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Creating a Shape.

Creating an AutoShape

by Allen Wyatt
(last updated September 28, 2013)

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.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2324) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Creating a Shape.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Finding Long Sentences

For certain types of writing, you may want to make sure that the sentences in your document do not exceed a certain limit. ...

Discover More

Importing a Subset of Records

If you only want to import a portion of whatever records are in a text file, Excel provides a number of ways you can ...

Discover More

Thoughts and Ideas on Significant Digits in Excel

Ruminations and reflections about significant digits in Excel. Includes examples of how significant digits can affect the ...

Discover More

Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!

MORE EXCELTIPS (MENU)

Using the Camera in VBA

The camera tool allows you to capture dynamic "pictures" of portions of a worksheet. If you want to use the camera tool from ...

Discover More

Hiding Objects

If you are bothered by different objects visible in your worksheet, you'll want to turn them off so they aren't displayed. ...

Discover More

Setting Default Attributes for Lines and Arrows

Don't like the way that Excel formats lines and arrows? You can easily make your own formatting changes, and then use your ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share