Turning Off Dynamic Menus

by Allen Wyatt
(last updated May 26, 2017)

Excel, starting with Excel 2000, employs a feature I refer to as "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 hover the mouse pointer over a menu for a few seconds, or click on the down-pointing arrows at the bottom of any menu.

Dynamic menus can make it a bit easier to get to the choices you make most often, but there is a drawback: It is more difficult to see all the menu-based capabilities of Excel. If you want to turn off this feature (thereby making Excel's menus behave as they did in previous program versions), follow these steps:

  1. Choose Customize from the Tools menu. Excel displays the Customize dialog box.
  2. Make sure the Options tab is selected. (See Figure 1.)
  3. Figure 1. The Options tab of the Customize dialog box.

  4. Clear the check box to the left of the Menus Show Recently Used Commands First option. (In Excel 2003, select the Always Show Full Menus check box.)
  5. Click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3311) applies to Microsoft Excel 2000, 2002, and 2003.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Single Instance of Word

Here's a nifty macro that allows you to limit how many instances of Word 97 are open at the same time.

Discover More

Filtering a Discussion

See exactly what you want to see during your Discussion.

Discover More

Counting Unique Values with Functions

Using Excel to maintain lists of information is not unusual. When working with the list you may need to determine how many ...

Discover More

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!

More ExcelTips (menu)

Using a Single Instance of Excel with Two Monitors

Working on a computer system that has multiple monitors can help increase your productivity. If you want to work with ...

Discover More

Viewing Workbook Statistics

Excel keeps track of a range of stats about each workbook you use. If you want to take a look at those stats, it's easy; just ...

Discover More

Generating Random Testing Data

Need to test your formulas? Then you need some testing data that you can use to see if the formulas function as you expect. ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 8Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is eight more than 8?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.