Welcome toExcel.Tips.Net
Helpful Links
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Newest Tips
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
Subscribe
RSS Feeds
Daily Nuggets (an ExcelTip every day)
Allen Wyatt's ExcelTips (the weekly classic)
Displaying the AutoShapes Menu
Summary: How to undock the AutoShapes menu to make it more accessible for placing multiple shapes in an Excel worksheet. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)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:
- Display the Drawing toolbar. (Click on the Drawing option on the Standard toolbar.)
- Click on the AutoShapes option on the Drawing toolbar. The AutoShapes menu appears.
- Position the mouse pointer over the bar at the top of the AutoShapes menu.
- Click and drag the AutoShapes menu away from the Drawing toolbar.
- Release the mouse button. You now have a floating AutoShapes menu. (Click here to see a related figure.)
The other method of displaying the floating AutoShapes menu is even a bit simpler:
- Choose Picture from the Insert menu. Excel displays a submenu.
- Choose AutoShapes from the submenu. Excel displays both the Drawing toolbar and the floating AutoShapes menu.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3250) applies to Microsoft Excel versions: 97 2000 2002 2003
More Power! For some people, the prospect of creating macros can be scary. Those who conquer their fears, however, find they become much more confident and productive once they learn how to make Excel do exactly what they want. ExcelTips: The Macros is an invaluable source for learning Excel macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of ExcelTips. Learn at your own pace, exactly the way you want.Check out ExcelTips: The Macros today!