If you have used Excel for any length of time, chances are pretty good that you are already familiar with AutoShapes and how to add them to your worksheets. If you have quite a few AutoShapes to insert in a document, you may find it handy to work with a floating AutoShapes menu instead of using the AutoShapes option on the Drawing toolbar. There are two ways you can display the floating AutoShapes menu. The first involves the use of the Drawing toolbar to get started:
Figure 1. The AutoShapes menu.
The other method of displaying the floating AutoShapes menu is even a bit simpler:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3250) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Need to change a shape you previously added to your worksheet? It's easy to do using the graphics tools provided by ...
Discover MoreAdding a text box to a worksheet is easy. Making sure that text box is the exact size of a cell in the worksheet may not ...
Discover MoreNeed to export a graphics group from a chart so that you can use the group in a different program? It's not as easy as ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2017-01-27 11:34:50
Willy Vanhaelen
@walter
The last paragraph of this tip: This tip (3250) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Since Excel 2007 the stand alone tool bars don't exist any more. They are replaced by the ribbon remember :-)
2017-01-26 17:14:46
In 2010 Excel, shape tool is under Inset>illustration group. But I cannot select and pull it out to make a stand alone tool bar for "shape tool"
2017-01-26 17:13:13
walter
I'm using 2010 Excel. I see shape tool under Inset>illustration group. But I cannot select and pull it out to make a stand alone tool bar for "shape tool"
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.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2022 Sharon Parq Associates, Inc.
Comments