Resetting Dynamic Menus

Summary: 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. (This tip works with Microsoft Excel 2000, Excel 2002, and Excel 2003.)

One of the new features introduced in Excel 2000 (and carried forward in subsequent versions) is something I call "dynamic menus." This means that Excel keeps track of which menu options you use the most, and these are the options it presents you. If you want to see all the menu options, you need to wait a few seconds, or click on the down-pointing arrows at the bottom of any menu.

If you want to reset the dynamic menus, so that Excel starts keeping track of your usage all over again, you can use these steps:

Choose Customize from the Tools menu. Excel displays the Customize dialog box.
Make sure the Options tab is selected. (Click here to see a related figure.)
Click the Reset My Usage Data button. (In Excel 2003 click the Reset Menu and Toolbar Usage Data button.)
Click on OK.

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

Organize Your Data! Using the powerful sorting capabilities of Excel can help you get your data into just the order you need. Find out how you can use the full capabilities of sorting to your benefit.

Check out ExcelTips: Serioius Sorting today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Resetting Dynamic Menus