MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Autoshapes


February 05, 2002 - by Bill Jelen

MrExcel is so impressed with the ease of use of this new freebie from Microsoft, it becomes this week's Excel tip.

(Excel 97 only) Free Drawing 98 application from Microsoft to jazz up the drawing toolbar with 139 easy to use symbols for Excel.

AutoShapes and Drawing Tools

After installing this application from the Microsoft web site, you will be able to easily add cool symbols of any size and color to Excel, Word and other Office applications.

In Excel, select Insert, Picture, Autoshapes from the menu. You will be presented with an Autoshape toolbar with shapes organized into 7 categories: lines, connectors, basic shapes, block arrows, flowchart, stars and banners, and callouts. Select any shape, then click and drag to insert the shape into your worksheet.

To format the shape with cool colors or textures, simply right-click the shape, and pick Format Auto Shape. Select the "Fill" dropdown box and click either "More Colors" or "Fill Effects". Use the "texture" tab on the fill effects dialog to pick from several cool textures.

If you have the Office Valupack, you can find other textures in the \valupack\textures directory of the CD.


Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.