Topic: Menus

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Deleting Menu Items Excel allows a user to delete unused menu items. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 2000 | 2002 | 2003

Resetting Excel Menus Getting rid of custom menus by resetting them through Excel's Tool menu. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Tips, Tricks, and Answers

An Amazing Resource!

Helpful Links

Great Info!

RSS Feeds