Moving Items On a Menu

Summary: Excel allows you to completely customize the menus in the program. This tip shows just how easy it really is to move menu items around on a menu. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Excel is quite flexible, in that it allows you to completely customize the appearance of its interface. For instance, you may want to move items around on your menus. You can move menu options around to different locations on the same menu, or to a different menu altogether. This is done very easily by using the Customize dialog box:

Choose Customize from the Tools menu. Excel displays the Customize dialog box. (Click here to see a related figure.)
Click on menu names to display the menus.
When you see the menu option you want to move, click it and drag it to a new location. You can either drag it to the same menu or to a different menu; it doesn't make any difference.
When you reach the new location where you want the menu option to reside, release the mouse button. The option is moved and the menus are updated.
Repeat steps 2 through 4, as desired.
Click on Close (in the Customize dialog box) to save your changes.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2720) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Your Data, Your Way! Want the greatest control possible over how your data appears on the page? Excel's custom formats can provide that control, and ExcelTips: Custom Formats can unlock the secrets to creating your own custom formats.

Check out ExcelTips: Custom Formats today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Moving Items On a Menu