How to clear recent document lists from Excel?
The recent opened workbook lists will be stored in the Recent pane when we open an Excel file each time as following screenshot shown. But, sometimes, you need to clear such long boring workbook lists from the Recent pane. This article will show you how to make the recent document lists disappear.
Clear the recent document lists with Options feature Clear the recent document lists with Clear unpinned Workbooks function Clear the recent document lists with VBA code
Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
Clear the recent document lists with Options feature
To remove the recent document lists in Excel, you can go to the Excel Options to do a little setting. Please do as follows:
Note: If you want to restore the recent items, you can type the number back to the Show this number of Recent Documents text box in the Excel Options dialog.
Clear the recent document lists with Clear unpinned Workbooks function
You can also remove all the recent document lists by applying the Clear unpinned Workbooks feature.
1. After removing the recent document lists, they are not restored any more, and this method is only applied to Excel 2010, 2013.
2. This method only remove the unpinned files.
Clear the recent document lists with VBA code
The following VBA code can help you to remove all the recent document lists immediately as well.
1. Press the ALT + F11 keys together, and it opens the Microsoft Visual Basic for Applications window.
VBA code: remove the recent document listsSub Clearrecentfiles() 'Update 20140925 On Error Resume Next Application.RecentFiles.Item(1).Delete Loop End Sub
3. Then press F5 key to run this code, and all the recent document lists have been removed at once.
Note: With this code, the recent document lists cannot be restored.
Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails…
More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.