Pin or keep a file on the Recent Document list in Excel 2007

The Recent Documents list shows the files that you recently opened. The file that is recently opened will appear on the top of the list. If the list is full and when you open a file that is not present in the current list then the last entry in the list will be removed to make room for the recently opened file. If you need to have a file appear always on the Recent Documents list then you can do so by performing the following:

1. Open Microsoft Excel.
2. Click the Microsoft Office Button . In the Recent Documents list, click the Pin this document to the Recent Documents list button .

When you pin a document, the button changes to a push pin. You can click the push pin button to unpin from the Recent Document list.

Clear the list of Recent Documents in Excel 2007

In Excel 2007, by default 17 documents are listed under Recent Documents. You can change this number to a value ranging from 0 to 50. If you had entered zero then the list is cleared and no recent files will be displayed under Recent Documents. Perform the following steps to clear the list of Recent Documents:

1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.
3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, under Display, enter 0 in the Show this number of Recent Documents: box.
5. Click OK.

Change the number of Recent Documents in Excel 2007

When you click the Microsoft Office Button , you will see New, Open, Save, Save As and so on. To the right, you will use the files that you recently opened under the Recent Documents list. By default, 17 files are displayed. You can change this number to a value from 0 to 50. To change the number of Recent Documents, perform the following steps:

1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.
3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, under Display, enter a value from 0 to 50 in the Show this number of Recent Documents: box or click the UP arrow or DOWN arrow buttons to increase or decrease the number of files.
5. Click OK.

Note:
If 0 is entered in the Show this number of Recent Documents: box then you will have no files displayed under Recent Documents.