Tips, Tricks, and Answers
The following articles are available for the 'Menus' topic. Click the article''s title (shown in bold) to see the associated article.
Adding Items to a Context Menu
Context menus can be very helpful for presenting common operations you can perform, based on the context in which the menu is displayed. Here's how you can add your own items to the Context menus used by Excel.
Adding Your Own Menu Items
Want to really make Excel reflect how you work? Why not make some changes to the menu structure so that the menus have your commands where you want them? This tip explains how you can use the Customize dialog box to add your own new menu items, such as one to run a macro.
The menus used in Excel can be animated in several different ways. All it takes is a quick change to the Excel options.
Changing the Shortcut Menu
If you want to change the Context menus used in Excel, on purpose, here's how to go about it. Just create a macro and make the change to the controls on a CommandBar.
Deleting Menu Items
Excel allows you to customize your menus so that they contain the commands you want on them. If you later want to delete an item you previously added to a menu, you'll need the info in this tip.
Making Short Work of Menu Names
If your menu bar has become cluttered due to different add-ins you've added, you can free up space by shortening the menu names. This tip shows just how easy it is.
Moving Items On a Menu
Want your copy of Excel to reflect the way you want to work with the interface? Fortunately, you can modify where various menu options appear. This can help you ensure that Excel is more suited to the way you work.
Problem with Missing Context Menu Option
When you right-click a cell, does it seem that the Context menu is missing an item or two? Here's how to get those items back.
Removing Items from a Context Menu
Context menus appear when you right-click an item in Excel. If you want to modify the menu that appears, the way to do so is not immediately evident. (You can't do it manually, like you can with other menus.) This tip explains how you can go about removing an item from a Context menu, and provides some great pointers to additional information available on the Web.
Resetting Dynamic Menus
Excel's menus, by default, only display the most common commands that you use. After a time you may want to reset the usage information that controls which commands are displayed. This tip explains how you can perform this task.
Resetting Excel Menus
Excel allows you to easily change what appears on its menus. If you later want to return to Excel's default menu structure, you need the information in this tip.