How to Clear Recent Documents in Excel (3 Effective Ways)

Get FREE Advanced Excel Exercises with Solutions!

The article will show you how to clear recent documents in Excel. It’s pretty annoying that the workbook fills up with the recent documents that we used earlier in Excel. This is often unnecessary and unwanted. To get rid of this problem, I’ll provide some solutions in the following sections of this article. We can clear all the recent documents in one click using some Excel features.

Table of Contents hide

3 Ways to Clear Recent Documents in Excel

1. Using Excel Options Feature to Clear Recent Documents

2. Clear Unpinned Workbooks Applying ‘Remove from List’

3. Implementing VBA to Clear Recent Documents

Conclusion

3 Ways to Clear Recent Documents in Excel

In this article, you will see 3 different processes to clear recent documents in Excel. All of them are easy and efficient to apply. You can apply these methods regardless of which version of Excel you are using. No matter, if you are using Excel 2007 or Excel 2010 or Excel 2013, or more recent versions like Excel 2019 or Excel 2021, or Excel 365.

1. Using Excel Options Feature to Clear Recent Documents

This method clears all the recent documents and at the same time prevents any recent documents from being saved. Please follow the instructions below.

Steps:

First, go to the File.

After that, you will see a lot of files that you used recently or even a long time ago.
To remove them from the list, click on Options.

Next, in the Excel Options window, select Advanced and then go to the Display.
Later, set ‘Show this Number of Recent Workbooks’ to 0 (zero).
Thereafter, click OK.

Finally, you will see all the recent documents removed from the history.

Thus, you can clear recent documents in Excel by using the Options feature. If you open new workbooks, the Recent tab of the Excel workbook will still be empty because of this command.

Similar Readings

2. Clear Unpinned Workbooks Applying ‘Remove from List’

We can use the Remove from List or Clear Unpinned Workbooks function to clear recent documents. Let’s have a look at the following procedure.

Steps:

First, go to the File menu and then go to the Recent tab.
Right-click on any of the recent documents that you want to remove and select Remove from List.
This command will remove that recent document

Thereafter, if you want to clear all the recent documents, go to More Workbooks. You will find this option at the right bottom corner of the Recent Tab.

Next, in the Workbooks Tab, right-click on any of the recent documents and select Clear unpinned items.

This command will lead you to a warning message. Just click Yes.

After that, you will see all the recent documents removed from the history.

Thus, you can clear recent documents in Excel by using the Remove from List or Clear Unpinned Items function.

Read More: How to Clear Excel Temp Files (3 Quick Ways)

3. Implementing VBA to Clear Recent Documents

We can also use Microsoft Visual Basic for Applications (VBA) to clear recent documents in Excel. Let’s go through the process below.

Steps:

First, go to the Developer Tab and then select Visual Basic.

After that, the VBA editor will appear. Select Insert >> Module to open a VBA Module.

Now, type the following code in the VBA Module.

Sub ClearRecentDocuments()
On Error Resume Next
Do Until Err.Number <> 0
Application.RecentFiles.Item(1).Delete
Loop
End Sub

The code uses a Do Loop statement to remove all the recent documents from the history.

After that, go back to your sheet and run the Macro named ClearRecentDocuments.

Next, go to the File You will see all the recent documents removed from the history.

Thus you can clear recent documents by using VBA.

Conclusion

In the end, we can conclude that you will learn some basic ideas of how to clear recent documents in Excel after reading this article. If you have any better suggestions or questions or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles. For more queries, kindly visit our website ExcelDemy.