Menus

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 appear when you right-click on items in a worksheet. They are not the easiest things in the world to change, but you can change them through the use of some macro code. This tip explains how you can build such customizing flexibility into your macros.

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.

Animated Menus
The menus used in Excel (well, those before Excel 2007) 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 a user to delete unused menu items.

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
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.

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
Getting rid of custom menus by resetting them through Excel's Tool menu.