Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
Cooking Tips
ExcelTips (menu)
ExcelTips (ribbon)
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
School Tips
Wedding Tips
WordTips (menu)
WordTips (ribbon)

Advertise on the
ExcelTips Site

Newest Tips

Working with Imperial Linear Distances

Counting Unique Values

Incomplete and Corrupt Sorting

Quickly Removing a Toolbar Button

Returning the MODE of a Range

Deriving High and Low Non-Zero Values

Counting Cells with Specific Characters

 

Turning Off the MRU List

Summary: If you do not use the MRU list in Excel, use this tip to turn them off. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

If you pull down the File menu, you may notice a list of files at the bottom of the menu. These files represent the most recently used (MRU) Excel spreadsheets. This file list provides a quick way for you to access your files. Some people don't like the file list, however. Either they never use it, or they feel it complicates the File menu too much. If you are one of those people, you can disable the file list feature of Excel. This is done by following these steps:

  1. Choose Options from the Tools menu. You will see the Options dialog box.
  2. Make sure the General tab is selected. (Click here to see a related figure.)
  3. Make sure the Recently Used File List check box is cleared.
  4. Click on OK.

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

Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.
 
Check out ExcelTips Premium today!