excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

ExcelTips
Health Tips
Home Tips
Pet Tips

Newest Tips

Changing a Link's Source

Using Conditional Formatting to Shade Rows

Editing by Moving and Copying

Making Sure Duplicate Names Aren't Entered

Applying a Conditional Format to a Full Row

Hiding Worksheet Tabs

Making Cells Flash

 

Specifying the Number of MRU Files

Summary: MRU (most recently used) files can be a great help when you work with a given set of common workbooks. Excel allows you to easily adjust the number of MRU files it tracks for you.

Excel can easily keep track of a the last several workbooks you've edited. This list of files is often referred to as the MRU (most recently used) file list. Excel allows you to specify, exactly, how many files you want tracked in this list. You can change the number of MRU files by following these steps:

  1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
  2. Click Advanced at the left side of the dialog box.
  3. Scroll through the available options until you see the Display section. (Click here to see a related figure.)
  4. Use the control labeled Show this Number of Recent Documents to indicate how many files you want to appear in the MRU list. (You can set a value up to 50.)
  5. Click OK.

Related Tips:

Save Time! WordTips has been published weekly since early 1997. Past issues are available in convenient WordTips archives. Have your own enhanced archive of WordTips at your fingertips, available to use at any time! Check out WordTips Archives today!