Excel shows recently opened files in the Recent list for quick access. Sometimes a file appears there that you no longer want to see. This list is managed by Excel’s application settings and Windows registry entries. This article explains how to clear a single file or the entire list from Excel’s backstage view.
Key Takeaways: Clearing the Recent Files List
- Right-click the file in the Recent list: Select ‘Remove from list’ to delete one specific entry.
- File > Options > Advanced > Display > Show this number of Recent Workbooks: Set the number to zero to clear the entire list.
- Clear the Windows Jump List: Right-click the Excel taskbar icon and clear the recent files shown by Windows.
How the Excel Recent Workbooks List Works
Excel maintains an internal list of file paths you have opened. This list appears under File > Open and sometimes on the startup screen. The list length is controlled by a setting. By default, Excel shows up to 50 recent documents. The list is stored in the Windows registry for the current user profile. Removing an item from the Excel interface deletes its entry from this storage. Windows 11 and Windows 10 also maintain a separate ‘Jump List’ for the Excel taskbar icon, which shows a similar recent files list.
Where the List Data is Stored
The primary list is in the Windows registry under the current user’s software settings for Microsoft Office. A secondary list is managed by the Windows shell for its Jump List feature. Changes made in Excel’s options affect the Office registry data. Clearing the Windows Jump List does not affect the list inside Excel’s File menu.
Steps to Remove Files From the Recent List
You can remove individual files or clear all items at once. Use the method that fits your goal.
Remove a Single Specific File
- Open Excel and go to the File tab
Click File in the top-left corner to open the backstage view. - Locate the Recent list
In the left pane, click Open. You will see the ‘Recent’ section with your workbooks. - Right-click the unwanted file
Find the file name you want to remove. Right-click on its name in the list. - Select ‘Remove from list’
Click this option from the context menu. The file entry will disappear immediately.
Clear the Entire Recent Workbooks List
- Open Excel Options
Go to File > Options. The Excel Options dialog box will open. - Navigate to Advanced settings
In the left pane of the dialog, click Advanced. - Find the Display settings
Scroll down to the ‘Display’ section within the Advanced options. - Change the number of recent workbooks
Locate the setting ‘Show this number of Recent Workbooks’. Change the number to 0. - Apply and confirm
Click OK to close the dialog. Reopen the File > Open view to see the list is now empty.
Common Mistakes and Limitations
Users often encounter these issues when managing the recent files list.
File Reappears After Reopening
If you remove a file but it comes back, you likely opened the file again after clearing it. Excel adds any file you open to the list. To keep it off the list, avoid opening it through Excel’s standard Open dialog after removal. You could open it via File Explorer instead, but it may still be added depending on your Excel settings.
Clearing the List Does Not Delete the Files
Removing entries only deletes the shortcuts or references in the list. The actual workbook files remain in their original location on your drive or network. This action is not a delete command for the file itself.
Windows Taskbar Jump List Still Shows Files
Excel’s internal list and the Windows Jump List are separate. To clear the Jump List, right-click the Excel icon on the Windows taskbar. Hover over the file name you want to remove and click the unpin icon, or choose ‘Clear list’ if available. This only affects the taskbar preview.
Excel Recent List vs. Windows Jump List
| Item | Excel Recent Workbooks List | Windows Taskbar Jump List |
|---|---|---|
| Location | File > Open in Excel backstage | Right-click Excel icon on taskbar |
| Control Setting | File > Options > Advanced > Display | Windows Settings > Personalization > Start |
| Clearing Method | Set number to zero or right-click remove | Right-click taskbar icon and clear |
| Data Storage | Windows Registry for Office | Windows Shell database |
| Maximum Items | 50 by Excel default | Set by Windows personalization |
You now know how to clean up your Excel recent files list. Use the right-click method for a single file or the Options dialog to clear everything. Remember that the Windows Jump List is managed separately. For a deeper clean, you can use the Windows Registry Editor to delete old entries, but back up the registry first.