Excel.Tips.Net ExcelTips (Menu Interface)

Displaying the AutoShapes Menu

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:

  1. Display the Drawing toolbar. (Click on the Drawing option on the Standard toolbar.)
  2. Click on the AutoShapes option on the Drawing toolbar. The AutoShapes menu appears.
  3. Position the mouse pointer over the bar at the top of the AutoShapes menu.
  4. Click and drag the AutoShapes menu away from the Drawing toolbar.
  5. Release the mouse button. You now have a floating AutoShapes menu. (See Figure 1.)
  6. Figure 1. The AutoShapes menu.

The other method of displaying the floating AutoShapes menu is even a bit simpler:

  1. Choose Picture from the Insert menu. Excel displays a submenu.
  2. 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 97, 2000, 2002, and 2003.

Related Tips:

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 5+3 (To prevent automated submissions and spam.)
           Commenting Terms

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!)

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.