This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2007 - Modify or Disable Recently Used Documents List

By default, when you click the Office button, Microsoft Excel 2007 displays a list of recently-edited documents. If you often work on the same spreadsheets, instead of having to click "Open", navigate your hard drive or network hard drive, and then find the correct file, Excel 2007 provides easy-to-use shortcuts.

Depending on your needs, if you regularly edit or view a large variety of spreadsheets, you may want Excel 2007 to remember even more documents than it does by default.


Displaying the most recently-used Excel 2007 spreadsheets

Alternatively, if you are privacy and security-conscious, or if you share your computer with others, you may wish this recently-used file list hidden. In some instances, even accidentally listing recently-used files to office cubicle passer-bys may prove problematic.

To change Excel 2007's behavior:

1. Access the Microsoft Excel 2007 Options menu.

2. When the "Excel Options" dialog box appears, click "Advanced" in the left pane.

3. In the right pane, scroll down to section "Display".

4. Next to "Show this number of Recent Documents" enter the number of document names you wish Excel 2007 to remember. 50 is the maximum, 0 is the minimum (disable showing any recent documents). Note that if you have selected to show more documents than can be viewable onscreen, Excel will automatically truncate the list.


Configuring Excel 2007 to only show the most six recently-edited documents

5. Click "OK" to close the dialog box and save your configuration changes.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2007 - Modify or Disable Recently Used Documents List.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.