Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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.

doc-clear-recent-file-list-1

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


arrow blue right bubble 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:

1. Open a workbook, and go to click File > Options (In Excel 2007. Click Office button > Excel Options), and in the Excel Options dialog box, please click Advanced from the left pane, and then scroll down to the Display section and change the number to 0 besides the Show this number of Recent Documents text box. See screenshot:

doc-clear-recent-file-list-1

2. Then click OK to close this dialog, and now when you go the Recent pane, all the recent document lists have been cleared at once, see screenshots:

doc-clear-recent-file-list-3 -2 doc-clear-recent-file-list-4

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.


arrow blue right bubble 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. Go to the recent document lists by clicking File > Recent in Excel 2010, or click File > Open > Recent Workbooks in Excel 2013.

2. Then in the Recent Workbooks list, right click and choose Clear unpinned Workbooks from the context menu, see screenshot:

doc-clear-recent-file-list-1

3. And a prompt box will pop out to remind you if you want to remove all the unpinned items from the list, click Yes button, and all the unpinned recent workbooks will be cleared at once.

doc-clear-recent-file-list-1

Notes:

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.


arrow blue right bubble 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.

2. Click Insert > Module, and paste the following code in the Module Window.

VBA code: remove the recent document lists

Sub Clearrecentfiles()
'Update 20140925
On Error Resume Next
Do Until Err.Number <> 0
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.


Recommended Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 71%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 82% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    M H · 5 months ago
    VBA - How do I remove a folder list name from the recent save as list in excel 2016?
    • To post as a guest, your comment is unpublished.
      Tom Archer · 2 months ago
      Did you ever figure this out? I have the same question.
  • To post as a guest, your comment is unpublished.
    Sajay Laloo · 1 years ago
    Right Click on Taskbar, click on Taskbar Setting then click on Start which is on the leftside of the page and then turn off the “Show recently opened items in Jump List on Start or the Task Bar.