How to Control Excel Recent Files: Change Display Count and Clear for Privacy

Excel shows a list of recently opened files for quick access. This list appears in the File > Open menu and the Backstage view. The default number of files shown can be too many or too few for your workflow. You may also need to clear this list for privacy or to declutter the menu. This article explains how to adjust the display count and remove file history from Excel.

How the Recent Files Feature Works

Excel tracks the files you open and saves their paths in the Windows registry. This data is used to populate the Recent list under the Open tab. The list is specific to your user account on that computer. Changing the display count or clearing the list only affects your local Excel application. It does not delete the actual workbook files from your storage.

The feature is designed for convenience, but it can show sensitive file names or create visual clutter. You need to access the Excel Options dialog to manage its settings. The changes take effect immediately after you click OK in the options window.

Steps to Adjust the Recent Files List

You can change how many files appear or remove specific entries. Follow these steps to configure the list.

Change the Number of Files Displayed

1. Open Excel Options
   Launch Excel and click the File tab on the ribbon. Select Options at the bottom of the navigation pane.
2. Navigate to Advanced Settings
   In the Excel Options dialog, click Advanced in the left-hand sidebar. Scroll down to the Display section.
3. Set the Show this number of Recent Documents
   Locate the text box next to this option. The default value is 25. You can enter any number from 0 to 50. Type 0 to hide the list completely. Type a lower number like 10 to show fewer files.
4. Apply the Change
   Click the OK button at the bottom of the dialog. The change is applied instantly. Open the File tab again to see the updated list length.

Clear the Entire Recent Files List

1. Open Excel Options
   Click File and then select Options from the menu.
2. Go to the Advanced Section
   Select Advanced from the list on the left side of the Excel Options window.
3. Find the Clear Button
   Scroll to the Display section. Below the Show this number of Recent Documents setting, you will see a button labeled Clear.
4. Clear the List
   Click the Clear button. A confirmation dialog does not appear. The list is cleared immediately. Click OK to close the Excel Options window.

Remove a Single File from the List

1. Open the Recent Files List
   Click the File tab. The Recent list is shown by default in the main pane.
2. Locate the Target File
   Scroll through the list of pinned and recent documents. Find the file you want to remove.
3. Right-Click the File Name
   Move your mouse cursor over the file name. Right-click on the file name to open a context menu.
4. Select Remove from List
   From the context menu, click the option that says Remove from list. The file entry disappears from the view immediately.

Common Mistakes and Limitations

Certain actions do not work as expected when managing recent files. Be aware of these points to avoid confusion.

Clearing the List Does Not Delete Files

The Clear button only removes the file paths from Excel’s memory. It does not delete the actual .xlsx or .xls files from your hard drive or cloud storage. Your documents remain safe in their original locations.

The List is Not Synced Across Devices

If you use Excel on multiple computers, each device maintains its own recent files list. Clearing the list on your office PC does not affect the list on your home laptop. You must adjust the settings on each machine separately.

Pinned Files Are Not Affected by Clear

Files you have pinned to the top of the Recent list remain after you click the Clear button. To remove a pinned file, you must first unpin it by clicking the pin icon, then right-click and select Remove from list.

Clearing Methods Comparison

Item	Clear Entire List (Options Dialog)	Remove Single File (Right-Click)
Scope of action	Removes all unpinned recent files	Removes only the selected file
Speed	Fast, one-click operation	Fast, requires targeting a specific file
Pinned file handling	Does not remove pinned files	Can remove a pinned file after unpinning
Best for	Full privacy reset or major decluttering	Selective removal of sensitive or incorrect entries

You can now set your preferred number of recent files and clear the list when needed. For more control, explore the Trust Center settings to manage workbook metadata. A related advanced tip is to use the Windows Registry Editor to modify the recent files list for all Office applications at once, but this requires technical caution.